RE: Purge RMAN backups from old repository

From: Mercadante, Thomas F (LABOR) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Mon, 20 Jun 2005 07:21:09 -0400
Message-ID: <ABB9D76E187C5146AB5683F5A07336FF16E706@EXCNYSM0A1AJ.nysemail.nyenet>

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 Received on Mon Jun 20 2005 - 07:26:59 CDT