Step 1: Place the database in mount stage when you like to perform whole database recovery or open the database and offline the specified tablespace offline when performing tablespace recovery.
Step 2: Use SET UNTIL clause to perform incomplete recovery, that is recovery terminated up to the past time,SCN,restore point or log sequence number. Also you can use UNTIL clause with RESTORE and RECOVER command to perform incomplete recovery.
Step 3: Restore the files with RESTORE command.
Step 4: Recover the data files with RECOVER command.
Step5: Place the database in open stage if you did operation in MOUNT stage , or make the intended tablespace online if you placed tablespaces offline.
No comments:
Post a Comment