OraFAQ Forum: Backup & Recovery » RMAN Utility could not delete from TSM

Home » RDBMS Server » Backup & Recovery » RMAN Utility could not delete from TSM (oracle 10g/11g)

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

RMAN Utility could not delete from TSM [message #652136]

Thu, 02 June 2016 07:44

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.

Report message to a moderator

Re: RMAN Utility could not delete from TSM [message #652137 is a reply to message #652136]

Thu, 02 June 2016 07:52

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

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

Report message to a moderator

Re: RMAN Utility could not delete from TSM [message #652138 is a reply to message #652137]

Thu, 02 June 2016 08:10

evyaseen
Messages: 4
Registered: June 2016
Location: India

Junior Member

Hi Mike,

kindly share if you have any documents.

Thanks.

Report message to a moderator

Re: RMAN Utility could not delete from TSM [message #652139 is a reply to message #652138]

Thu, 02 June 2016 09:22

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: RMAN Utility could not delete from TSM [message #652140 is a reply to message #652138]

Thu, 02 June 2016 09:27

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

How about this?

Report message to a moderator

Re: RMAN Utility could not delete from TSM [message #652141 is a reply to message #652140]

Thu, 02 June 2016 09:42

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;
}

Report message to a moderator

Re: RMAN Utility could not delete from TSM [message #652142 is a reply to message #652141]

Thu, 02 June 2016 10:46

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: RMAN Utility could not delete from TSM [message #652143 is a reply to message #652142]

Thu, 02 June 2016 12:09

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.

Report message to a moderator

Re: RMAN Utility could not delete from TSM [message #652144 is a reply to message #652143]

Thu, 02 June 2016 12:19

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 22 01:50:14 CST 2024