Home » RDBMS Server » Backup & Recovery » report obsolete (10g windows 2003 server)
report obsolete [message #281359] Fri, 16 November 2007 09:08 Go to next message
garry143
Messages: 17
Registered: November 2007
Junior Member
i'm lil confused about rman's obsolete backups.

i have set revovery window of 8 days, and my control_file_record_keep_time is 10 days.
rman is storing two backupprices in each backup set.
eg. O1_MF_NCSN1_TAG20071107T040139_3M308D9L_.BKP-- this is control file and spfile backup
and O1_MF_NNND1_TAG20071107T040139_3M2ZQMX6_.BKP-- this is datafiles backup.

so when i run report obsolete it only shows O1_MF_NCSN1_TAG20071107T040139_3M308D9L_.BKP as obsolete (which is older than 8 days, and does not show O1_MF_NNND1_TAG20071107T040139_3M2ZQMX6_.BKP as obsolete( itz also older than 8 days)

So i have to manualy delete the other backup piece every day.

Does anyone know why rman doesn't consider datafile backup as obsolete.

any help would be greatly appreciated.

Thanks
Re: report obsolete [message #281366 is a reply to message #281359] Fri, 16 November 2007 09:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

does not show O1_MF_NNND1_TAG20071107T040139_3M2ZQMX6_.BKP as obsolete( itz also older than 8 days)

It may be needed to restore the database at a date earlier than 8 days even if it is older than 8 days.

Obsolete does not mean "older than" but "not necessary to restore a database younger than".

For instance, if you specify a retention of 8 days and take a backup each Sunday then backup of 2 Sundays before (the one from 11/04 today) is necessary even it is 12 days old.

Regards
Michel
Re: report obsolete [message #281375 is a reply to message #281359] Fri, 16 November 2007 10:29 Go to previous messageGo to next message
garry143
Messages: 17
Registered: November 2007
Junior Member
thanks

so even if i take full rman backup every sunday and
incr backup mon thru sat..
it won't delete the rman backups which r older than 8 days( it doesnt delete even inc backups which r 12 days older)
Re: report obsolete [message #281378 is a reply to message #281375] Fri, 16 November 2007 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you ask him to retain all what is necessary to restore a database 8 days before (this is your retention policy), so it applies it.

Regards
Michel
Re: report obsolete [message #281379 is a reply to message #281359] Fri, 16 November 2007 10:40 Go to previous message
garry143
Messages: 17
Registered: November 2007
Junior Member
Thanks Michael
Previous Topic: Can Rman backup DB at lower version
Next Topic: backup archivelog all delete input
Goto Forum:
  


Current Time: Sun Dec 11 06:20:11 CST 2016

Total time taken to generate the page: 0.07568 seconds