Saved Bookmarks
| 1. |
Why We Should Need To Open Database Using Resetlogs After Finishing Incomplete Recovery? |
|
Answer» When we are performing incomplete recovery it means we bring database to past time or REWIND PERIOD of time using change based, cancel based or time based recovery. These all recovery make database in prior state of database. The forward SEQUENCE number already available after performing recovery, due to mismatching of this sequence numbers and prior state of database, it needs to open database with new sequence number of Redo LOG and archive logs. When we are performing incomplete recovery it means we bring database to past time or rewind period of time using change based, cancel based or time based recovery. These all recovery make database in prior state of database. The forward sequence number already available after performing recovery, due to mismatching of this sequence numbers and prior state of database, it needs to open database with new sequence number of Redo log and archive logs. |
|