CROSSCHECK命令:校验备份信息
RMAN> crosscheck backup; 核对所有备份集;
RMAN> crosscheck backup of database; 核对所有数据文件的备份集;
RMAN> crosscheck backup of tablespace users; 核对特定表空间的备份集;
RMAN> crosscheck backup of datafile 4; 核对特定数据文件的备份集;
RMAN> crosscheck backup of controlfile; 核对控制文件的备份集;
RMAN> crosscheck backup of spfile; 核对SPFILE的备份集;
RMAN> crosscheck backup of archivelog sequence 3; 核对归档日志的备份集;
RMAN> crosscheck copy ; 核对所有映像副本;
RMAN> crosscheck copy of database; 核对所有数据文件的映像副本;
RMAN> crosscheck copy of tablespace users; 核对特定表空间的映像副本;
RMAN> crosscheck copy of datafile 6 ; 核对特定数据文件的映像副本;
RMAN> crosscheck copy of archivelog sequence 4; 核对归档日志的映像副本;
RMAN> crosscheck copy of controlfile; 核对控制文件的映像副本;
RMAN> crosscheck backup tag='SAT_BACKUP';
RMAN> crosscheck backup completed after 'sysdate - 2' ;
RMAN> crosscheck backup completed between 'sysdate - 5' and 'sysdate -2 ';
RMAN> crosscheck backup device type sBT;
RMAN> crosscheck archivelog all;
RMAN> crosscheck archivelog like '%ARC00012.001';
RMAN> crosscheck archivelog from sequence 12;
RMAN> crosscheck archivelog until sequence 522;
DELETE:删除备份
RMAN> delete obsolete; 删除陈旧备份;
RMAN> delete expired backup; 删除EXPIRED备份
RMAN> delete expired copy; 删除EXPIRED副本;
RMAN> delete backupset 19; 删除特定备份集;
RMAN> delete backuppiece ''d:\backup\DEMO_19.bak'' 删除特定备份片;
RMAN> delete backup ; 删除所有备份集;
RMAN> delete datafilecopy ''d:\backup\DEMO_19.bak''; 删除特定映像副本;
RMAN> delete copy; 删除所有映像副本;
RMAN> delete archivelog all delete input;
RMAN> delete backupset 22 format = ''d:\backup\%u.bak'' delete input;