Let's say I have a rman backup to tape (full backup, controlfile, archivelogs) taken at 3am this morning.
At 6pm, someone accidentally deleted the datafiles and controlfiles and the db crash. Archivelogs, redologs are still there.
If i restore the controlfile and datafiles from the 3am backup and do a recover database, am i still able to perform a point in time recovery? (including the transactions in redolog). If yes, how is the controlfile able to know which archive logs to apply?
Or do i need really need the current controlfile to perform recovery up to the crash time?
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.
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)
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