Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

RMAN-05520: database name mismatch, auxiliary instance has ORADB

007Mar 9 2013 — edited Mar 9 2013
Hi,

i am using Oracle 10g (10.2.0.1.0) in RHEL 5 server. i am trying to duplicate my primary database(ORADB) to standby database with name DEVDB in different server. I have taken an RMAN backup and transferred to standby server and now i am trying to duplicate with the below commands

[oracle@rhel5 data]$ rman target / auxiliary sys/oracle@DEVDB

Recovery Manager: Release 10.2.0.1.0 - Production on Sat Mar 9 16:11:52 2013

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: ORADB (DBID=2542358497, not open)
connected to auxiliary database: ORADB (not mounted)

RMAN>

RMAN>

RMAN> duplicate target database to DEVDB
2> ;

Starting Duplicate Db at 09-MAR-13
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=151 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 03/09/2013 16:14:02
RMAN-05520: database name mismatch, auxiliary instance has ORADB, command specified DEVDB


My primary db pfile has

*.db_name='ORADB'
*.db_unique_name='ORADB'

My standby db has

*.db_name='ORADB'
*.db_unique_name='DEVDB'

Regards,
007

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 6 2013
Added on Mar 9 2013
3 comments
3,250 views