|
-
The second option will leave your DB in an inconsistent state. All the headers of Datafiles will not be in Sync.
It is an incomplete recovery. For example if you have logs say 1500 to 1800, current log # is 1801. you recover db using cancel based recovery upto say 1750. Now the logs 1751 to 1800 are good for nothing. If you are in a recovery situation at a later point of time, You'll need all the logs including the 50.
That's the reason we start the DB using Reset Logs which resets the log sequence to 1. You cannot bring the DB to a consistent state until you do all these operations after shutting down.
------
In the First Case, you are trying to completely recover the TBS to bring it to a state consistent with the information in the control files. If it succeeds then your log numbers will be the same. If it fails, then you'll have to go to the second type of recovery.
I'll leave the judgement to gurus.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|