In case of incomplete recovery using backup control file in order to open the database you must have issue ALTER DATABASE OPEN RESETLOGS option. Now question is what RESETLOGS does? In the following section it is demonstrate what it does.
1)It creates a new incarnation of the database. You can say a new version of database life is produced. To know more about incarnation search within my blog.
2)If the current online redo logs are accessible then archive those, erases the contents of the online redo logs and resets the log sequence number to 1. You can see current log sequence number from V$LOG. SQL> SELECT SEQUENCE#, GROUP# FROM v$log;
3)If online redo log files are not exist then create online redo log files.
4)Re initializes the control file metadata about online redo logs and redo threads.
5)Updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
No comments:
Post a Comment