OraFAQ Forum: Backup & Recovery » Delete Obsolete Files backed up to Tapes using RMAN

Home » RDBMS Server » Backup & Recovery » Delete Obsolete Files backed up to Tapes using RMAN (Oracle 9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Delete Obsolete Files backed up to Tapes using RMAN [message #583976]

Tue, 07 May 2013 11:22

TRaj
Messages: 82
Registered: September 2006

Member

Hi,

A clarification ....

When delete obsolete issued, the files which got aged (based on the retention policy) are deleted from the currently loaded tape (Legato Networker), updated in the control file as deleted for those files and removed the repository data from the catalog database.

My question here is .... There are backup files stored in another tape(s). So what will the status of those file's metadata in recovery catalog?

Thanks in advance.

Report message to a moderator

Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583978 is a reply to message #583976]

Tue, 07 May 2013 11:28

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

I can't remember how 9i reacted to such a situation, but I think that if you are manually changing tapes rather than having a robot load them automatically, you have another problem to deal with first: RMAN will not be aware that the tape has been changed. Before you run your DELETE OBSOLETE, can you run a CROSSCHECK BACKUPSET (if that was the command back then) and see what you get back?

Report message to a moderator

Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583980 is a reply to message #583978]

Tue, 07 May 2013 11:58

TRaj
Messages: 82
Registered: September 2006

Member

Tapes are replaced manually by the backup team every Tuesday! That's why I asked how to deal in this case?

Report message to a moderator

Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583986 is a reply to message #583980]

Tue, 07 May 2013 12:38

Michel Cadot
Messages: 68421
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

You have to:
1/ Manually delete the backups (or the tapes)
2/ Update the catalog using the DELETE OBSOLETE command.

Regards
Michel

Report message to a moderator

Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583993 is a reply to message #583986]

Tue, 07 May 2013 13:32

TRaj
Messages: 82
Registered: September 2006

Member

Thanks Michel.

Sorry, the subject of this post gave a wrong meaning and confused! What I mean was how to delete files and remove from catalog when tapes gets changed!

Report message to a moderator

Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583994 is a reply to message #583993]

Tue, 07 May 2013 13:38

John Watson
Messages: 8805
Registered: January 2010
Location: Global Village

Senior Member

Quote:

Sorry, the subject of this post gave a wrong meaning and confused! What I mean was how to delete files and remove from catalog when tapes gets changed!

crosscheck backupset;
delete expired backupset;

(or the equivalent for your rather old release).

Report message to a moderator

Re: Delete Obsolete Files backed up to Tapes using RMAN [message #584086 is a reply to message #583994]

Wed, 08 May 2013 09:42

TRaj
Messages: 82
Registered: September 2006

Member

Thanks John and Michel.

Report message to a moderator

Previous Topic:	get DBID of crashed database
Next Topic:	Recovery through RMAN 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Mar 31 01:04:47 CDT 2023