版本:Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
操作:trace目录下大量trc文件占用存储空间,清理7天前的trc文件释放储存空间,关库正常,启库正常。
出现问题:alert日志报错,日志出现坏块,如下
Errors in file /u01/app/oracle/diag/rdbms/itps/itps/trace/itps_arc3_15006.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 62539 change 17280936 time 03/02/2015 10:07:10
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/itps/redo02.log'
ARC3: All Archive destinations made inactive due to error 354
ARC3: Closing local archive destination LOG_ARCHIVE_DEST_1: '/u01/app/oracle/flash_recovery_area/ITPS/archivelog/2015_03_05/o1_mf_1_626_bhhg5yb9_.arc' (error 354) (itps)
Committing creation of archivelog '/u01/app/oracle/flash_recovery_area/ITPS/archivelog/2015_03_05/o1_mf_1_626_bhhg5yb9_.arc' (error 354)
Deleted Oracle managed file /u01/app/oracle/flash_recovery_area/ITPS/archivelog/2015_03_05/o1_mf_1_626_bhhg5yb9_.arc
Thu Mar 05 10:00:39 2015
ARC0: Log corruption near block 62539 change 17280936 time ?
CORRUPTION DETECTED: thread 1 sequence 626 log 2 at block 62539. Arch found corrupt blocks
没找到问题产生的具体原因,只有先解决了
正常关库,然后启动到mount状态
10:01:50 SYS@itps>alter database clear logfile group 2;
alter database clear logfile group 2
*
ERROR at line 1:
ORA-00350: log 2 of instance itps (thread 1) needs to be archived
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/itps/redo02.log'
Elapsed: 00:00:00.45
10:02:09 SYS@itps>alter database clear unarchived logfile group 2;
Database altered.
Elapsed: 00:00:01.57
10:04:33 SYS@itps>alter database open;
Database altered.
Elapsed: 00:00:06.28
操作:trace目录下大量trc文件占用存储空间,清理7天前的trc文件释放储存空间,关库正常,启库正常。
出现问题:alert日志报错,日志出现坏块,如下
Errors in file /u01/app/oracle/diag/rdbms/itps/itps/trace/itps_arc3_15006.trc:
ORA-00354: corrupt redo log block header
ORA-00353: log corruption near block 62539 change 17280936 time 03/02/2015 10:07:10
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/itps/redo02.log'
ARC3: All Archive destinations made inactive due to error 354
ARC3: Closing local archive destination LOG_ARCHIVE_DEST_1: '/u01/app/oracle/flash_recovery_area/ITPS/archivelog/2015_03_05/o1_mf_1_626_bhhg5yb9_.arc' (error 354) (itps)
Committing creation of archivelog '/u01/app/oracle/flash_recovery_area/ITPS/archivelog/2015_03_05/o1_mf_1_626_bhhg5yb9_.arc' (error 354)
Deleted Oracle managed file /u01/app/oracle/flash_recovery_area/ITPS/archivelog/2015_03_05/o1_mf_1_626_bhhg5yb9_.arc
Thu Mar 05 10:00:39 2015
ARC0: Log corruption near block 62539 change 17280936 time ?
CORRUPTION DETECTED: thread 1 sequence 626 log 2 at block 62539. Arch found corrupt blocks
没找到问题产生的具体原因,只有先解决了
正常关库,然后启动到mount状态
10:01:50 SYS@itps>alter database clear logfile group 2;
alter database clear logfile group 2
*
ERROR at line 1:
ORA-00350: log 2 of instance itps (thread 1) needs to be archived
ORA-00312: online log 2 thread 1: '/u01/app/oracle/oradata/itps/redo02.log'
Elapsed: 00:00:00.45
10:02:09 SYS@itps>alter database clear unarchived logfile group 2;
Database altered.
Elapsed: 00:00:01.57
10:04:33 SYS@itps>alter database open;
Database altered.
Elapsed: 00:00:06.28
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29193965/viewspace-1448851/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29193965/viewspace-1448851/