|
|
|
|
|
|
| Re: backup set issue [message #536473 is a reply to message #535218] |
Wed, 21 December 2011 01:37   |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
hi,
Michel,the Catalog command have no effect.when i execute catalog command,the backup set is also obsolete.
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 4 21-DEC-11
Backup Piece 28 21-DEC-11 /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
RMAN> catalog backuppiece '/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak';
cataloged backuppiece
backup piece handle=/u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak recid=36 stamp=770478986
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 4 21-DEC-11
Backup Piece 36 21-DEC-11 /u01/rman_backup/2011/201111/mybak/df_768589674_5_1.bak
|
|
|
|
|
|
| Re: backup set issue [message #536487 is a reply to message #536482] |
Wed, 21 December 2011 02:18 |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Thanks,
Michel, it is my mistake! but i want to know if the backup sets are obsolete, how to make it available,that means the backup sets is not show in the report obsolete command.
|
|
|
|
|
|
| Re: backup set issue [message #536495 is a reply to message #536488] |
Wed, 21 December 2011 03:10 |
andy huang
Messages: 498
Registered: July 2011
|
Senior Member |
|
|
Thanks,
Michel, use the CHANGE command can do it.
RMAN> CHANGE backupset 4 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=4 recid=4 stamp=768589725
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
