Server powered down, Oracle database failed to start solution

If the database is not backed up, the Oracle database startup error occurs after the server starts due to an accidental power outage.

1. The database does not open the archive mode

2. No backup

Solution:

1234567891011121314151617181920212223

SQL>startup mountSQL>recover database using backup controlfile until cancel;SQL>alter database open resetlogs;# 此时会提示system表空间需要恢复，但是由于当前日志损坏# 无法进行恢复，所以需要加入#隐含参数，oracle才不会监测scn# 的一致性，才能打开数据库。# 重启数据库加入隐含参数SQL> startup mountSQL> alter system set “_allow_resetlogs_corruption”=true scope=spfile;SQL> shutdown immediateSQL> startup mountSQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-01092: ORACLE instance terminated. Disconnection forced# 不管这些，再次登录sqlplus起动数据库SQL*Plus: Release 10.2.0.1.0 - Production on Fri Nov 16 08:03:43 2007Copyright (c) 1982, 2005, Oracle.  All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL>startup

Server powered down, Oracle database failed to start solution