Eric,
Thanks you very much the delete object command is exactly what I'm
looking for i'll use it in this script once I tweak it a little more to
strip out headers and spaces:
SELECT 'delete object 0', BACKUPS.OBJECT_ID FROM BACKUPS BACKUPS
WHERE (BACKUPS.NODE_NAME='EQPSP01_RMAN') AND (BACKUPS.BACKUP_DATE>{ts '2000-11-12
00:00:00'})
"Loon, E.J. van - SPLXM" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
12/12/2001 04:36:53 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: Deleting RMAN versions
Hi James!
No, you need to have 2.2 when you want to use the tdposync utility.
There is another way to get rid of them, but it requires a lot of manual
work and its uses non supported TSM commands.
Issue the following command through the admin commandline interface:
select * from backups where node_name='NODENAME' > c:\Mydir\Myfile.txt
Replace the NODENAME by your clients node name. In caps!!!
This commands lists all files stored on the TSM server for NODENAME.
Have your Oracle Admin compare this list of files with thee catalog entries
and have them return the list of orphaned entries.
Each file is listed with the OBJECT_ID parameter. You can manually delete
entries by using the following command:
delete object 0 OBJECT_ID <= replace this by the object id number.
Remember! This is a unsupported way of deleting backups and you do this on
your own risk!!!
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-----Original Message-----
From: <James> <healy> [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 17:05
To: [EMAIL PROTECTED]
Subject: Re: Deleting RMAN versions
Eric,
No I'm using version 2.1 is that utility available in 2.1?
"Loon, E.J. van - SPLXM" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on
12/11/2001 10:54:16 AM
Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc:
Subject: Re: Deleting RMAN versions
Hi James!
What version of TDP are you using? If it's 2.2, you can use the tdposync
utility.
Kindest regards,
Eric van Loon
KLM Royal Dutch Airlines
-----Original Message-----
From: <James> <healy> [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 11, 2001 16:30
To: [EMAIL PROTECTED]
Subject: Deleting RMAN versions
Can anyone tell me how to delete orphaned RMAN backup versions from the TSM
database?
Our DBAs have deleted the catalog entries and now I'm left with these
orphaned versions that I can see with the show version command but I don't
know how to delete.
TIA,
Jim
**********************************************************************
This e-mail and any attachment may contain confidential and privileged
material intended for the addressee only. If you are not the addressee, you
are notified that no part of the e-mail or any attachment may be disclosed,
copied or distributed, and that any other action related to this e-mail or
attachment is strictly prohibited, and may be unlawful. If you have
received this e-mail by error, please notify the sender immediately by
return e-mail, and delete this message. Koninklijke Luchtvaart Maatschappij
NV (KLM), its subsidiaries and/or its employees shall not be liable for the
incorrect or incomplete transmission of this e-mail or any attachments, nor
responsible for any delay in receipt.
**********************************************************************
