在线重做日志损坏，故障恢复

statup mount
alter system set "_allow_resetlogs_corruption"=true scope=spfile;
shutdown immediate
startup mount

SQL> select name,status from v$datafile;

NAME
--------------------------------------------------------------------------------
STATUS
-------
/oradata/arvin/system01.dbf
SYSTEM

/oradata/arvin/undotbs01.dbf
RECOVER

/oradata/arvin/cwmlite01.dbf
RECOVER

NAME
--------------------------------------------------------------------------------
STATUS
-------
/oradata/arvin/drsys01.dbf
RECOVER

/oradata/arvin/example01.dbf
RECOVER

/oradata/arvin/indx01.dbf
RECOVER

NAME
--------------------------------------------------------------------------------
STATUS
-------
/oradata/arvin/odm01.dbf
RECOVER

/oradata/arvin/tools01.dbf
RECOVER

/oradata/arvin/users01.dbf
RECOVER

NAME
--------------------------------------------------------------------------------
STATUS
-------
/oradata/arvin/xdb01.dbf
RECOVER

10 rows selected.

SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 212871 generated at 12/11/2009 05:35:16 needed for thread 1
ORA-00289: suggestion : /opt/oracle/9.2.0.4/dbs/arch1_2.dbf
ORA-00280: change 212871 for thread 1 is in sequence #2

Specify log: {=suggested | filename | AUTO | CANCEL}
cancel
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oradata/arvin/system01.dbf'

ORA-01112: media recovery not started

SQL> alter database open resetlogs;

Database altered.

SQL> select name,status from v$datafile;

NAME
--------------------------------------------------------------------------------
STATUS
-------
/oradata/arvin/system01.dbf
SYSTEM

/oradata/arvin/undotbs01.dbf
ONLINE

/oradata/arvin/cwmlite01.dbf
ONLINE

NAME
--------------------------------------------------------------------------------
STATUS
-------
/oradata/arvin/drsys01.dbf
ONLINE

/oradata/arvin/example01.dbf
ONLINE

/oradata/arvin/indx01.dbf
ONLINE

NAME
--------------------------------------------------------------------------------
STATUS
-------
/oradata/arvin/odm01.dbf
ONLINE

/oradata/arvin/tools01.dbf
ONLINE

/oradata/arvin/users01.dbf
ONLINE

NAME
--------------------------------------------------------------------------------
STATUS
-------
/oradata/arvin/xdb01.dbf
ONLINE

10 rows selected.

SQL>

 

 

隐含参数_allow_resetlogs_corruption强制启动数据库，设置此参数之后，在数据库Open过程中，Oracle会跳过某些一致性检查，从而使数据库可能跳过不一致状态，Oracle告诉我们，强制resetlogs跳过了一致性检查，可能导致数据库损坏，数据库应当重建。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/14673072/viewspace-622269/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/14673072/viewspace-622269/