Processing of Oracle database startup times ORA-03113

Occurrence: Previously because the database query a simple statement is very slow, and then restart the machine resulting in file state may be inconsistent, because the normal shutdown database in conjunction with the verification of files, so that the time to restart the file point of view consistent. As a result, the database does not start properly, the machine restarts and the database starts as follows:

The solution found on the Web is as follows: Sql> Conn/as SYSDBA is connected to an idle routine. The Sql> startup Mount ORACLE routine has started. Sql> select * from V$log;

sql> recover database until time ' 2014-07-18 23:12:12 '-this point is based on the above log, select a normal working point in time to restore
Complete media recovery. sql> ALTER DATABASE open resetlogs;
The database has changed.

sql> Shutdown sql> Startup
The database has been started normally, and the data can be backed up properly.