Thanks for the question, NagaKrishna.
Asked: February 27, 2017 - 3:38 pm UTC
Last updated: March 02, 2017 - 2:56 am UTC
Version: 11.2.0.4
Viewed 1000+ times
You Asked
Hi Tom,
As we all know we need to open up db with resetlogs when ever incomplete recovery done.
1)why we need open up database with resetlogs after rename the database using control file method or using nid tool?
2)and what more situations need to open up db other than incomplete recovery and why?
and Connor said...
The control file tells us critical information about the database, ie, the information we'd need to recover it (archives, datafiles, scn, etc).
Anything that "severs" that link between control file and the rest of the database will probably require a resetlogs, eg
- nid/rename/etc
The database files say "I'm a db called X" and the control file says "I'm db called Y" - we've lost that linkage.
- recovery with backup control file
The database says "My redo logs are at change X", the (now old) control file says "I think the redo logs are at change Y", we've lost that linkage.
The resetlogs is basically our way of saying "Ok...lets all get back in sync and start again from here"
Rating
(2 ratings)
Is this answer out of date? If it is, please let us know via a Comment