This content has been marked as final. Show 5 replies
I assume you would like to restore and recover the database up to the point of time right before the file was dropped.
It's possible to do so using backup control file. You'll have to open database with RESETLOGS option after such recovery.
RMAN will try to automatically restore necessary archived logs/use existing archived logs in your current archivelog destination based on their sequence number.
Edited by: Max Seleznev on Feb 6, 2013 10:40 AM
When you don't have current controlfile (using backup controlfile), then it definitely leads to incomplete recover till last known scn or until time.
Controlfile, knows the files (where the archives are placed /redo logs, so it would refer / access those files as part of recovery)
- Pavan Kumar N