• RMAN-08120: WARNING: archived log not deleted, not yet applied by standby


    查看归档警告

    select * from V$RMAN_OUTPUT where lower(output) like '%warning%';

    有双节点集群同步到单机DG,看到rac备份上有警告

    RMAN-08120: WARNING: archived log not deleted, not yet applied by standby

    在DG上发现应用是正常的

    SQL>select SEQUENCE#,applied,FIRST_TIME,NEXT_TIME  from v$archived_log order by 1 ;

    ......

    SEQUENCE# APPLIED FIRST_TIM NEXT_TIME
    ---------- --------- --------- ---------
    153959 YES 27-JAN-21 27-JAN-21
    153960 YES 27-JAN-21 27-JAN-21
    153961 YES 27-JAN-21 27-JAN-21
    153962 YES 27-JAN-21 27-JAN-21
    153963 YES 27-JAN-21 27-JAN-21
    153964 YES 27-JAN-21 27-JAN-21
    153965 IN-MEMORY 27-JAN-21 27-JAN-21

    11392 rows selected.

    在主库中显示已有应用

    09:42:05 SYS@proc1(621)> select sequence#,applied,thread#,deleted from v$archived_log where sequence#='153964';

    SEQUENCE# APPLIED THREAD# DELETED
    ---------- --------------------------- ---------- ---------
    153964 YES 2 NO
    153964 NO 2 NO
    153964 NO 2 NO

    Elapsed: 00:00:00.11

    SQL>select sequence#,applied,thread#,deleted from v$archived_log order by sequence#;

    ......

    153958 YES 2 NO
    153958 NO 2 NO
    153958 NO 2 NO
    153959 YES 2 NO
    153959 NO 2 NO
    153959 NO 2 NO
    153960 YES 2 NO
    153960 NO 2 NO
    153960 NO 2 NO
    153961 YES 2 NO
    153961 NO 2 NO
    153961 NO 2 NO
    153962 YES 2 NO
    153962 NO 2 NO
    153962 NO 2 NO
    153963 YES 2 NO
    153963 NO 2 NO
    153963 NO 2 NO
    153964 YES 2 NO
    153964 NO 2 NO
    153964 NO 2 NO
    153965 YES 2 NO
    153965 NO 2 NO
    153965 NO 2 NO
    153966 YES 2 NO
    153966 NO 2 NO
    153966 NO 2 NO
    153967 YES 2 NO
    153967 NO 2 NO
    153967 NO 2 NO
    153968 NO 2 NO
    153968 NO 2 NO
    153968 NO 2 NO

    11392 rows selected.

    Elapsed: 00:00:00.28

    哪是哪个log没被从库应用呢???  从下面的主库查询可以看出除了不前归档都有应用

    10:09:08 SYS@proc1(621)> select count(*) ,sequence# from v$archived_log where applied='NO' group by sequence# having count(*)=3 order by sequence#;

    COUNT(*) SEQUENCE#
    ---------- ----------
    3 153968

    Elapsed: 00:00:00.13
    10:10:52 SYS@proc1(621)>

    这个问题太奇怪了,回想接手这个数据库的时候,曾发生主从不同步,手动修复的情况,难道与这个有关系?

    查看主库的rman配置

    RMAN> SHOW ALL;

    using target database control file instead of recovery catalog
    RMAN configuration parameters for database with db_unique_name PROC are:
    CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS;
    CONFIGURE BACKUP OPTIMIZATION OFF; # default
    CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    CONFIGURE CONTROLFILE AUTOBACKUP ON;
    CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO BACKUPSET;
    CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
    CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
    CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+DATA/proc/datafile/snapcf_proc1.f';

    先修改删除归档策略


    RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

    old RMAN configuration parameters:
    CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
    new RMAN configuration parameters:
    CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
    new RMAN configuration parameters are successfully stored

    RMAN>

  • 相关阅读:
    Teleport垃圾代码tppabs的清理
    MVC Action 返回类型[转]
    Jquery 技巧收集..慢慢添加吧..
    下拉框根据输入文字自动选择和输入提示
    Repeater中,寻找TextBox,Lable.等的值
    纯CSS列自适应高
    一些基本的项目开发规范.慢慢总结中..
    MSSQL触发器
    IIS错误集,以及解决方法!
    C#创建Windows服务
  • 原文地址:https://www.cnblogs.com/102x/p/14333732.html
Copyright © 2020-2023  润新知