ORA-01033: cancelinitializationorshutdowninprogress Solution

When the mongoel database is shut down abnormally, the control file, database file, or log file may be damaged, and the database cannot be properly loaded. This article uses Oracle

When the mongoel database is shut down abnormally, the control file, database file, or log file may be damaged, and the database cannot be properly loaded. This article uses Oracle

When the mongoel database is shut down abnormally, the control file, database file, or log file may be damaged, and the database cannot be properly loaded. This article uses the system recovery Command provided by Oracle to restore normal Database loading. The original organization uses the OA system used by the database for release el 9, after a hard disk failure replacement, the ORA-01033: Release El initialization or shutdown in progress error message appears.
Handling process
The following describes how to restore the control file and media using the command line:
C: \ Documents ents and Settings \ Administrator> sqlplus/NOLOG
SQL> connect dsoa/dreamsoft as sysdba
SQL> shutdown immediate
SQL> startup mount
The ORACLE routine has been started.
Total System Global Area 2351509956 bytes
Fixed Size 459204 bytes
Variable Size 536870912 bytes
Database Buffers 1811939328 bytes
Redo Buffers 2240512 bytes
ORA-00214 :???? 'D: \ ORACLE \ ORADATA \ DSOA \ CONTROL01.CTL '?? 5062 ???
'D: \ ORACLE \ ORADATA \ DSOA \ CONTROL02.CTL '?? 5053 ???
SQL> shutdown immediate
The error message "CONTROL01.CTL" and "CONTROL02.CTL" is displayed. Because the control file of cancel is redundant and three identical control files exist at the same time, when a control file fails for some reason, an alarm is reported. Therefore, select a copy and rename it to the other two before the backup to ensure that the three files are the same.

SQL> startup
The ORACLE routine has been started.
Total System Global Area 2351509956 bytes
Fixed Size 459204 bytes
Variable Size 536870912 bytes
Database Buffers 1811939328 bytes
Redo Buffers 2240512 bytes
The database has been loaded.
ORA-01113: file 2 requires media recovery
ORA-01110: data file 2: 'd: \ ORACLE \ ORADATA \ DSOA \ UNDOTBS01.DBF'
SQL> shutdown immediate
ORA-01109: the database is not open
The database has been detached.
The ORACLE routine has been disabled.
SQL>
SQL> startup mount
The ORACLE routine has been started.
Total System Global Area 2351509956 bytes
Fixed Size 459204 bytes
Variable Size 536870912 bytes
Database Buffers 1811939328 bytes
Redo Buffers 2240512 bytes
The database has been loaded.
SQL> recover datafile 2
ORA-00279: Change 471567853 (generated at 21:38:30) is required for thread 1
ORA-00289: Recommended: D: \ ORACLE \ ORA92 \ RDBMS \ ARC01546.001
ORA-00280: Change 471567853 for thread 1 is sequential #1546
Specified log :{ = Suggested | filename | AUTO | CANCEL}
ORA-00308: Unable to open archive log 'd: \ ORACLE \ ORA92 \ RDBMS \ ARC01546.001'
ORA-27041: Unable to open file
OSD-04002: Unable to open file
O/S-Error: (OS 2) the system cannot find the specified file.

,