一次rhel5.8的文件系统只读造成的ORA-00354:corruptredologblockheader - 数据库编程

20:28:43 CST 2015 SMON: enabling tx recovery Thu Jun 04 20:28:45 CST 2015 ARCH: Archival stopped, error occurred. Will continue retrying Thu Jun 04 20:28:45 CST 2015 ORACLE Instance orcl - Archival Error Thu Jun 04 20:28:45 CST 2015 Database Characterset is ZHS16GBK Thu Jun 04 20:28:45 CST 2015 ORA-16038: log 1 sequence# 397 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log' Thu Jun 04 20:28:45 CST 2015 Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_arc0_3609.trc: ORA-16038: log 1 sequence# 397 cannot be archived ORA-00354: corrupt redo log block header ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log' Opening with internal Resource Manager plan replication_dependency_tracking turned off (no async multimaster replication found) Starting background process QMNC QMNC started with pid=21, OS id=3637 Thu Jun 04 20:28:49 CST 2015 Completed: ALTER DATABASE OPEN ------->db open了。open归open，无法归档的话，业务早晚会hang。 --->此时/u01/app/oracle/oradata/orcl/redo02.log，是sequence 398，是current redo log。

Thread 1 advanced to log sequence 399 (LGWR switch)
  Current log# 3 seq# 399 mem# 0: /u01/app/oracle/oradata/orcl/redo03.log
--->此时/u01/app/oracle/oradata/orcl/redo03.log，是sequence 399，是current redo log。

--->然后，sqlplus中发出了日志切换的语句：alter system switch logfile;
Thread 1 cannot allocate new log, sequence 400---->已经不能进行日志切换，因为sequence 397未被归档，不允许被覆盖，此时db hang住。
All online logs needed archiving
  Current log# 3 seq# 399 mem# 0: /u01/app/oracle/oradata/orcl/redo03.log
  Thu Jun 04 21:28:31 CST 2015
ARC0: Log corruption near block 385521 change 1314765 time ?
Thu Jun 04 21:28:31 CST 2015
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_arc0_3609.trc:
ORA-00354: corrupt redo log block 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 21:28:31 CST 2015
ARC0: Closing local archive destination LOG_ARCHIVE_DEST_1: '/home/oracle/1_397_880950378.dbf' (error 354)
 (orcl)
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Jun 04 21:28:34 CST 2015
ORACLE Instance orcl - Archival Error
Thu Jun 04 21:28:34 CST 2015
ORA-16038: log 1 sequence# 397 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
Thu Jun 04 21:28:34 CST 2015
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_arc0_3609.trc:
ORA-16038: log 1 sequence# 397 cannot be archived
ORA-00354: corrupt redo log block header
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Jun 04 21:28:34 CST 2015
ORACLE Instance orcl - Archival Error
Thu Jun 04 21:28:34 CST 2015
ORA-16014: log 1 sequence# 397 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'
Thu Jun 04 21:28:34 CST 2015
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_arc0_3609.trc:
ORA-16014: log 1 sequence# 397 not archived, no available destinations
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcl/redo01.log'

启动db到mount状态，进行处理

[oracle@lei1 ~]$ sqlpl

一次rhel5.8的文件系统只读造成的ORA-00354:corruptredologblockheader(二)