dataguard环境下备库归档删除策略(三)

默认策略：CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

该策略对应三个值：

1）NONE ：设置为该值时，则不启用归档文件的删除策略。默认情况下就是NONE。

2）APPLIED ON STANDBY ：设置为该值时，会强制检查待删除的log 是否已经在备库apply，只有apply后的log才能删除。当通过附加的 DELETE INPUT 子句删除Standby数据库仍需要的日志时，会提示RMAN-08137错误。 不过仍然可以手动地通过 DELETE ARCHIVELOG 方式删除。

3) SHIPPED TO ALL STANDBY:当归档传送到备库就可以删除。

备库：

备库：
rman target /
show all;
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY;
主库：
rman target /
show all;
CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;（也可以修改为applied）
备库配置归档删除脚本
vim /home/oracle/rmarchivelog_racdb.sh
export ORACLE_SID=racdb
rman target / nocatalog msglog /home/oracle/delete_arch_racdb.log <<EOF
run
{
allocate channel c1 type disk;
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete noprompt archivelog all completed before 'sysdate-3';
release channel c1;
}
exit;
EOF

定时任务
00 01 * * * sh /home/oracle/rmarchivelog_racdb.sh

备库模拟删除：

配置备库rman删除策略

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY

1、停止日志应用

SQL> alter database recover managed standby database cancel;
Database altered.

2、主库切换归档

SQL> alter system switch logfile;

System altered.

SQL> /

System altered.

SQL> /
/
/
/

System altered.

SQL> 
System altered.

SQL> 
System altered.

3、备库查看同步状态

SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied" 
FROM 
(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT 
THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH, 
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT 
THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL 
WHERE 
ARCH.THREAD# = APPL.THREAD# 
ORDER BY 1;
  2    3    4    5    6    7    8    9  
    Thread Last Sequence Received Last Sequence Applied
---------- ---------------------- ---------------------
	 1		       49		     43

发现应用到43其余的只是接收了未应用（44-49未应用）。

4、备库执行删除归档命令

RMAN> delete noprompt archivelog all completed before 'sysdate';

可以看到从44-49的归档日志由于未在备库应用并未删除。