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!

Move database problem

222529Apr 19 2006 — edited Apr 20 2006
Hi.

I am trying to make a copy of db from a production server to development server.

I created a new db on development server, stopped production server and copied oracle data files from production server to development server.

After that, I tried to recreate control file on development server, using data files I had copied from production server. It did not work.

production instance name is CDCWEB and development instance name is CDCWEBD

Creation of control file generated following message:

ORA-01503: CREATE CONTROLFILE failed
ORA-01161: database name CDCWEB in file header does not match given name of CDCWEBD
ORA-01110: data file 1: 'O:\restprod\SYSTEM01.DBF'



what went wrong?

thanks in advance.

Alex
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2006
Added on Apr 19 2006
4 comments
161 views