ADSM-L

Re: Oracle TDP - Help with removing files from a filespace created by rman nocatalog

2005-09-08 09:06:02
Subject: Re: Oracle TDP - Help with removing files from a filespace created by rman nocatalog
From: Andreas Almroth <almrot_a AT MTNCAMEROON DOT NET>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 8 Sep 2005 14:05:48 +0100
Peter Hitchman wrote:

Hi,
I have backups using TDP for Oracle of my rman catalog database. These are done 
in nocatalog mode, so the records of the backup are kept in the database 
control file. My problem is that I now have files in a filespace that are no 
longer referenced by rman and I do not know how to delete them. What is my best 
way of getting rid of these backup entries in TSM?

Regards

Pete


Tricky one. OK, I must admit I'm not a wizard, but nothing immediate
comes to mind, apart from deleting the filespace for the client node,
and start all over. That will of course delete any valid backup pieces
as well, which is bad, but you could make a new backup manually after
deleting the filespace, and you would have at least one backup again.

I have choosen to backup the catalog db in cold mode, just using the
normal dsm scheduler, shutting down and starting the instance as part of
the pre and post backup scripts, and thus not involve the TDP module at
all. This way I don't need a working RMAN/TDP environment if I ever need
restore the catalog instance.

/Andreas