Wednesday, April 18, 2007

RMAN Incomplete Recovery

1-2-3 steps for incomplete recovery 
Assuming control file available.
Login to database server
Set oracle enviornment
startup database in mount mode
connect to database using RMAN to start the restore process
    rman target / nocatalog

Step 1
Restore Database

Step 2
recover database until time '2005-04-05 20:20:25' using backup controlfile;

Step 3
alter database open database resetlogs;