日期:2014-05-16  浏览次数:20466 次

删除过期备份

 1. 设置保留最近的3次备份
  
  RMAN> configure retention policy to redundancy 3;
  
  old RMAN configuration parameters:
  CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
bitsCN_com


  new RMAN configuration parameters:
  CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
  new RMAN configuration parameters are successfully stored
  starting full resync of recovery catalog
  full resync complete
  
  2. 查看过期的备份
  
  RMAN> report obsolete;
  
  
  3. 查看所有备份
  
  RMAN> list backup;
  
  11. 删除过期备份
  
  RMAN> delete obsolete;
  
  RMAN retention policy will be applied to the command bitsCN.Com
  RMAN retention policy is set to redundancy 2
  using channel ORA_DISK_1
  Deleting the following obsolete backups and copies:
  Type         Key  Completion Time  Filename/Handle
  -------------------- ------ ------------------ --------------------
  Backup Set      590  16-OCT-05
   Backup Piece    591  16-OCT-05     /oracle/testmysiteok20051016.dbf
  Archive Log     424  29-SEP-05     /oracle/OraHome/dbs/arch1_56.dbf
  
  Do you really want to delete the above objects (enter YES or NO)? y
  deleted backup piece
  backup piece handle=/oracle/testmysiteok20051016.dbf recid=15 stamp=571867105
  Deleted 1 objects