oracleracDG备份,OracleDataGuard（RAC+DG)归档删除策略及脚本

1、Data Guard 主库归档文件删除策略&＃xff1a;

当我们设置&＃xff1a;

RMAN>configure archivelog deletion policy to applied on standby;

在Maximum Availability和 Maximum Performance下&＃xff0c;RMAN备份归档文件的时候&＃xff0c;加上delete input的时候&＃xff0c;归档会被删除。

RMAN> configure archivelog deletion policy to none;

此时归档删除策略会被取消。

2、Data  Guard 备库归档文件删除策略

此次备库的归档删除策略是在单机版的基础上进行升级&＃xff0c;增加了日志功能&＃xff0c;支持对2个节点RAC主库的归档文件在备库上删除的功能&＃xff0c;可以作为计划任务执行也可以以交互的形式单独执行。

由于备库一般不执行rman备份计划&＃xff0c;所以需要脚本删除这些归档日志文件。

[Oracle&＃64; www.linuxidc.com backup_scripts]$ vim delstarch.sh

export ORACLE_THREAD&＃61;$1

export ORACLE_HOME&＃61;/u01/app/oracle/product/11.2.0/dbhome_1

export ORACLE_SID&＃61;bdspoc

export SHELL_DIR&＃61;/u01/app/oracle/backup_scripts

export DATE&＃61;$(date &＃43;%Y-%m-%d\ %H:%M:%S)

if [ ! $ORACLE_THREAD ];then

read -p "Enter deleted thread[1|2]: "

DB_THREAD&＃61;$REPLY

else

DB_THREAD&＃61;$ORACLE_THREAD

fi

if [ $DB_THREAD &＃61;&＃61; 1 ];then

del_seq&＃61;&＃96;ls /arch|grep ^1|cut -f2 -d_|sort -n |head -1&＃96;

echo $del_seq "is the minimum archlog sequence"

$ORACLE_HOME/bin/sqlplus -s "sys/***** as sysdba" <$SHELL_DIR/max_sn.log

set head off;

set feedback;

select max(sequence#) from v\$log_history where THREAD#&＃61;1;

exit;

eof

max_sn&＃61;&＃96;cat /u01/app/oracle/backup_scripts/max_sn.log|awk &＃39;{print $1}&＃39;|grep ^[0-9]&＃96;

#保留最近的20个归档&＃xff0c;其他都删除

max_sn&＃61;&＃96;expr $max_sn - 20&＃96;

echo $max_sn "is the maximum archlog sequence"

while [ $del_seq -lt $max_sn ]

do

DATE&＃61;$(date &＃43;%Y%m%d_%H%M%S)

rm /arch/1_"$del_seq"_816281825.arc

DATE&＃61;$(date &＃43;%Y-%m-%d\ %H:%M:%S)

#由于log_archive_format 为%t_%s_%r.arc类型&＃xff0c;%r为resetlog id

echo "$DATE"  /arch/1_"$del_seq"_816281825.arc >> $SHELL_DIR/delarch.log

del_seq&＃61;&＃96;expr $del_seq &＃43; 1&＃96;

echo "$DATE"  1_"$del_seq"_816281825.arc

done

elif [ $DB_THREAD &＃61;&＃61; 2 ];then

del_seq&＃61;&＃96;ls /arch|grep ^2|cut -f2 -d_|sort -n |head -1&＃96;

echo $del_seq "is the minimum archlog sequence"

$ORACLE_HOME/bin/sqlplus -s "sys/***** as sysdba" <$SHELL_DIR/max_sn.log

set head off;

set feedback;

select max(sequence#) from v\$log_history where upper(THREAD#)&＃61;2;

exit;

eof

max_sn&＃61;&＃96;cat /u01/app/oracle/backup_scripts/max_sn.log|awk &＃39;{print $1}&＃39;|grep ^[0-9]&＃96;

max_sn&＃61;&＃96;expr $max_sn - 20&＃96;

echo $max_sn "is the maximum archlog sequence"

while [ $del_seq -lt $max_sn ]

do

rm /arch/2_"$del_seq"_816281825.arc

DATE&＃61;$(date &＃43;%Y-%m-%d\ %H:%M:%S)

echo "$DATE"  /arch/2_"$del_seq"_816281825.arc >> $SHELL_DIR/delarch.log

echo "$DATE"  2_"$del_seq"_816281825.arc  has been deleted

del_seq&＃61;&＃96;expr $del_seq &＃43; 1&＃96;

done

else

echo "$DATE"  There has a fault db_thread value! >> $SHELL_DIR/delarch.log

fi

可以交互式执行&＃xff0c;例如&＃xff1a;

[oracle&＃64; www.linuxidc.com backup_scripts]$ sh delstarch.sh

Enter deleted thread[1|2]: 1                                    --选择删除从哪个节点归档来的日志文件

也可以做成计划任务执行该脚本

[root&＃64; www.linuxidc.com ~]# crontab -l

0 1 * * *  su - oracle -c    /u01/app/oracle/backup_scripts/delstarch.sh  1

0 2 * * *  su - oracle -c    /u01/app/oracle/backup_scripts/delstarch.sh  2

每天1点执行1节点归档来的日志文件&＃xff0c;2点执行2节点归档来的日志文件。

推荐阅读&＃xff1a;