9/04/2012

Oracle:applying redolog files

Essential procedure for applying redolog files in Oracle db.

 sqlplus '/as sysdba'

RECOVER DATABASE USING BACKUP CONTROLFILE UNTIL CANCEL;

Choose files for applying after last file enter CANCEL

ALTER DATABASE OPEN RESETLOGS;

Checking that resetlogs were applyed correctly

SELECT * FROM "any_small_table";
SHUTDOWN IMMEDIATE;
STARTUP;

No comments:

Post a Comment

Popular Posts