Home » RDBMS Server » Backup & Recovery » backup set issue (11.2.0.1 windows xp)
backup set issue [message #535043] Sun, 11 December 2011 18:54 Go to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Dear all,
If one of my backup sets has expired,how to make it available again?
Re: backup set issue [message #535044 is a reply to message #535043] Sun, 11 December 2011 23:07 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Recatalog it using CATALOG command.

Regards
Michel
Re: backup set issue [message #535218 is a reply to message #535044] Mon, 12 December 2011 21:20 Go to previous messageGo to next message
andy huang
Messages: 498
Registered: July 2011
Senior Member
Thanks Michel!
Re: backup set issue [message #536473 is a reply to message #535218] Wed, 21 December 2011 01:37 Go to previous messageGo to next message
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 #536482 is a reply to message #536473] Wed, 21 December 2011 02:02 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is obsolete but not expired which was your question.
Your obsolete question was in another of your numerous topics and the answer was different.

Regards
Michel
Re: backup set issue [message #536487 is a reply to message #536482] Wed, 21 December 2011 02:18 Go to previous messageGo to next message
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 #536488 is a reply to message #536487] Wed, 21 December 2011 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use CATALOG with the KEEP option.

Regards
Michel

Re: backup set issue [message #536495 is a reply to message #536488] Wed, 21 December 2011 03:10 Go to previous messageGo to next message
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
Re: backup set issue [message #536504 is a reply to message #536495] Wed, 21 December 2011 03:54 Go to previous message
Michel Cadot
Messages: 65849
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback.

Regards
Michel
Previous Topic: recover issue
Next Topic: Background Engine has encounter Problem
Goto Forum:
  


Current Time: Mon Oct 22 18:57:19 CDT 2018