Prior to Oracle 10g, the redo log files generated after opening the database with RESETLOGS could not be used with the backups taken before the RESETLOGS was performed.
Therefore, whenever a resetlogs was done, it was important to take an immediate full database backup, since all previous backups became invalid.
Just to recap, a RESETLOGS needs to be performed when we
1) Do a point in time recovery
2) Recover a database using a backup of the control file
What does a RESETLOGS do?
• Archives the current online redo logs (if they are accessible) and then erases the contents of the online redo logs and resets the log sequence number to 1.
• Creates the online redo log files if they do not currently exist.
• Updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp
The Recovery through Resetlogs feature provides the following benefits:
* There is no need to
Continue reading Recovery through RESETLOGS and reset of the incarnation of the database
Popular Posts