Move database problem
222529Apr 19 2006 — edited Apr 20 2006Hi.
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