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!

error on duplicate database

User_GARL8Nov 10 2016 — edited Nov 10 2016

I'm trying to duplicate a database (11.2.0.3) from an active database, the create controlfile failed because there was a reference to a diskgroup that did not exist, so I modified the create controlfile command to reference the correct diskgroup and added all of the copied datafiles, but now when I execute the create controlfile command I get these errors:

CREATE CONTROLFILE REUSE SET DATABASE "XXXXXXXX" RESETLOGS ARCHIVELOG

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01159: file is not from same database as previous files - wrong database id

ORA-01110: data file 1: '+BOFA_DATA/xxxxxxxx/datafile/SYSTEM.441.927510389'

Anyone have any suggestions for me?

Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 8 2016

Added on Nov 10 2016

#general-database-discussions

3 comments

619 views