Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Subject: RE: Purge RMAN backups from old repository

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

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Thu, 23 Jun 2005 08:11:00 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF16E735@EXCNYSM0A1AJ.nysemail.nyenet>


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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Vitalis Jerome Sent: Thursday, June 23, 2005 8:08 AM
To: mjalsing_at_lycos.com
Cc: oracle-l_at_freelists.org
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_at_lycos.com> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 23 2005 - 08:16:16 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US