日期:2014-05-16 浏览次数:20502 次
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