Oracle RMAN scripts to delete archivelog

vi del_arch.sh
export ORACLE_SID=pdcsdb
rman target / cmdfile=/home/oracle/scripts/del_arch.sql log=/home/oracle/scripts/rman_del_archivelog.log append

vi del_arch.sql
run
{
allocate channel ch00 type disk;
crosscheck archivelog all;
delete noprompt expired archivelog all;
delete archivelog until time 'sysdate-1/4';
release channel ch00;
}



posted @ 2021-02-24 04:05  Orchidelle  阅读(76)  评论(0编辑  收藏  举报