ORACLE Rman删除归档日志

xiaoxiao2021-02-28  109

删除过期的归档日志: RMAN> list archivelog all; 手工删除归档日志文件 RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7'; 设置归档日志过期时间: RMAN>show all; CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; 或 CONFIGURE RETENTION POLICY TO REDUNDANCY 1; crosscheck archivelog all;  delete expired archivelog all;  一个备份前检测归档日志脚本: connect target /; crosscheck archivelog all; run {     allocate channel ch1 device type disk ;     report schema;     crosscheck backup of database;     crosscheck backup of archivelog all;     crosscheck backup of controlfile;     crosscheck backup of spfile;     crosscheck archivelog all;     delete noprompt force expired backup;     delete noprompt force expired archivelog until time 'sysdate-0.5';     delete noprompt force expired copy;     delete noprompt force obsolete;     report need backup;     report unrecoverable;     release channel ch1; }
转载请注明原文地址: https://www.6miu.com/read-19942.html

最新回复(0)