Assuming, my system crashed on Tue 3pm and I have a copy of Mon night online backup and all archived logs upto Tues 3pm. My recovery process will be:
a. Rebuilt the hardware and OS
b. Reinstall new SAP and Oracle instance
c. Restore Mon night online backup (overwrite the existing sapdata and controlfile) and archived logs
d. Recover using the archived logs.
My question is, up to which point I may recovery ?
My understanding is I can only recover up to Mon night, even though I have the archived redo logs up to Tues aft, as the status of the controlfile (log seq #) after the restore will be as on Mon night. So will Oracle will not know how to use the redo logs after the Mon online backup ?
Can someone help me my doubts ?