1、删除部分归档日志
[oracle@dlyzc ~]$ rman target /
RMAN> crosscheck archivelog all;
RMAN> delete expired archivelog all;(执行这个删除所有)
提示输入YES,然后删除;
delete force noprompt archivelog until time 'sysdate - 3';(执行这个保留三天)
创建自动归档脚本:
vi /gd
echo *********************begin*****************
source /home/oracle/.bash_profile
date
export ORACLE_SID=ebank1
$ORACLE_HOME/bin/rman target / <<EOF
crosscheck archivelog all;
list expired backup;
delete noprompt expired archivelog all;
delete force noprompt archivelog until time 'sysdate - 3';
exit;
EOF
echo *********************end*******************
mv gd gd.sh
chmod +x ./gd.sh
创建定时任务
crontab -e
00 04 * * * sh /gd.sh > /home/oracle/scripts/archive_clear.log
重新启动数据库