这时要进行交叉检测:
RMAN> change archivelog all crosscheck;
RMAN-03009
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%U_%F';
改回默认值 '%F'
Rman>list backup
删除过期备份。当使用RMAN命令执行备份操作时,RMAN会根据备份冗余策略确定备份是否过期。
RMAN> DELETE OBSOLETE;
删除无效备份。首先执行CROSSCHECK命令核对备份集,如果发现备份无效(比如备份对应的数据文件损坏或丢失),RMAN会将该备份集标记为EXPIRED状态。要删除相应的备份记录,可以执行DELETE EXPIRED BACKUP命令:
RMAN> DELETE EXPIRED BACKUP;
删除EXPIRED副本,如下所示:
RMAN> DELETE EXPIRED COPY;
删除特定备份集,如下所示:
RMAN> DELETE BACKUPSET 19;
删除特定备份片,如下所示:
RMAN> DELETE BACKUPPIECE 'd:\backup\DEMO_19.bak';
删除所有备份集,如下所示:
RMAN> DELETE BACKUP;
删除特定映像副本,如下所示:
RMAN> DELETE DATAFILE COPY 'd:\backup\DEMO_19.bak';
删除所有映像副本,如下所示:
RMAN> DELETE COPY;
在备份后删除输入对象,如下所示:
RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;
RMAN> DELETE BACKUPSET 22 FORMAT = "d:\backup\%u.bak" DELETE INPUT;