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;
      

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值