Skip to Main Content

Oracle Database Discussions

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!

ORA-01504: database name 'DEV1' does not match parameter db_name 'PROD1'

767356Feb 1 2011 — edited Feb 3 2011
Hi, All -

This is my first time cloning a database. The recovery finished but gave me the following error message. All the parameters in the pfile are set to "DEV1". I believe that the parameter db_name 'PROD1' exists in the control file and causing this error. The control file is under ASM.

How can I change the parameter in the control file and bring the 'DEV1' cloned database up? Also, how can I avoid this issue next time I do a clone?

Thanks in advance!


Oracle 10g Release 2 on RHEL5

Database cloning using RMAN Duplicate > ORA-01504: database name 'DEV1' does not match parameter db_name 'PROD1'
ASMCMD> ls
control01.ctl
current.275.729098001
archive log filename=/u001/dbsvr/dev1/1_131706_653848580.dbf recid=59 stamp=741953991
media recovery complete, elapsed time: 00:09:31
*Finished recover at 01-FEB-11*
contents of Memory Script:
{
   shutdown clone;
   startup clone nomount ;
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     725614592 bytes

Fixed Size                     2075592 bytes
Variable Size                448791608 bytes
Database Buffers             268435456 bytes
Redo Buffers                   6311936 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DEV1" RESETLOGS ARCHIVELOG
  MAXLOGFILES     50
  MAXLOGMEMBERS      5
  MAXDATAFILES      100
  MAXINSTANCES     1
  MAXLOGHISTORY     5445
 LOGFILE
  GROUP  1 '+DATA3/dev1/datafile/redo01.log' SIZE 100 M ,
  GROUP  2 '+DATA3/dev1/datafile/redo02.log' SIZE 100 M ,
  GROUP  3 '+DATA3/dev1/datafile/redo03.log' SIZE 100 M
 DATAFILE
  '+DATA3/dev1/datafile/system01.dbf'
 CHARACTER SET WE8ISO8859P1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 02/01/2011 10:30:17
RMAN-06136: ORACLE error from auxiliary database: ORA-01503: CREATE CONTROLFILE failed
ORA-01504: database name 'DEV1' does not match parameter db_name 'PROD1'

RMAN>
RMAN> **end-of-file**

RMAN>
This post has been answered by unknown-698157 on Feb 1 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 3 2011
Added on Feb 1 2011
7 comments
12,242 views