Home » RDBMS Server » Backup & Recovery » Remove Duplicate DBID In Rman Catalog (Oracle 9i Release 2 64Bit - Production on SPARC 5.8)
Remove Duplicate DBID In Rman Catalog [message #494771] Thu, 17 February 2011 01:23 Go to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

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.

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

[Updated on: Thu, 17 February 2011 01:42] by Moderator

Report message to a moderator

Re: Remove Duplicate DBID In Rman Catalog [message #494777 is a reply to message #494771] Thu, 17 February 2011 01:44 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Try to UNREGISTER the wrong one.

Regards
Michel
Re: Remove Duplicate DBID In Rman Catalog [message #494783 is a reply to message #494777] Thu, 17 February 2011 02:05 Go to previous messageGo to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

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.



RMAN> RUN {
2> SET DBID 3575520995;
3> UNREGISTER DATABASE KFXTRG NOPROMPT;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, copy, crosscheck, configure, duplicate, debug, delete, execute, endinline, host, mount, open, plsql, recover, release, replicate, report, restore, resync, }, set, setlimit, sql, switch, startup, shutdown, send, show, validate"
RMAN-01008: the bad identifier was: UNREGISTER
RMAN-01007: at line 3 column 1 file: standard input
Re: Remove Duplicate DBID In Rman Catalog [message #494786 is a reply to message #494783] Thu, 17 February 2011 02:18 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I think you have to call Oracle to get it on this one (only them will be able to safely give you the statements to execute on the catalog).

Regards
Michel
Re: Remove Duplicate DBID In Rman Catalog [message #494788 is a reply to message #494786] Thu, 17 February 2011 02:35 Go to previous messageGo to next message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

Yeah , thanks anyway. Will post solution from Metalink (MyOracleSupport) once its provided.
Re: Remove Duplicate DBID In Rman Catalog [message #494796 is a reply to message #494788] Thu, 17 February 2011 02:54 Go to previous messageGo to next message
Michel Cadot
Messages: 60008
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks, waiting for your feedback.

Regards
Michel
Re: Remove Duplicate DBID In Rman Catalog [message #494835 is a reply to message #494783] Thu, 17 February 2011 04:44 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Unregister/register was introduced only in 10g.
If you never need older incarnations, can you just get rid of it using DBINC_KEY?
Ask support. Not sure how it works. Dont have 9i around for testing.

[Updated on: Thu, 17 February 2011 04:59]

Report message to a moderator

Re: Remove Duplicate DBID In Rman Catalog [message #494914 is a reply to message #494835] Thu, 17 February 2011 08:38 Go to previous message
drovnik
Messages: 34
Registered: January 2011
Location: Gaborone, Botswana
Member

Using the DBNEWID Utility I can change the dbid of the databases that I want to delete from the catalog. However I will still have a problem as I have 3 identical SID's and there is only 1 that I need and thats the one show 26-FEB-07 as the last ResetTime.
Previous Topic: RMAN backup
Next Topic: Accidentally delete a data file
Goto Forum:
  


Current Time: Sat Dec 20 21:42:11 CST 2014

Total time taken to generate the page: 0.08379 seconds