Oracle Database startup reports ORA-03113 error resolution, oracleora-03113

Oracle Database startup reports ORA-03113 error resolution, oracleora-03113

Scenario:

Previously, a simple statement for database query was slow, and the file status may be inconsistent when the machine is restarted, because the database is shut down and the files are verified synchronously, so that the file time points are consistent during the restart. As a result, the database cannot be started normally. After the machine is restarted, the database is started as follows:

The solution found on the internet is as follows:

SQL> conn/as sysdba

Already connected to the idle routine.

SQL> startup mount

The ORACLE routine has been started.

SQL> select * from v $ log;

SQL> recover database until time '2017-07-18 23:12:12 '-- this time point selects a normal working time point based on the time shown in the preceding log for recovery.

Media recovery is completed.

SQL> alter database open resetlogs;

The database has been changed.

SQL> shutdown

SQL> startup

Now the database has started properly and data can be backed up normally.