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

Report message to a moderator

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: 68653
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

Report message to a moderator

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)

Report message to a moderator

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: 68653
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

Report message to a moderator

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

Report message to a moderator

Previous Topic: Can Rman backup DB at lower version
Next Topic: backup archivelog all delete input
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 20 08:48:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.