-bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.2.0 - Production on Thu Oct 27 18:07:26 2011

Copyright (c) 1982, 2005, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1279120 bytes
Variable Size             104860528 bytes
Database Buffers           58720256 bytes
Redo Buffers                2912256 bytes
Database mounted.
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 60457 change 884115 time 10/02/2011
12:32:36
ORA-00312: online log 3 thread 1:
'/export/home/oracle/orcl/oradata/orcl/redo03.log'


起库失败 可能是redo log损坏
SQL> alter database clear unarchived logfile group 3;
alter database clear unarchived logfile group 3
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
ORA-00312: online log 3 thread 1:
'/export/home/oracle/orcl/oradata/orcl/redo03.log'


SQL> select group#,status from v$log;

    GROUP# STATUS
---------- ------------------------------------------------
         1 CURRENT
         3 ACTIVE
         2 ACTIVE


SQL> select group#,member from v$logfile;

    GROUP# MEMBER
---------- --------------------------------------------------
         3 /export/home/oracle/orcl/oradata/orcl/redo03.log
         2 /export/home/oracle/orcl/oradata/orcl/redo02.log
         1 /export/home/oracle/orcl/oradata/orcl/redo01.log
         4 /export/home/oracle/orcl/oradata/standbyrd01.log
         5 /export/home/oracle/orcl/oradata/orcl/standbyrd01.
           log


SQL> alter database drop logfile group 3; 
alter database drop logfile group 3
*
ERROR at line 1:
ORA-01624: log 3 needed for crash recovery of instance orcl (thread 1)
ORA-00312: online log 3 thread 1:
'/export/home/oracle/orcl/oradata/orcl/redo03.log'

SQL> select group#,thread#,members,archived,status from v$log;

    GROUP#    THREAD#    MEMBERS ARCHIVED
---------- ---------- ---------- ---------
STATUS
------------------------------------------------
         1          1          1 NO
CURRENT

         3          1          1 YES
ACTIVE

         2          1          1 YES
ACTIVE


SQL> alter system checkpoint;
alter system checkpoint
*
ERROR at line 1:
ORA-01109: database not open

最后也不知怎么搞，用下面的帖子中的方法也报错

http://wenku.baidu.com/view/6853260116fc700abb68fc68.html