Hi, I am having problems with my backups; I want to remove matching dbid's from the rman catalog without compromising te integrity of the catalog. I do however know a single way of removing them and its using the dbid and db_key which in my case are not not unique. The funny thing is they've running normally for a year now. The catalog db and target db are on separate machines on 9.2.0.8 SPARC64bit

Code: [Select all] [Show/ hide]

NAME DBID RESETLOGS_TIME
-------- ---------------------- -------------------------
RMANDB 3354934991 18-AUG-05
KFXPR 3575520995 09-DEC-10
KFXITM 13634474 20-SEP-05

DBID NAME DBINC_KEY RESETLOGS_CHANGE# RESETLOGS_TIME
---------------------- -------- ---------------------- ---------------------- -----------
3575520995 KFXPR 2723373 1 21-JUL-05
3575520995 KFXPR 2723256 8072570451 26-FEB-07
3575520995 KFXTST 2956477 11597299601 28-JUL-09
3575520995 KFXTRG 2982062 8631184115 09-SEP-09
3575520995 KFXTST 2982184 8486496999 10-SEP-09
3575520995 KFXPR 4171441 23661600403 09-DEC-10

6 rows selected
DB_KEY DBID NAME CURRENT_INCARNATION
---------------------- ---------------------- -------- -------------------
2723255 3575520995 KFXPR NO
2723255 3575520995 KFXPR NO
2723255 3575520995 KFXTST NO
2723255 3575520995 KFXTRG NO
2723255 3575520995 KFXTST NO
2723255 3575520995 KFXPR YES

6 rows selected

oracle@mogwana # rman catalog rman/rman@RMANDB target /
Recovery Manager: Release 9.2.0.4.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.

connected to target database: KFXPR (DBID=3575520995)
connected to recovery catalog database

RMAN> list incarnation;


List of Database Incarnations
DB Key Inc Key DB Name DB ID CUR Reset SCN Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1964 1965 KFXITM 13634474 YES 6061868006 20-SEP-05
1 2 RMANDB 3354934991 YES 1 18-AUG-05
2723255 2723373 KFXPR 3575520995 NO 1 21-JUL-05
2723255 2723256 KFXPR 3575520995 NO 8072570451 26-FEB-07
2723255 2982184 KFXTST 3575520995 NO 8486496999 10-SEP-09
2723255 2982062 KFXTRG 3575520995 NO 8631184115 09-SEP-09
2723255 2956477 KFXTST 3575520995 NO 11597299601 28-JUL-09
2723255 4171441 KFXPR 3575520995 YES 23661600403 09-DEC-10




I cannot use the below because 6 entries have the same dbkey and dbid.


SQL> execute dbms_rcvcat.unregisterdatabase(db_key, db_id);


I cannot use the SID as I have 3 entries with identical SID and DBID
The unregister procedure in the note previously does not work I've tried it
before when I wnated to unregister the other unique SID's.


Is there anyone who knows what can be done.