RE: Purge RMAN backups from old repository
- From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
- To: "Vitalis Jerome" <vitalisman@xxxxxxxxx>
- Date: Tue, 21 Jun 2005 07:51:24 -0400
Vitalis,
But he didn't ask about that. He said he migrated the database to 10g
and needed to delete the database from the 9i Rman repository. Since he
migrated to 10g, then the 9i backups are toast anyway.
Most media managers have the ability to drop backups via other commands.
But, again, he probably will use the same tapes for the 10g backups.
Tom
-----Original Message-----
From: Vitalis Jerome [mailto:vitalisman@xxxxxxxxx]
Sent: Tuesday, June 21, 2005 6:29 AM
To: Mercadante, Thomas F (LABOR)
Cc: mjalsing@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Purge RMAN backups from old repository
AFAIR executing this procedure won't delete the backups of the old 9i.
If Manmohan uses a media manager, it would be desynchronized from the
catalog and the backups on tapes would never expire.
Jerome
On 6/20/05, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante@xxxxxxxxxxxxxxxxx> wrote:
> Manmohan,
>
> Connect to the Rman repository via sqlplus as your Rman user. You do
> *not* have to have your old 9i database up and running.
>
> Run the following script to remove (unregister) the database within
the
> Rman Catalog:
>
> To remove a database from an Rman catalog, you must use a stored
package
> provided by Oracle.
>
> Declare
> L_dbkey number;
> L_dbid number;
> begin
>
> select db_key,dbid
> into l_dbkey,l_dbid;
> from rc_database
> where name = 'dbname';
>
> dbms_rcvcat.unregisterdatabase(l_dbkey,l_dbid);
>
> End;
>
>
> Good Luck!
>
> Tom
>
>
>
> -----Original Message-----
> From: oracle-l-bounce@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Manmohan Jalsingh
> Sent: Friday, June 17, 2005 12:42 PM
> To: oracle-l@xxxxxxxxxxxxx
> Subject: Purge RMAN backups from old repository
>
> Is there a way to delete the RMAN backup from old RMAN repository. I
> upgraded a database from 9i to 10g and switched to 10g repository for
> RMAN backup. I want to delete the older backup from 9i repository. I
> still have the saved copies of 9i version controlfiles.
>
> Thanks
> Manmohan
>
>
> --
> _______________________________________________
> 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:
