992748 wrote:yes, if you have backups of everything else
I'm little newbie to RMAN recovery. Please help me in these doubts:
1. If I have datafiles, archive logs & control files backup, but current online REDO logs are lost, then can I perform incomplete database recovery ?
2. Till what maximum time/scn can incomplete database recovery be performed ??Assuming the only thing lost is the redo logs, you can recover to the last scn in the last archivelog.
3. What is role of online REDO logs in incomplete database recovery ?They provide the final redo changes - the ones that have not been written to archivelogs
Are they required for incomplete recovery ?It depends on how much incomplete recovery you need to do.
992748 wrote:I've never really thought about that question. I'd guess he has to get it from the file headers, and comparing to the control file.
Thanks a lot, your answer was indeed helpful.
Please clear my one more doubt..
If I recover my DB using command: 'recover database until time'
How does RMAN come to know the scn from which to start recovery and the stop scn for recovery ?
Does it only refer control file to get these SCNs or it refers datafile headers for this ?
Is there any good doc/link to understand this process.. ?