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>