Consult, described as follows:
1, archive mode, automatic backup control file open, back up the entire database and control files,
2, then the redolog and archivelog integrity, analog controlfile and lost datafile, restore the database,
Restore controlfile 3, the recovery process is: first, to restore the datafile,
Shutdown immediate;
Startup the mount;
Recover controlfile from autobackup.
Restore the database.
Recover the database.
The alter database open resetlogs;

Question:
A complete archivelog and redolog, can not fully recovered, but why the last open resetlogs when the database is still need?

CodePudding user response:

Add:
I check it on the data of, as long as with restoring controlfile, open the database when you need to use resetlogs,
But the resetlogs will rebuild redologs, early to make the redolog controlfile information,
That means that the database before preserved complete redolog meaningless?

CodePudding user response:

Focus is: you restored controlfile, recover the control file, if you don't use the current this controlfile of online, this is a live redo information is recorded, so need not resetlogs, but are you using the old control file, you must resetlogs, because the control file is now the latest redo information, explains understand?

CodePudding user response:

Resetlogs three scenarios of
The resetlogs incomplete recovery, is for the sake of the log to recover to the point in time after the transaction is empty, or to reset the SCN,
Using trace file to create the control file and log file does not exist or damage when using resetlogs, at this time is to regenerate the log,
Using backup control file, is to reset the log sequence at this time, because the serial number of the log records in the control file (log sequence number to 10 at this time of the control file and record the serial number is 5, at this point is out of sync, you need to use the resetlogs to reset the log sequence),

CodePudding user response:

The key is whether you to recreate the redo log, otherwise, you can try the noresetlogs,
In addition, your tests, returned to the library, that is must resetlogs,