1.将obsolete的备份集保留一段时间,使其可用(report obsolete不再列出该备份集).
使用change backupset命令
- RMAN> report obsolete;
- RMAN retention policy will be applied to the command
- RMAN retention policy is set to recovery window of 2 days
- Report of obsolete backups and copies
- Type Key Completion Time Filename/Handle
- -------------------- ------ ------------------ --------------------
- Backup Set 5 21-DEC-11
- Backup Piece 29 21-DEC-11 /u01/rman_backup/2011/201111/mybak/df_768589674_6_1.bak
- Backup Set 6 21-DEC-11
- Backup Piece 30 21-DEC-11 /u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak
- RMAN> CHANGE backupset 5 KEEP UNTIL TIME 'SYSDATE+180' nologs;
- using channel ORA_DISK_1
- keep attributes for the backup are changed
- backup will be obsolete on date 18-JUN-12
- archived logs required to recover from this backup will not be kept
- backup set key=5 recid=5 stamp=768589725
- RMAN> CHANGE backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589733_7_1.bak' KEEP UNTIL TIME 'SYSDATE+180' nologs;
- using channel ORA_DISK_1
- RMAN-00571: ===========================================================
- RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
- RMAN-00571: ===========================================================
- RMAN-03002: failure of KEEP command at 12/21/2011 15:09:39
- RMAN-06528: CHANGE ... KEEP not supported for BACKUPPIECE
从最后一个change backuppiece命令报错误可用看出,change keep命令不支持backuppiece.相关change命令
change datafilecopy '/tmp/control01.ctl' unavailable;
change copy of archivelog sequence between 1000 and 1012 unavailable;
change backupset 12 unavailable;
change backup of spfile tag "tag20020208t154556" unavailable;
change datafilecopy '/tmp/system01.dbf' available;
change backupset 12 available;
change backup of spfile tag "tag20020208t154556" available;
阅读(3574) | 评论(0) | 转发(1) |