Automatic archival             Enabled
Archive destination            /oracle/oradata/TSMISC02/archive
Oldest online log sequence     61
Next log sequence to archive   62
Current log sequence           62
SQL> select * from v$log;

GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC STATUS           FIRST_CHANGE# FIRST_TIM
---------- ---------- ---------- ---------- ---------- --- ----------------
1          1         62    2097152          1 NO INVALIDATED             658443 15-NOV-05
2          1          0    2097152          1 YES INACTIVE                       0 15-NOV-05
3          1         61    2097152          1 YES INACTIVE                649920 15-NOV-05

SQL>
断定，损坏的是current 的日志。

 

 

接下来设置两个隐含参数：_ALLOW_RESETLOGS_CORRUPTION = TRUE 和 _corrupted_rollback_segments ，因为redo损坏的时候，undo数据也大都不一致了。

IXDBA.NET社区论坛

使用隐含参数启动数据库：
SQL> create pfile='/home/oracle/pfile.tmp' from spfile;

File created.
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
[oracle@ts01 oracle]$ tail pfile.tmp
*.sort_area_size=524288
*.star_transformation_enabled='FALSE'
*.timed_statistics=TRUE
*.undo_management='AUTO'
*.undo_retention=10800
*.undo_tablespace='UNDOTBS2'
*.user_dump_dest='/oracle/admin/TSMISC02/udump'

_ALLOW_RESETLOGS_CORRUPTION = TRUE

[oracle@ts01 oracle]$

这个参数的解释：
SQL> select KSPPDESC from X$KSPPI where ksppinm='_allow_resetlogs_corruption';

KSPPDESC
----------------------------------------------------------------
allow resetlogs even if it will cause corruption

[oracle@ts01 oracle]$ sqlplus '/ as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Mon Nov 21 15:57:21 2005

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup mount pfile=pfile.tmp
ORACLE instance started.

Total System Global Area  236000356 bytes
Fixed Size                   451684 bytes