Home » RDBMS Server » Backup & Recovery » Delete Obsolete Files backed up to Tapes using RMAN (Oracle 9i)
Delete Obsolete Files backed up to Tapes using RMAN [message #583976] Tue, 07 May 2013 11:22 Go to next message
TRaj
Messages: 80
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.
Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583978 is a reply to message #583976] Tue, 07 May 2013 11:28 Go to previous messageGo to next message
John Watson
Messages: 4081
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?
Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583980 is a reply to message #583978] Tue, 07 May 2013 11:58 Go to previous messageGo to next message
TRaj
Messages: 80
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?
Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583986 is a reply to message #583980] Tue, 07 May 2013 12:38 Go to previous messageGo to next message
Michel Cadot
Messages: 57608
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
Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583993 is a reply to message #583986] Tue, 07 May 2013 13:32 Go to previous messageGo to next message
TRaj
Messages: 80
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!
Re: Delete Obsolete Files backed up to Tapes using RMAN [message #583994 is a reply to message #583993] Tue, 07 May 2013 13:38 Go to previous messageGo to next message
John Watson
Messages: 4081
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).
Re: Delete Obsolete Files backed up to Tapes using RMAN [message #584086 is a reply to message #583994] Wed, 08 May 2013 09:42 Go to previous message
TRaj
Messages: 80
Registered: September 2006
Member

Thanks John and Michel.
Previous Topic: get DBID of crashed database
Next Topic: Recovery through RMAN 10g
Goto Forum:
  


Current Time: Fri Apr 18 01:13:36 CDT 2014

Total time taken to generate the page: 0.06102 seconds