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. **********************************************************************
