问题描述:某个联机日志不能归档了(select * from v$log中查看,该日志状态正常,而且已经不是当前的日志了,过去了,但是没归档成功),导致系统的ARCn进程一直先要把这个日志归档,但是总不能成功,然后后面的联机日志就也无法归档。。。。。。
告警日志的报错信息:
Fri Aug 2 11:20:31 2013
Errors in file /u01/app/oracle/admin/tt/bdump/tt_arc1_25559.trc:
ORA-00314: Message 314 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [11] [0]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/u01/app/oracle/oradata/tt/redo01.log]
Fri Aug 2 11:20:31 2013
ARC1: Failed to archive thread 1 sequence 11 (0)
.....
Fri Aug 2 11:21:31 2013
Errors in file /u01/app/oracle/admin/tt/bdump/tt_arc0_25557.trc:
ORA-00314: Message 314 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [11] [0]
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/u01/app/oracle/oradata/tt/redo01.log]
Fri Aug 2 11:21:31 2013
ARC0: Failed to archive thread 1 sequence 11 (0)
解决办法:
1、 alter database clear unarchived logfile group 1;
-----重建未归档日志(这个操作做的事情:①我从新建立了这个组的日志文件,②这个SEQUENCE不归档了),这样就跳过了它,继续下面的归档了
2 、alter database drop logfile group 1;
-----删除日志组,如果没有第1步删不了,报错:redo01.log还未归档
3、alter database add logfile group 1('/u01/app/oracle/tt/redo01.log') size 50M reuse;
-----再添加一个日志组
做完上面的操作,最好全备一下数据库,因为你的归档断了~~ 那个重建的日志没有归出档来
*****************************************************************************************************************
alter database clear logfile group 1; -----重建归档了的日志组fd
alter database clear unarchived logfile group 1; -----重建未归档的日志组
通过:select * from v$log; 看这个日志组是不是归档了
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- --- ---------------- ------------- ------------
1 1 35 52428800 1 NO INACTIVE 5711723 02-AUG-13
2 1 36 52428800 1 NO CURRENT 5711728 02-AUG-13
3 1 34 52428800 1 YES INACTIVE 5711710 02-AUG-13
ffsdf sadf