First to understand what the ALTER DATABASE open resetlogs mean, why use Resetlogs to open the database, this command issued after the Oracle has done?
The ALTER DATABASE open Resetlogs is to reset the redo log when the data is being opened, and the sequence of the redo log is about to reset to zero, why reset the redo log?
After incomplete recovery, the original online redo log contains data that was not pre-recovered, and the data is no longer valid for the restored database, so the database will require the sequence of the online redo log to be zeroed before open.
The Resetlogs command represents the end of a logical lifetime of a database and the beginning of another logical lifetime of a database, and the SCN is not reset each time the Resetlogs command is used, but Oracle resets the log sequence number and resets the online redo log content.
Oracle calls this database logical lifetime incarnation
Each time you use Resetlogs to open the database, you will make incarnation + 1, that is, to generate a new incarnation;
If you want to revert to the previous incarnation Scn/time, you need to revert to the previous incarnation;
For the above case, the specific is to first
Reset database to incarnation 2;
Try again not to fully recover
This article is from the IT dwarfs! "Blog, be sure to keep this provenance http://lqx049.blog.51cto.com/1919902/1714817
Incomplete reply-alter database open Resetlogs