This content has been marked as final. Show 5 replies
I suggest close your issue here as answered than move your issue Forum Home » High Availability »RMAN which you can get more quick response.
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
If you lose your control file than its mean you need to restore your control file which belong to 3am, than RMAN automaticly notice that archivelog(which has timestamps) until time which you are givin. End of the process you need to open your db open resetlog
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
Hi paveen / all
Missed out this point. But im using rman catalog to store backup information.
So i shud still be able to perform pit recovery to latest arch log using restored ctl file at 3am?
And after which manual apply the transactions of latest redo log? Tks