| Crosscheck Backup - number of expired backups issue [message #538215] |
Wed, 04 January 2012 13:09  |
 |
sundog
Messages: 8
Registered: January 2012
|
Junior Member |
|
|
|
I've done a crosscheck backup in RMAN and the list of expired objects has actually gone down, in number, from the last time I did this ( 2 weeks prior). We do NOT delete anything from our RMAN catalog on a routine basis (ie. no "DELETE EXPIRED BACKUP commands were issued) so normally the list of expired backup objects increases with each RMAN maintenance task we do. Can someone tell me why the number of expired objects might actually go down in this particular instance ?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Crosscheck Backup - number of expired backups issue [message #539799 is a reply to message #539778] |
Wed, 18 January 2012 10:44  |
 |
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
|
Member |
|
|
I was again reading the whole thread and everything seems normal.
Quote:Our backup strategy is that these backs are deleted after 7 days
And your retention window in rman in 45 days ,so it is understood that when you are firing "delete obsolete" it will not delete any backup of database because it is already deleted .
Now the question is "delete obsolete" only deleting the backup of controlfile ,this is because you might have not specified to delete backup of controlfile in your script when you are deleting 7 days old backup.
Am i missing anything?
[Updated on: Wed, 18 January 2012 10:53] Report message to a moderator |
|
|
|
|
|
| Re: Crosscheck Backup - number of expired backups issue [message #539847 is a reply to message #539831] |
Wed, 18 January 2012 21:59 |
|
himabija
Messages: 33
Registered: December 2011
Location: San Francisco
|
Member |
|
|
Can you provide the complete content of your script which deletes the backups.
Anyway what I have understood your script is having
"delete obsolete". You should keep in mind that this command will only delete the entry which is marked as 'obsolte' So check the obsolete backups using "report obsolete" before deleting obsolete backups.
Quote:but why are not the corresponding backup piece entries from December 2nd not being addressed also ?
Can you see the entry of above backup piece when you issue "report obsolete" command? if the answer is 'NO' there is nothing more from my side to contribute.
To delete the backup which is already marked as "expired" you need to use "delete expired" command specificly.
[Updated on: Wed, 18 January 2012 22:00] Report message to a moderator |
|
|
|
| Re: Crosscheck Backup - number of expired backups issue [message #540141 is a reply to message #539847] |
Fri, 20 January 2012 07:17 |
|
sundog
Messages: 8
Registered: January 2012
|
Junior Member |
|
|
As requested, below is our backup script:
printing stored script: instance_hot_arc_bkup
{ CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
configure CHANNEL device type disk format '/u01/orabkup/rman/instance/hot/bkup_%u_%s_%p';
backup database plus archivelog delete input;
delete noprompt obsolete;
}
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
