oracle删除前两天的归档日志http://www.cndba.cn/hbhe0316/article/107909http://www.cndba.cn/hbhe0316/article/107909

cat > /home/oracle/del_arc.sh <<"EOF0"
#!/bin/bash
export ORACLE_SID=orcl
export ORACLE_HOME=/u01/app/oracle/product/19.3.0/dbhome_1
export NLS_LANG="american_america.ZHS16GBK"
export NLS_DATE_FORMAT="YYYY-MM-DD HH24:Mi:SS"
LOG_DIR=/home/oracle/log
DATEL=`date '+%Y-%m-%d'`
LOG_NAME=${LOG_DIR}/del_arc_${ORACLE_SID}_${DATEL}".log"
$ORACLE_HOME/bin/rman log=$LOG_NAME target / <<EOF
crosscheck archivelog all;
delete force noprompt archivelog all completed before 'sysdate-2';
exit;
EOF
EOF0

修改ORACLE_SID为orcl
修改ORACLE_HOME为/u01/app/oracle/product/19.3.0/dbhome_1http://www.cndba.cn/hbhe0316/article/107909

[oracle@db02 ~]$ crontab -l
0 17 * * * /home/oracle/del_arc.sh

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle