Oracle 日志归档 自动清理


exp emis/emis@orcl file=d:ackuporacleoracle%date:~0,10%.dmp owner=emis log=d:ackuporacleoracle%date:~0,10%.log


connect target emis/emis
run{
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-2'; //删除两天前的归档日志
crosscheck archivelog all; //检查
delete expired archivelog all; //删除过期日志
}

原文地址:https://www.cnblogs.com/mingjing/p/4923360.html