cancel
Showing results for 
Search instead for 
Did you mean: 

ORA-01503: CREATE CONTROLFILE failed

Former Member
0 Kudos

Dear All,

I want to restore PRD backup on DEV server but nwo facing below error: Please help me to rseolve thsi ASAP....reward points guaranteed

1. Restored PRD backup on DEV server

2. generated control.sql

3. executing control file ....but in ERROR

SQL>ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

SQL> @/1/CONTROL.SQL

ORACLE instance started.

Total System Global Area 6381083200 bytes

Fixed Size 735808 bytes

Variable Size 3288334336 bytes

Database Buffers 3090677760 bytes

Redo Buffers 1335296 bytes

CREATE CONTROLFILE REUSE DATABASE "DEV" NORESETLOGS ARCHIVELOG

ERROR at line 1:

ORA-01503: CREATE CONTROLFILE failed

ORA-01161: database name PRD in file header does not match given name of DEV

ORA-01110: data file 1: '/oracle/DEV/sapdata1/system_1/system.data1'

*********CONTENTS OF CONTROL.SQL**********************

root@bssldev1 # pwd

/oracle/DEV/saptrace/usertrace

root@bssldev1 # ls -l

total 8

-rw-rr 1 oradev dba 4060 Aug 4 19:09 control.sql

root@bssldev1 # more control.sql

STARTUP NOMOUNT

CREATE CONTROLFILE REUSE DATABASE "DEV" NORESETLOGS ARCHIVELOG

-- SET STANDBY TO MAXIMIZE PERFORMANCE

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 254

MAXINSTANCES 50

MAXLOGHISTORY 3176

LOGFILE

GROUP 1 (

'/oracle/DEV/origlogA/log_g11m1.dbf',

'/oracle/DEV/mirrlogA/log_g11m2.dbf'

) SIZE 50M,

GROUP 2 (

'/oracle/DEV/origlogB/log_g12m1.dbf',

'/oracle/DEV/mirrlogB/log_g12m2.dbf'

) SIZE 50M,

GROUP 3 (

'/oracle/DEV/origlogA/log_g13m1.dbf',

'/oracle/DEV/mirrlogA/log_g13m2.dbf'

) SIZE 50M,

GROUP 4 (

'/oracle/DEV/origlogB/log_g14m1.dbf',

'/oracle/DEV/mirrlogB/log_g14m2.dbf'

) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

'/oracle/DEV/sapdata1/system_1/system.data1',

'/oracle/DEV/sapdata3/prd_1/prd.data1',

'/oracle/DEV/sapdata3/prd_2/prd.data2',

'/oracle/DEV/sapdata3/prd_3/prd.data3',

'/oracle/DEV/sapdata3/prd_4/prd.data4',

'/oracle/DEV/sapdata4/prd_5/prd.data5',

'/oracle/DEV/sapdata4/prd_6/prd.data6',

'/oracle/DEV/sapdata4/prd_7/prd.data7',

'/oracle/DEV/sapdata4/prd_8/prd.data8',

'/oracle/DEV/sapdata4/prd_9/prd.data9',

'/oracle/DEV/sapdata1/prd620_1/prd620.data1',

'/oracle/DEV/sapdata1/prd620_2/prd620.data2',

'/oracle/DEV/sapdata1/prd620_3/prd620.data3',

'/oracle/DEV/sapdata1/prd620_4/prd620.data4',

'/oracle/DEV/sapdata2/prd620_5/prd620.data5',

'/oracle/DEV/sapdata2/prd620_6/prd620.data6',

'/oracle/DEV/sapdata2/prd620_7/prd620.data7',

'/oracle/DEV/sapdata2/prd620_8/prd620.data8',

'/oracle/DEV/sapdata2/prd620_9/prd620.data9',

'/oracle/DEV/sapdata3/prd620_10/prd620.data10',

'/oracle/DEV/sapdata4/prd620_11/prd620.data11',

'/oracle/DEV/sapdata1/prdusr_1/prdusr.data1',

'/oracle/DEV/sapdata2/roll_1/roll.data1',

'/oracle/DEV/sapdata1/system_2/system.data2',

