ADSM-L

Re: Deleting RMAN versions

2001-12-12 04:40:01
Subject: Re: Deleting RMAN versions
From: "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT COM>
Date: Wed, 12 Dec 2001 10:36:53 +0100
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


<Prev in Thread] Current Thread [Next in Thread>