ORA01503 CREATE CONTROLFILE failed

[Former Member]

Hello All,

I am trying to refresh the Quality server with production.after i have copied the datafile and edited the control file.

while running the control.sql script i am getting the following error.

ORA01503 CREATE CONTROLFILE failed

ORA0116 database name TEST in file header does not match given name of PROD

ORA01110 data file

can Some advise me on this

Thanks and regards

Kiran Deverla

[Former Member]

I have changed the directory paths in the control file

[Former Member]

Please use the below command in your control file creation script.

CREATE CONTROLFILE set DATABASE "newdbname" RESETLOGS ...

or else send us the control file creation script. The control file script needs to be modified.

Thanks,

Sourav Misra

[Former Member]

Hi

not required reset option.

Create controlfile - http://www.ss64.com/ora/controlfile_c.html

after use re-created controlfile give alert log contents

SurendraJain

[Former Member]

Hi,

Can you please check your control.sql and confirm accordingly.

It appears that the control.sql has the following command at the top:

CREATE CONTROLFILE REUSE DATABASE "PROD" RESETLOGS ARCHIVELOG

In order to create a new control file for the target database you must use SET in the CREATE CONTROLFILE command. The SET command initiates the change in the database name.

regards,

Subhajit.

[Former Member]

Kiran,

Check below links. It may help you.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_5003.htm#SQLRF01203

Thanks

Sushil

[Former Member]

Hello kiran,

can u send me the create controlfile script..?

[stefan_koehler]

Hello Kiran,

can you please post the parameter DB_NAME from the init<SID>.ora or SPFILE?

Also please post the first line of your "control.sql" script.

I think that you didn't replace the "REUSE" clause with the "SET" clause.

Regards

Stefan