| target database name does not match name in recovery catalog [message #423592] |
Fri, 25 September 2009 07:59  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
