RE: Subject: RE: Purge RMAN backups from old repository

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <vitalisman@xxxxxxxxx>, <mjalsing@xxxxxxxxx>
  • Date: Thu, 23 Jun 2005 08:11:00 -0400

Manmohan,

Don't your tapes recycle themselves?  In other words, won't you at some
point in time simply overright the backups on tape - so in effect, they
will simply age out?  If so, then all you need to do is clean up the
Rman repository.

Tom

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Vitalis Jerome
Sent: Thursday, June 23, 2005 8:08 AM
To: mjalsing@xxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Subject: RE: Purge RMAN backups from old repository

Hi,

2 choices:
- start the 9i instance on another server and set up an additional
TDPO configuration for this server with the same parameters as the
primary server (i.e. make backup sets taken on server 1 accessible
from server 2). Then perform the RMAN maintenance operations on this
dummy instance.
or
- use the procedure Thomas showed you and execute command "tdposync"
after reading its documentation. Be very careful about which backup
pieces this tool proposes to delete though... (That's why I prefer
choice 1)

Cheers,
Jerome

On 6/22/05, Manmohan Jalsingh <mjalsing@xxxxxxxxx> wrote:
> Thanks Vitalis and Tom for your responses.
> 
> I need to drop the old RMAN backups from 9i repostory as well as from
tsm media.
> I can use the old control file to mount the 9i instance and then
delete the old
> backups. As, there is a 10g database running with  same SID, Oracle
may not allow
> me to start old 9i instance with same SID on same server.
> I will try using a different sid to mount the controlfile and then
delete the
> old backups. The dbid and dbname will still be same so RMAN should be
> able to find the old backups.
> 
> Regards,
> Manmohan
> x5813
> 
> 
> 
> 
> 
> --
> _______________________________________________
> NEW! Lycos Dating Search. The only place to search multiple dating
sites at once.
> http://datingsearch.lycos.com
> 
> --
> //www.freelists.org/webpage/oracle-l
>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: