David
Thanks for the info. We didn't change filespaces, but TDPOSYNC is
working.
Thanks
Mark
-----Original Message-----
From: David Longo [mailto:David.Longo AT HEALTH-FIRST DOT ORG]
Sent: Friday, May 30, 2003 11:51 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: RMAN orphaned backupsets
Could be real easy. If the filespace (instance) on TSM was not changed
AND a NEW filespace (instance was created on TDFP Oracle setup on
client for new DB instance, then it is simple. Do a DELETE FILESPACE
for the old filespace on the server.
EX:
NODE: ORASERVER
OLD instance/filesapce: /ora1fs
NEW instancefilespace: /ora2fs
Then delete filespace /ora1fs. If the TDP Oracle wasn't changed and
the new data is stored on TSM server under old filespace name, then
if you have TDP Oracle version 2.2 or later, read manual for the
utiility
TDPOSYNC. THis will compare what's on TSM server to whats's in
RMAN catalog. Then gives you a "pick window" like restores
to allow you to select items for deletion that are on TSM server
but not in the RMAN catalog.
David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH 321.434.5536
Pager 321.634.8230
Fax: 321.434.5509
david.longo AT health-first DOT org
>>> hagenm AT SJMO DOT NET 05/30/03 12:36PM >>>
We have been backing up an oracle database with RMAN successfully for a
few months now. A couple of weeks ago the DBA decided to rebuild the
production database that has been backed up. They proceeded to build
this new instance as a different name and once set up, export and import
the data into this new database. When they finished, they renamed the
instance to reflect to correct name. To get the RMAN backup to work,
they unregistered the old instance and reregistered the new instance ID.
The problem is that they didn't clean up all the old backups prior to
unregistering the old instance. How can I manually remove the old
backups from TSM since it seems that RMAN doesn't know about them
anymore?
Thanks
Mark
##############################################################
This message is for the named person's use only. It may
contain confidential, proprietary, or legally privileged
information. No confidentiality or privilege is waived or
lost by any mistransmission. If you receive this message
in error, please immediately delete it and all copies of it
from your system, destroy any hard copies of it, and notify
the sender. You must not, directly or indirectly, use,
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient. Health First reserves
the right to monitor all e-mail communications through its
networks. Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of
a particular entity; and (2) the sender is authorized by
the entity to give such views or opinions.
##############################################################
|
