RE: Purge RMAN backups from old repository

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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l