首页 > 其他 > 详细

记一次ADG备库归档目录满导致的延时处理

时间:2019-02-19 20:18:16      阅读:261      评论:0      收藏:0      [点我收藏+]

报错如下,原因是存放传过来的归档的目录+HWAREDODG满了,MRP进程无法应用归档,我在手动传了几个归档之后发现不是GAP,select * from V$ARCHIVE_GAP 显示没有GAP。于是就把HWAREDODG下已经应用的归档删掉,

rman target /

rman>select ‘run{‘ from dual

union all

select ‘delete noprompt archivelog until sequence ‘||max(sequence#)||‘ thread ‘||thread#||‘;‘ from v$archived_log where applied=‘YES‘ and name is not null GROUP BY thread#

union all

select ‘}‘ from dual;

删除后归档顺利生成,MRP进程正常应用

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

FAL[client]: Failed to request gap sequence

GAP - thread 1 sequence 19387-19387

DBID 3365933973 branch 982424855

FAL[client]: All defined FAL servers have been attempted.

------------------------------------------------------------

Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization

parameter is defined to a value that‘s sufficiently large

enough to maintain adequate log switch information to resolve

archivelog gaps.

------------------------------------------------------------

Mon Feb 18 22:22:06 2019

Archived Log entry 10638 added for thread 2 sequence 16410 ID 0xc935a096 dest 1:

Mon Feb 18 22:22:06 2019

Unable to create archive log file ‘+HWAREDODG‘

Mon Feb 18 22:22:06 2019

Errors in file /oracle/app/oracle/diag/rdbms/wlwzz/wlwcdb/trace/wlwcdb_arc3_10142.trc:

ORA-19504: failed to create file "+HWAREDODG"

ORA-17502: ksfdcre:4 Failed to create file +HWAREDODG

ORA-15041: diskgroup "HWAREDODG" space exhausted

ARC3: Error 19504 Creating archive log file to ‘+HWAREDODG‘

Mon Feb 18 22:29:06 2019

Unable to create archive log file ‘+HWAREDODG‘

Mon Feb 18 22:29:06 2019

Errors in file /oracle/app/oracle/diag/rdbms/wlwzz/wlwcdb/trace/wlwcdb_arc1_10138.trc:

ORA-19504: failed to create file "+HWAREDODG"

ORA-17502: ksfdcre:4 Failed to create file +HWAREDODG

ORA-15041: diskgroup "HWAREDODG" space exhausted

ARC1: Error 19504 Creating archive log file to ‘+HWAREDODG‘

Mon Feb 18 22:36:06 2019

Unable to create archive log file ‘+HWAREDODG‘

Mon Feb 18 22:36:06 2019

Errors in file /oracle/app/oracle/diag/rdbms/wlwzz/wlwcdb/trace/wlwcdb_arc0_10136.trc:

ORA-19504: failed to create file "+HWAREDODG"

ORA-17502: ksfdcre:4 Failed to create file +HWAREDODG

ORA-15041: diskgroup "HWAREDODG" space exhausted

ARC0: Error 19504 Creating archive log file to ‘+HWAREDODG‘

Mon Feb 18 22:44:07 2019

Unable to create archive log file ‘+HWAREDODG‘

Mon Feb 18 22:44:07 2019

Errors in file /oracle/app/oracle/diag/rdbms/wlwzz/wlwcdb/trace/wlwcdb_arc3_10142.trc:

ORA-19504: failed to create file "+HWAREDODG"

ORA-17502: ksfdcre:4 Failed to create file +HWAREDODG

ORA-15041: diskgroup "HWAREDODG" space exhausted

ARC3: Error 19504 Creating archive log file to ‘+HWAREDODG‘

Mon Feb 18 22:51:07 2019

Unable to create archive log file ‘+HWAREDODG‘

Mon Feb 18 22:51:07 2019

Errors in file /oracle/app/oracle/diag/rdbms/wlwzz/wlwcdb/trace/wlwcdb_arc1_10138.trc:

ORA-19504: failed to create file "+HWAREDODG"

ORA-17502: ksfdcre:4 Failed to create file +HWAREDODG

ORA-15041: diskgroup "HWAREDODG" space exhausted

ARC1: Error 19504 Creating archive log file to ‘+HWAREDODG‘

记一次ADG备库归档目录满导致的延时处理

原文:https://www.cnblogs.com/kawashibara/p/10403085.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!