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;

ITPub博客

RMAN校验与删除命令集合