'/oracle/DEV/sapdata4/prd_10/prd.data10',

'/oracle/DEV/sapdata4/prd_11/prd.data11',

'/oracle/DEV/sapdata4/prd_12/prd.data12',

'/oracle/DEV/sapdata4/prd_13/prd.data13',

'/oracle/DEV/sapdata4/prd_14/prd.data14',

'/oracle/DEV/sapdata4/prd_15/prd.data15',

'/oracle/DEV/sapdata4/prd_16/prd.data16',

'/oracle/DEV/sapdata4/prd_17/prd.data17',

'/oracle/DEV/sapdata4/prd_18/prd.data18',

'/oracle/DEV/sapdata4/prd_19/prd.data19',

'/oracle/DEV/sapdata4/prd_20/prd.data20',

'/oracle/DEV/sapdata4/prd_21/prd.data21',

'/oracle/DEV/sapdata4/prd_22/prd.data22',

'/oracle/DEV/sapdata4/prd_23/prd.data23',

'/oracle/DEV/sapdata4/prd_24/prd.data24',

'/oracle/DEV/sapdata4/prd_25/prd.data25',

'/oracle/DEV/sapdata4/prd_26/prd.data26',

'/oracle/DEV/sapdata4/prd_27/prd.data27',

'/oracle/DEV/sapdata4/prd_28/prd.data28',

'/oracle/DEV/sapdata4/prd_29/prd.data29',

'/oracle/DEV/sapdata4/prd_30/prd.data30',

'/oracle/DEV/sapdata4/prd_31/prd.data31',

'/oracle/DEV/sapdata4/prd_32/prd.data32',

'/oracle/DEV/sapdata4/prd_33/prd.data33',

'/oracle/DEV/sapdata4/prd_34/prd.data34',

'/oracle/DEV/sapdata4/prd_35/prd.data35',

'/oracle/DEV/sapdata4/prd_36/prd.data36',

'/oracle/DEV/sapdata4/prd_37/prd.data37',

'/oracle/DEV/sapdata4/prd_38/prd.data38',

'/oracle/DEV/sapdata4/prd_39/prd.data39',

'/oracle/DEV/sapdata4/prd_40/prd.data40',

'/oracle/DEV/sapdata4/prd_41/prd.data41',

'/oracle/DEV/sapdata4/prd_42/prd.data42',

'/oracle/DEV/sapdata4/prd_43/prd.data43',

'/oracle/DEV/sapdata4/prd_44/prd.data44',

'/oracle/DEV/sapdata2/roll_2/roll.data2',

'/oracle/DEV/sapdata2/roll_3/roll.data3',

'/oracle/DEV/sapdata4/prd_45/prd.data45',

'/oracle/DEV/sapdata4/prd_46/prd.data46',

'/oracle/DEV/sapdata4/prd_47/prd.data47',

'/oracle/DEV/sapdata2/roll_4/roll.data4',

'/oracle/DEV/sapdata4/prd_48/prd.data48',

'/oracle/DEV/sapdata4/prd_49/prd.data49',

'/oracle/DEV/sapdata4/prd_50/prd.data50',

'/oracle/DEV/sapdata4/prd_51/prd.data51',

'/oracle/DEV/sapdata4/prd_52/prd.data52',

'/oracle/DEV/sapdata4/prd_53/prd.data53',

'/oracle/DEV/sapdata4/prd_54/prd.data54',

'/oracle/DEV/sapdata4/prd_55/prd.data55',

'/oracle/DEV/sapdata4/prd_56/prd.data56',

'/oracle/DEV/sapdata2/roll_5/roll.data5'

CHARACTER SET WE8DEC

;

root@bssldev1 #

*********CONTENTS OF CONTROL.SQL**********************

Please help...

Regards & Thanks,

Ankita

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

change control.sql:

CREATE CONTROLFILE REUSE <b>SET</b> DATABASE "DEV" NORESETLOGS ARCHIVELOG

then try again.

Answers (1)

Answers (1)

markus_doehr2
Active Contributor
0 Kudos

Did you delete the old control file?

Do you execute that as root?

--

Markus