备份集维护相关

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;