Oracle RMAN Question: Download RMAN PDF
Explain the steps to perform the point in time recovery with a backup which is taken before the resetlogs of the db?
Answer:
RMAN can perform recovery of the whole database to a specified past time, SCN, or log sequence number. This type of recovery is sometimes called incomplete recovery because it does not completely use all of the available redo. Incomplete recovery of the whole database is also called database point-in-time recovery (DBPITR).1. Rman> RUN{ SET UNTIL TIME 'Nov 15 2002 09:00:00'; # SET UNTIL SCN 1000; # alternatively, specify SCN # SET UNTIL SEQUENCE 9923; # alternatively, specify log sequence number RESTORE DATABASE; RECOVER DATABASE;}
| Previous Question | Next Question |
| What is hot backup and what is cold backup? | How to verify the integrity of the image copy in RMAN environment? |