Applying redolog files in Oracle
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;
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment