dataguard删除归档日志的脚本

最新推荐文章于 2022-08-30 14:21:01 发布

weixin_38169359

最新推荐文章于 2022-08-30 14:21:01 发布

阅读量408

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/baill/p/10019250.html

版权

#!/bin/bash
#Author: Baililin 2018/11/26
#Description:Delete the archived logs which had applied on Standby database.
source /home/oracle/.bash_profile
logfile=/tmp/rman_del_arch.log
getsql(){
sqlplus -S "/as sysdba" <<EOF
set head off
set feedback off
select 'delete noprompt archivelog from sequence 0 until sequence '||max(sequence# - 10)|| ' thread ' || thread# ||';' 
  from v\$archived_log where applied='YES' group by thread#;
exit
EOF
}
delArch(){
sql=$(getsql)
rman target / log=${logfile} append <<EOF
$sql
exit;
EOF
}
delArch

转载于:https://www.cnblogs.com/baill/p/10019250.html