DataGuard之自动删除已应用的归档日志.doc

建议先在备库上删除已被应用的归档日志，然后在到 primary 库上删除这个日志，写Shell脚本之前，几个地方需要注意下：1 如何判断备机上哪些日志已经被应用到备库上? 可以通过查询 v$archived_log的字段 applied 字段来判断，同时加上 REGISTRAR 和 name的限制条件， REGISTRAR=RFS 表示 是 Remote File Server process 进程，别外加上 name isnot null 是因为，通过rman crosscheck 并删除 expired的 archivelog 后 name 字段会被置空，-sql 如下SELECT name, SEQUENCE#, FIRST_TIME, REGISTRAR, APPLIED, NEXT_TIME, status FROM V$ARCHIVED_LOGwhere applied = YES and REGISTRAR = RFS and name is not nullORDER BY SEQUENCE#;2 在备机删除了已归档的archivelog后，如何在远端 primary 库同时删除这个日志? 这个问题在网上查了些资料，可以通过配置公钥和私钥，配置之后，scp文件，ssh 到远程主机执行命令都可以不用输入密码，具体原理可以到网上查查，这两点克服后，就可以写脚本了。- 脚本 clear_arch_orasid.sh - 功能：删除备机被 applied 的归档日志，同时也到主库上删除这个归档日志。#!/bin/bash#Author Francs.tan#Date 2010-12-20#Set Result Flag#0-Successful#1-No Archived log that have been applied by standby database#2-ERROR:Excute file clear_primary.sh #3-ERROR: File clear_primary.sh delete error#initialize variableRESULT_FLAG=0file_num=0export ORACLE_HOME=/opt/oracle/product/10.2.0/db_1export PATH=$ORACLE_HOME/bin:$PATHexport ORACLE_SID=orasidexport script_dir=/home/oracle/script/clear_archexport log_dir=/home/oracle/script/clear_arch/logDATE=date +%Y%m%d# Select the earliest archived log file that have been applied by standby database sqlplus -s /as sysdba $log_file# Delete primary archived log echo * Delete primary archived log * | tee -a $log_fileecho rm -f $file_num $script_dir/clear_primary.shscp $script_dir/clear_primary.sh oraclexxx.xxx.xxx.xx:$script_dirssh oraclexxx.xxx.xxx.xx chmod u+x $script_dir/clear_primary.shssh oraclexxx.xxx.xxx.xx $script_dir/clear_primary.shif $? -ne 0 #如果前一条命令执行成功,则返回非0,否则为0then echo * | tee -a $log_file echo ERROR:Excute file clear_primary.sh ,please check it! | tee -a $log_file echo * | tee -a $log_file RESULT_FLAG=2 echo Result Flag:$RESULT_FLAG | tee -a $log_file exit $RESULT_FLAGfi#rm temp filesecho * Remove temp files * | tee -a $log_filerm -f $control_filerm -f $script_dir/clear_primary.shssh oraclexxx.xxx.xxx.xx rm -f $script_dir/clear_primary.shif $? -ne 0 #如果前一条命令执行成功,则返回非0,否则为0then echo * | tee -a $log_file echo ERROR: File clear_primary.sh delete error ,please check it! | tee -a $log_file echo * | tee -a $log_file RESULT_FLAG=3 echo Result Flag:$RESULT_FLAG | tee -a $log_file exit $RESULT_FLAGfiecho * Remove archivelog of Primary and Standby database successfully ! * | tee -a $log_fileexit#end- check_arch.sh- 功能：在备库上较验归档日志，并删除过期的归档日志。#!/bin/bashexport ORACLE_HOME=/opt/oracle/product/10.2.0/db_1export PATH=$ORACLE_HOME/bin:$PATHrman target / /home/oracle/script/clear_arch/log/clear.log 2&1 总结：通过操作系统删除已归档的日志虽然