11g rac设置的每周日开始0/2/2/1/2/2/2的rman增量备份,设置保留7天,查看备份发现数据文件,控制文件,spfile都是保留的7天,但是归档日志保留了有十几天

今天查数据文件、控制文件、spfile的备份都是从6.8开始的,归档日志却是5.28开始,这个是什么原因了


要看你rman脚本中 delete archivelog 的方式,贴出来看看


备份脚本是这样的
rman log='/u01/app/oracle/back/db_rman.log' append <
connect target /;
RUN {
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '+BACK/%F';
ALLOCATE CHANNEL CH1 DEVICE TYPE DISK FORMAT '+BACK/%U';
BACKUP incremental level=0 DATABASE SKIP INACCESSIBLE FILESPERSET 10 tag='level0' PLUS ARCHIVELOG FILESPERSET 20
DELETE ALL INPUT;
RELEASE CHANNEL CH1;
}
ALLOCATE CHANNEL FOR MAINTENANCE DEVICE TYPE DISK;
CROSSCHECK BACKUPSET;
DELETE NOPROMPT OBSOLETE;


没看到 delete archivelog 的内容啊


crosscheck archivelog all;
delete expired archivelog all;
or
DELETE ARCHIVELOG ALL COMPLETED BEFORE ‘SYSDATE-7';


