Steps to Recover a 11g Database
632013Jul 6 2010 — edited Jul 6 2010hi experts,,
This is 11.2 g on Windows.
The db is in Archivelog mode but I do NOT use recovery catalog.
Users have been testing a new system. Soon I will need to perform a time-based recovery to scrap the data they recently updated.
I made a Level 0 backup, then a Level 1 backup just before they started testing.
Do these steps look good?
Rman>shutdown immediate;
Rman> startup mount;
Rman>set until time to_date('06-07-2010 10:48:00', 'dd-mm-yyyy hh24:mi:ss');
restore database;
recover database;
?? Some examples I've seen suggest doing a alter database open resetlogs as a final step. Should I do that OR just alter database open ??
Please advise.
Thanks, John