ADSM-L

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

2005-09-08 10:17:52
Subject: Re: Oracle TDP - Help with removing files from a filespace created by rman nocatalog
From: Peter Hitchman <Peter.Hitchman AT THOMSON DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 8 Sep 2005 15:17:47 +0100
Hi,
Thanks for the reply. Starting again is the conclusion I have arrived at, as 
well. Point taken about how you backup the catalog db, I should consider how I 
could schedule this in.

Thanks

Pete

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Andreas Almroth
Sent: 08 September 2005 14:06
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] Oracle TDP - Help with removing files from a
filespace created by rman nocatalog


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

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