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