After my cold backup was restored, there was a ora-01033:oracle initialization or shutdown in progress error in the connection database.
Ora-01033:oracle initialization or shutdown in progress means that the database is shutting down or initializing.
So
1, I first sql> shutdown immediate
Then sql> startup force
But there
ORA-01122: Database file 6 validation failed
ORA-01110: Data file 6: ' E:/oracle_databak/rman/catalog. DBF '
ORA-01207: Files Newer than control files-old control files
2, then rebuild the control file
Recover database using Backup controlfile;
Appear
ORA-00279: Change 962998 (generated at 08/22/2008 09:03:51) is required for thread 1
ORA-00289: Suggestions:
E:/oracle/product/10.2.0/flash_recovery_area/orcl/archivelog/2008_08_22/o1_mf_1_
16_%u_. ARC
ORA-00280: Change 962998 (for thread 1) in the sequence #16
Specify log: {<ret>=suggested | AUTO | CANCEL}
Enter the location of the log file in the window: e:/oracle/product/10.2.0/oradata/orcl/redo01. LOG
Appear
ORA-00310: Archive log contains sequence 14; Requirement Sequence 16
ORA-00334: Archive log: ' E:/oracle/product/10.2.0/oradata/orcl/redo01. LOG '
Input
Recover database using Backup controlfile;
Appear
ORA-00279: Change 962998 (generated at 08/22/2008 09:03:51) is required for thread 1
ORA-00289: Suggestions:
E:/oracle/product/10.2.0/flash_recovery_area/orcl/archivelog/2008_08_22/o1_mf_1_
16_%u_. ARC
ORA-00280: Change 962998 (for thread 1) in the sequence #16
Specify log: {<ret>=suggested | AUTO | CANCEL}
Enter e:/oracle/product/10.2.0/oradata/orcl/redo03. Log (note: Here is the location of your log file, there are several log slowly try)
Appear
The log that has been applied.
Complete media recovery.
Input detection
sql> ALTER DATABASE open resetlogs;
The database has changed.
sql> Select status from V$instance;
STATUS
------------
OPEN
Ok