RMAN Crosscheck/Delete

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;