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


    报错如下,原因是存放传过来的归档的目录+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'

  • 相关阅读:
    TP ajax
    TP分页
    TP表单验证
    TP数据删除
    TP数据查询
    TP【连接数据库配置及Model数据模型层】
    TP系统常量信息
    ThinkPHP中Session用法详解
    ThinkPHP部分内置函数
    element-ui select可搜索下拉框无法在IOS或Ipad调起小键盘输入法
  • 原文地址:https://www.cnblogs.com/kawashibara/p/10403085.html
Copyright © 2020-2023  润新知