归档删除脚本，保留7天有效归档.

Inkcup

用于11g及以上版本
创建文件：
arch_del.rcv
arch_del.sh
自动任务：
crontab -e

============================================================
[oracle@localhost arch]$ cat arch_del.rcv
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
EXIT;
------------------------------------------------------------------------
[oracle@localhost arch]$ cat arch_del.sh
#!/bin/bash

export ORACLE_SID=orcl
export ORACLE_HOME=/home/oracle/19c
export PATH=$ORACLE_HOME/bin:$PATH

cmd=/home/oracle/arch/arch_del.rcv
log=/home/oracle/arch/arch_del_$(date +%Y%m%d_%H%M%S).log

echo "start clear arch : $(date)" | tee ${log}

rman target / log=${log} append << EOF
@${cmd}
EOF

echo "finished clear arch : $(date)" |tee -a ${log}
-----------------------------------------------------------------------------------------
crontab -l
30 2 * * * /home/oracle/arch/arch_del.sh