一次rhel5.8的文件系统只读造成的ORA-00354: corrupt redo log block header
Wed Jun 03 03:31:24 CST 2015 Thread 1 advanced to log sequence 396 (LGWR switch) Current log# 3 seq# 396 mem# 0: /u01/app/oracle/oradata/orcl/redo03.log Wed Jun 03 19:05:48 CST 2015 Thread 1 advanced to log sequence 397 (LGWR switch) ----------------->从这个地方可以看出来：sequence 397为current redo log Current log# 1 seq# 397 mem# 0: /u01/app/oracle/oradata/orcl/redo01.log Wed Jun 03 20:44:19 CST 2015 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_j000_30071.trc: ORA-07445: exception encountered: core dump [kglats()+106] [SIGSEGV] [Address not mapped to object] [0x000000000] [] [] ORA-01403: no data found Wed Jun 03 22:00:26 CST 2015 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_j001_30285.trc: ORA-07445: exception encountered: core dump [kglhdiv_callback()+79] [SIGSEGV] [Address not mapped to object] [0x0000000D4] [] [] Thu Jun 04 20:28:17 CST 2015 Starting ORACLE instance (normal)
后来数据库实例重启（人为重启）：
Completed: ALTER DATABASE MOUNT Thu Jun 04 20:28:24 CST 2015 ALTER DATABASE OPEN Thu Jun 04 20:28:24 CST 2015 Beginning crash recovery of 1 threads parallel recovery started with 3 processes Thu Jun 04 20:28:24 CST 2015 Started redo scan Thu Jun 04 20:28:24 CST 2015 Completed redo scan 1210 redo blocks read, 287 data blocks need recovery Thu Jun 04 20:28:25 CST 2015 Started redo application at Thread 1: logseq 397, block 660827 Thu Jun 04 20:28:25 CST 2015 Recovery of Online Redo Log: Thread 1 Group 1 Seq 397 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/orcl/redo01.log Thu Jun 04 20:28:25 CST 2015 Completed redo application Thu Jun 04 20:28:29 CST 2015 Completed crash recovery at Thread 1: logseq 397, block 662037, scn 1359645 287 data blocks read, 287 data blocks written, 1210 redo blocks read Thu Jun 04 20:28:30 CST 2015 LGWR: STARTING ARCH PROCESSES ARC0 started with pid=19, OS id=3609 Thu Jun 04 20:28:30 CST 2015 ARC0: Archival started ARC1: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE ARC1 started with pid=20, OS id=3611 Thu Jun 04 20:28:30 CST 2015 Thread 1 advanced to log sequence 398 (thread open) --->已经使用sequence 398，此时，sequence 398为current redo log Thread 1 opened at log sequence 398 Current log# 2 seq# 398 mem# 0: /u01/app/oracle/oradata/orcl/redo02.log Successful open of redo thread 1 Thu Jun 04 20:28:30 CST 2015 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Thu Jun 04 20:28:30 CST 2015 ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Thu Jun 04 20:28:30 CST 2015 SMON: enabling cache recovery Thu Jun 04 20:28:30 CST 2015 ARC1: Becoming the heartbeat ARCH Thu Jun 04 20:28:35 CST 2015 ARC0: Log corruption near block 385521 change 1314765 time ? --->发现redo log 有损坏 Thu Jun 04 20:28:35 CST 2015 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_arc0_3609.trc: ORA-00354: corrupt redo log block header --->发现redo log header有损坏 ORA-00353: log corruption near block 385521 change 1314765 time 06/03/2015 19:05:47 ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log' ARC0: All Archive destinations made inactive due to error 354 Thu Jun 04 20:28:35 CST 2015 ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/1_397_880950378.dbf' (error 354) (orcl) Committing creation of archivelog '/home/oracle/1_397_880950378.dbf' (error 354) Thu Jun 04 20:28:43 CST 2015 Successfully onlined Undo Tablespace 1. Thu Jun 04