Home » RDBMS Server » Backup & Recovery » RMAN Utility could not delete from TSM (oracle 10g/11g)
icon9.gif  RMAN Utility could not delete from TSM [message #652136] Thu, 02 June 2016 07:44 Go to next message
evyaseen
Messages: 4
Registered: June 2016
Location: India
Junior Member
Hi ,

My oracle RMAN backups are directly taken to TSM .

RMAN purge script running fine and deleting expired/obsolete files.But TSM team saying still old images are there . Now we are forced to use tdposync syncdb command to delete files.

Is there anyway to fix this issue , so that we can delete files from TSM without using tdposync utility.

Your helps are appreciated.

Regards,
Yaseen.
Re: RMAN Utility could not delete from TSM [message #652137 is a reply to message #652136] Thu, 02 June 2016 07:52 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Yes, there is, you have to check your TDPO/TSM manual to know the configuration parameters to allow this.

Re: RMAN Utility could not delete from TSM [message #652138 is a reply to message #652137] Thu, 02 June 2016 08:10 Go to previous messageGo to next message
evyaseen
Messages: 4
Registered: June 2016
Location: India
Junior Member
Hi Mike,


kindly share if you have any documents.

Thanks.
Re: RMAN Utility could not delete from TSM [message #652139 is a reply to message #652138] Thu, 02 June 2016 09:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I used TDPO in the earlier years of this century, so it might be very different now, it was version 2.1.
You should have a document named something like "Tivoli Data Protection for Oracle for UNIX Installation and User's Guide".
Ask your DBA or TSM administrator.

I can't post anything from this document as it is copyrighted IBM and it is specified "Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.", so if you have not the document ask your IBM contact.

Re: RMAN Utility could not delete from TSM [message #652140 is a reply to message #652138] Thu, 02 June 2016 09:27 Go to previous messageGo to next message
gazzag
Messages: 909
Registered: November 2010
Location: Bristol, UK
Senior Member
How about this?
Re: RMAN Utility could not delete from TSM [message #652141 is a reply to message #652140] Thu, 02 June 2016 09:42 Go to previous messageGo to next message
evyaseen
Messages: 4
Registered: June 2016
Location: India
Junior Member
Thanks Gazzag.

Mike ,

did you meant the below steps to delete from RMAN ?

To remove an old backup, issue this command from the RMAN prompt:
run
{
allocate channel for delete type 'sbt_tape' parms 'ENV=(TDPO_OPTFILE=/home/oracle/tdpo.opt)';
change backupset backupset number delete;
}

Re: RMAN Utility could not delete from TSM [message #652142 is a reply to message #652141] Thu, 02 June 2016 10:46 Go to previous messageGo to next message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

The problem is NOT in RMAN, it is in TDPO and TSM configuration.
You should read the document gazzag posted, it contains what you have to do.

Re: RMAN Utility could not delete from TSM [message #652143 is a reply to message #652142] Thu, 02 June 2016 12:09 Go to previous messageGo to next message
evyaseen
Messages: 4
Registered: June 2016
Location: India
Junior Member
Mike ,

As i am not much familiar with TDPO / TSM configuration , would you mind sharing the required configuration steps here .

thanks in advance.
Re: RMAN Utility could not delete from TSM [message #652144 is a reply to message #652143] Thu, 02 June 2016 12:19 Go to previous message
Michel Cadot
Messages: 65387
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

It would be better YOU read the documentation than I read it for you and tell you what's inside.
Did you at least read the toc?
When I don't want to read some doco and want to rapidly get something I search for a keyword in it (hopefully you have a PDF easily searchable. What about searching for "delete" as this is what you want to do?

Previous Topic: Why did rman complain about archivelog not available based on the current retention policy
Next Topic: sql developer backup
Goto Forum:
  


Current Time: Thu Feb 22 17:43:57 CST 2018

Total time taken to generate the page: 0.02335 seconds