When the server is shut down, the database cannot be shut down due to an unknown reason, so we have to use the force command shutdownabort. However, if the Oracle database cannot be opened, it always reports
When the server is shut down, the database cannot be shut down due to an unknown reason, so you have to use the force command shutdown abort. However, if the Oracle database cannot be opened, it always reports
When I shut down the server today, the database could not be shut down due to inexplicable reasons, so I had to use the Forced Command shutdown abort; but casually Oracle database could not open, always reported "ORA-03113: the "end" of the file in the communication channel is incorrect. The analysis may be caused by the database being closed immediately, which may result in inconsistent file statuses. If the database is closed normally, the files will be verified synchronously, in this way, when the files are restarted at the same time, and no crash recovery is required, we have to perform the following restoration. We recommend that you observe the IO status on the OS in the future when using the abort option, disable it when the IO value is 0 or close to 0 to avoid unexpected errors. (My environment is Oracle 11g, CentOS 5.4)
SQL> startup mount;
The ORACLE routine has been started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 637536288 bytes
Database Buffers 188743680 bytes
Redo Buffers 6606848 bytes
The database has been loaded.
SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-03113: End of the file for the communication channel
Process ID 4272
Session ID: 125 serial number: 5
SQL> conn'/as sysdba'
Already connected to the idle routine.
SQL> startup mount
The ORACLE routine has been started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 637536288 bytes
Database Buffers 188743680 bytes
Redo Buffers 6606848 bytes
The database has been loaded.
SQL> select * from v $ log;
GROUP # THREAD # SEQUENCE # BYTES BLOCKSIZE MEMBERS ARC
---------------------------------------------------------------
STATUS FIRST_CHANGE # FIRST_TIME NEXT_CHANGE # NEXT_TIME
---------------------------------------------------------------------
1 1 97 52428800 512 1 NO
INACTIVE 12980317 month-10 12988303 month-10
3 1 99 52428800 512 1 NO
CURRENT 12991762-9-10 2.8147E + 14
2 1 98 52428800 512 1 NO
INACTIVE 12988303 month-10 12991762 month-10
SQL> alter database open resetlogs;
Alter database open resetlogs
*
Row 3 has an error:
ORA-01139: The RESETLOGS option is valid only after Incomplete Database recovery
SQL> recover database until time '2017-09-09 1:45:02 ';
Media recovery is completed.
SQL> alter database open resetlogs;
The database has been changed.
SQL> shutdown
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup
The ORACLE routine has been started.
Total System Global Area 835104768 bytes
Fixed Size 2217952 bytes
Variable Size 637536288 bytes
Database Buffers 188743680 bytes
Redo Buffers 6606848 bytes
The database has been loaded.
The database has been opened.
SQL>