00031.Oracle强断电后，oracle无法启动解决方案

00031.1:

SQL>create   pfile='/opt/oracle/product/10.2/db_1/dbs/pfilemdsp.ora'  from spfile

切到 oracle用户下oracle$>

vi  /opt/oracle/product/10.2/db_1/dbs/pfilemdsp.ora

加入： _allow_resetlogs_corruption=true

00031.2:

SQL>startup  pfile='/opt/oracle/product/10.2/db_1/dbs/pfilemdsp.ora' mount

ORACLE instancestarted.

Total System GlobalArea  805896192 bytes

Fixed Size                  2148680 bytes

Variable Size             486540984 bytes

DatabaseBuffers          310378496 bytes

Redo Buffers                6828032 bytes

Database mounted.

00031.3:

SQL> create  spfile from pfile='/opt/oracle/product/10.2/db_1/dbs/pfilemdsp.ora';  

File created.

00031.4:

SQL> shutdown  immediate;

ORA-01109: databasenot open

Databasedismounted.

ORACLE instanceshut down.

00031.5:

SQL> startup  mount;

ORACLE instancestarted.

Total System GlobalArea  805896192 bytes

Fixed Size                  2148680 bytes

Variable Size             486540984 bytes

DatabaseBuffers          310378496 bytes

Redo Buffers                6828032 bytes

Database mounted.

00031.6:

SQL> recover  database until cancel;

ORA-000283:recovery session canceled due to errors

ORA-01610: recoveryusing the BACKUP CONTROLFILE option must be done

00031.7:

SQL> recover  database until cancel using backup controlfile;

ORA-000279: change177948781 generated at 04/15/2010 09:24:35 needed for thread1

ORA-000289:suggestion :

/opt/oracle/flash_recovery_area/MDSP/archivelog/2010_04_15/o1_mf_1_4646_%u_.arc

ORA-000280: change177948781 for thread 1 is in sequence #4646

Specify log:{<RET>=suggested | filename | AUTO | CANCEL}

cancel

ORA-01547: warning:RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1needs more recovery to be consistent

ORA-01110: datafile 1: '/opt/oracle/oradata/mdsp/system01.dbf'

ORA-01112: mediarecovery not started

00031.8:

SQL> recover   database using backup controlfile;

ORA-000279: change177948781 generated at 04/15/2010 09:24:35 needed for thread1

ORA-000289:suggestion :

/opt/oracle/flash_recovery_area/MDSP/archivelog/2010_04_15/o1_mf_1_4646_%u_.arc

ORA-000280: change177948781 for thread 1 is in sequence #4646

Specify log:{<RET>=suggested | filename | AUTO | CANCEL}

cancel

Media recoverycancelled.

00031.9:

SQL> alterdatabase open resetlogs;

alter database openresetlogs

ERROR at line 1:

ORA-01092: ORACLEinstance terminated. Disconnection forced

Process ID: 5319

Session ID: 1765Serial number: 5

00031.10:

SQL> alter  database open resetlogs;

ERROR:

ORA-03114: notconnected to ORACLE

00031.11:

SQL> connect /as sysdba

Connected to anidle instance.

00031.12:

SQL> startup

ORACLE instancestarted.

Total System GlobalArea  805896192 bytes

Fixed Size                  2148680 bytes

Variable Size             486540984 bytes

DatabaseBuffers          310378496 bytes

Redo Buffers                6828032 bytes

Database mounted.

Database opened.