RE: Purge RMAN backups from old repository

  • From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante@xxxxxxxxxxxxxxxxx>
  • To: <mjalsing@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 20 Jun 2005 07:21:09 -0400


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.

L_dbkey number;
L_dbid  number;

  select db_key,dbid
   into l_dbkey,l_dbid;
  from rc_database
  where name = 'dbname';



Good Luck!


-----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.


NEW! Lycos Dating Search. The only place to search multiple dating sites
at once.


Other related posts: