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

Other related posts: