| Remove Duplicate DBID In Rman Catalog [message #494771] |
Thu, 17 February 2011 01:23  |
 |
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 #494783 is a reply to message #494777] |
Thu, 17 February 2011 02:05  |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
