Remove DB from RMAN Catalog

If using the Oracle password wallet, it is also possible to logon to the DB with rman without password.

(For this, before logon with rman, make sure that the environment variable TNS_ADMIN "points" to the Password wallet directory.)

In this example, the TNS-Alias of the RMAN-Catalog DB is "RMANCAT"

OS> rman catalog /@RMANCAT

Get the ID of your DB:

RMAN> list db_unique_name of database 'DB1_SID'; List of Databases DB Key  DB Name  DB ID            Database Role    Db_unique_name ------- ------- ----------------- ---------------  ------------------ 281963  DB1_SID 1738134485        PRIMARY          DB1_SITE1   281963  DB1_SID 1738134485        STANDBY          DB1_SITE2   394582  DB1_SID 5396830648        PRIMARY          DB5_SITE1

Set the DBID of the DB to be removed in the RMAN environment:

RMAN> set dbid 1738134485 executing command: SET DBID database name is "DB1_SID" and DBID is 1738134485

Execute the unregister statement using the SID of your DB:

RMAN> unregister database DB1_SID; database name is "DB1_SID" and DBID is 1738134485 Do you really want to unregister the database (enter YES or NO)? YES database unregistered from the recovery catalog

The unregistered DBs with ID 1738134485 are now gone:

RMAN> list db_unique_name of database 'DB1_SID'; List of Databases DB Key  DB Name  DB ID        Database Role    Db_unique_name ------- ------- ------------- ---------------  ------------------ 394582  DB1_SID 5396830648    PRIMARY          DB5_SITE1

.

.