Home » RDBMS Server » Backup & Recovery » target database name does not match name in recovery catalog (Rman 10.2.0.4)
target database name does not match name in recovery catalog [message #423592] Fri, 25 September 2009 07:59 Go to next message
d_ponnilavan
Messages: 13
Registered: May 2005
Location: india
Junior Member
Hi,
I'm very new to RMAN, I've some issue with my rman setup, Could you help fix it? Details are below

Env detail : 10.2.0.4 Oracle DBs, running in Sun Solaris 5.9

I recently refreshed my dev DB with Release DB by regular OS coping of datafiles.
After that I changed the dev DB's dbid using nid. Both the datasebases uses Rman catalog for backup/recovery. I registeded the dev db with rman after refresh as the dbid got changed. but after this refresh activity release database backup is not happening. it throws the below error

RMAN-06004: ORACLE error from recovery catalog database:
RMAN-20004: target database name does not match name in recovery catalog

Here is what i see in rman.


RMAN> list incarnation of database rel;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- [color=red]----------
26511485 26518134 REL 416632618        PARENT  394128640624 12-JUN-06
26511485 26518135 REL 416632618        PARENT  394134269539 08-JUL-06[/color]


RMAN> list incarnation of database dev;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
[color=red]26511485 26511486 DEV 416632618        PARENT  394134270717 08-JUL-06
26511485 44592318 DEV 416632618        CURRENT 9689510377931 20-SEP-09[/color]
2869098 2869115 DEV 1156754909       PARENT  403367121225 26-FEB-07
2869098 2869099 DEV 1156754909       CURRENT 403367123691 26-FEB-07
4393304 4393321 DEV 1164442766       PARENT  411603311876 22-MAY-07
4393304 4393305 DEV 1164442766       CURRENT 411603312527 22-MAY-07
6424823 6424840 DEV 1172902452       PARENT  416352076660 27-AUG-07
6424823 6424824 DEV 1172902452       CURRENT 416352079071 27-AUG-07
8295125 8295142 DEV 1181197377       PARENT  420685555856 30-NOV-07
8295125 8295126 DEV 1181197377       CURRENT 420685586927 30-NOV-07
14188150 14188165 DEV 1193852801       PARENT  428680671163 22-APR-08
14188150 14188151 DEV 1193852801       CURRENT 428680672652 22-APR-08
27556109 27556127 DEV 1216531133       PARENT  9676230970380 05-JAN-09
27556109 27556110 DEV 1216531133       CURRENT 9676230971582 05-JAN-09
35074165 35074183 DEV 1226467594       PARENT  9689462507769 27-APR-09
35074165 35074166 DEV 1226467594       CURRENT 9689462510996 27-APR-09
[color=red]44592343 44592361 DEV 1239283933       PARENT  9689510377931 20-SEP-09
44592343 44592344 DEV 1239283933       CURRENT 9689510379035 21-SEP-09[/color]



Here Inc Key 44592318 of Dev's reset date shows the date of the actual refresh. Is this causing the problem? if so how do I get rid of this.

Thanks in advance for your time,
Ponnilavan

[Updated on: Fri, 25 September 2009 10:36] by Moderator

Report message to a moderator

Re: target database name does not match name in recovery catalog [message #423622 is a reply to message #423592] Fri, 25 September 2009 10:46 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
There is no need to register the DEV database (the one that was restored) again to catalog, unless you want to backup it or do other rman operations.
For issues like this, I always use separate catalog users(separate schema inside catalog database) for each database to be registered.
In your case, you have one catalog for two databases.
DEV is registered and rman catalog is currently looking into it.
Register REL database again and give a try.
Previous Topic: Recover but don't know if database is Archive or Noarchive
Next Topic: ORA-01034: Oracle Not Available - I know what I did, but I don't know how to fix it
Goto Forum:
  


Current Time: Fri Mar 29 10:00:42 CDT 2024