定时删除归档

版本1

vi del_arch.sh

#!/bin/bash

export ORACLE_SID=bpxtest1

export ORACLE_BASE=/opt/oracle 

export ORACLE_HOME=/opt/oracle/products/11.2.0

export PATH=$ORACLE_HOME/bin:$PATH

find /home/oracle/delarch/ -name "*.log" -ctime +10 -exec rm -rf {} \; 

## 在/home/oracle/delarch/ 查找10天之前的日志，并删除掉)

rman target / <<EOF

allocate channel for maintenance type disk; --for maintenance？

crosscheck backup; --校验备份片

crosscheck copy; --校验镜像副本

crosscheck archivelog all; --校验所有备份的归档日志

delete noprompt expired backup; --删除过期备份片

delete noprompt expired archivelog all; --删除过期归档文件

delete noprompt force archivelog until time 'sysdate-4'; --保留4天归档文件



exit;

EOF

版本2

vi /home/oracle/scripts/del_arch_dbname.sh
#!/bin/bash
export ORACLE_SID=实例1
export ORACLE_BASE=/opt/oracle
export ORACLE_HOME=/opt/oracle/products/19.3.0
export PATH=$ORACLE_HOME/bin:$PATH
rman target /  log /home/oracle/scripts/log/del_arch_dbname_`date +%y%m%d%H`.log append <<EOF
allocate channel for maintenance type disk;
crosscheck backup;
crosscheck copy;
crosscheck archivelog all;
delete force noprompt archivelog until time 'sysdate-15';
delete force noprompt expired backup;
exit;
EOF
echo `date`

部署定时任务：

00 03 * * * /bin/sh /home/oracle/del_arch.sh >/home/oracle/delarch/`date +"\%Y\%m\%d"`_del_arch.log 2>&1 & 

在/home/oracle/delarch目录下每天凌晨3点执行删除脚本输出为年月日_del_arcl.log