recovery after shutdown abnormal
165379May 19 2004 — edited May 21 2004This it a question that I have asked before too but somebody suggested me to go through 9i documentation. I have gone through it but again I have the same question.
When the oracle shutdowns abnormally it needs current redo log file to recover while opening the database after abnormal shutdown.
Now a question is that suppose my redo log files are of sizes 1mb each and before shutting down the oracle I have executed a big transaction of size 3mb and the abnormal shutdown occurred after completing of 2.5mb transaction. That mean two times redo log switches occurred and the current redo log has .5mb of transactions only.
Now, if I open the database, it read the current redo log and rollbacks but there is the information of .5mb only. How will it rollback up to beginning (2.5mb)?