RE: Purge RMAN backups from old repository

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_at_gmail.com] Sent: Tuesday, June 21, 2005 6:29 AM
To: Mercadante, Thomas F (LABOR)
Cc: mjalsing_at_lycos.com; oracle-l_at_freelists.org 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_at_labor.state.ny.us> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Manmohan Jalsingh
> Sent: Friday, June 17, 2005 12:42 PM
> To: oracle-l_at_freelists.org
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
> --
> http://www.freelists.org/webpage/oracle-l
>

--
http://www.freelists.org/webpage/oracle-l