error during creating control file.

[Former Member]

Dear Experts,

                 I have restore online database using differnt SID. Now i am trying 2 create controlfile using below command but i m not able to create.I m getting below error.

CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS  ARCHIVELOG
     MAXLOGFILES 255
     MAXLOGMEMBERS 3
     MAXDATAFILES 254
     MAXINSTANCES 50
     MAXLOGHISTORY 11680
LOGFILE
   GROUP 1 (
     'C:\ORACLE\QAS\ORIGLOGA\LOG_

G11M1.DBF',
     'C:\ORACLE\QAS\MIRRLOGA\LOG_G11M2.DBF'
   ) SIZE 50M,
   GROUP 2 (
     'C:\ORACLE\QAS\ORIGLOGB\LOG_G12M1.DBF',
     'C:\ORACLE\QAS\MIRRLOGB\LOG_G12M2.DBF'
   ) SIZE 50M,
   GROUP 3 (
     'C:\ORACLE\QAS\ORIGLOGA\LOG_G13M1.DBF',
     'C:\ORACLE\QAS\MIRRLOGA\LOG_G13M2.DBF'
   ) SIZE 50M,
   GROUP 4 (
     'C:\ORACLE\QAS\ORIGLOGB\LOG_G14M1.DBF',
     'C:\ORACLE\QAS\MIRRLOGB\LOG_G14M2.DBF'
   ) SIZE 50M
-- STANDBY LOGFILE
DATAFILE
   'C:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',
   'C:\ORACLE\QAS\SAPDATA1\UNDO_1\UNDO.DATA1',
   'C:\ORACLE\QAS\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',
   'C:\ORACLE\QAS\SAPDATA3\SR3_1\SR3.DATA1',
   'C:\ORACLE\QAS\SAPDATA3\SR3_2\SR3.DATA2',
   'C:\ORACLE\QAS\SAPDATA3\SR3_3\SR3.DATA3',
   'C:\ORACLE\QAS\SAPDATA3\SR3_4\SR3.DATA4',
   'C:\ORACLE\QAS\SAPDATA3\SR3_5\SR3.DATA5',
   'C:\ORACLE\QAS\SAPDATA3\SR3_6\SR3.DATA6',
   'C:\ORACLE\QAS\SAPDATA3\SR3_7\SR3.DATA7',
   'C:\ORACLE\QAS\SAPDATA3\SR3_8\SR3.DATA8',
   'C:\ORACLE\QAS\SAPDATA3\SR3_9\SR3.DATA9',
   'C:\ORACLE\QAS\SAPDATA3\SR3_10\SR3.DATA10',
   'C:\ORACLE\QAS\SAPDATA3\SR3_11\SR3.DATA11',
   'C:\ORACLE\QAS\SAPDATA3\SR3_12\SR3.DATA12',
   'C:\ORACLE\QAS\SAPDATA3\SR3_13\SR3.DATA13',
   'C:\ORACLE\QAS\SAPDATA3\SR3_14\SR3.DATA14',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_1\SR3700.DATA1',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_2\SR3700.DATA2',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_3\SR3700.DATA3',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_4\SR3700.DATA4',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_5\SR3700.DATA5',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_6\SR3700.DATA6',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_7\SR3700.DATA7',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_8\SR3700.DATA8',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_9\SR3700.DATA9',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_10\SR3700.DATA10',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_11\SR3700.DATA11',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_12\SR3700.DATA12',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_13\SR3700.DATA13',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_14\SR3700.DATA14',
   'C:\ORACLE\QAS\SAPDATA2\SR3700_15\SR3700.DATA15',
   'C:\ORACLE\QAS\SAPDATA4\SR3USR_1\SR3USR.DATA1'
CHARACTER SET UTF8
;

CREATE CONTROLFILE SET DATABASE "QAS" RESETLOGS  ARCHIVELOG
*
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-00200: control file could not be created
ORA-00202: control file: 'C:\ORACLE\QAS\ORIGLOGA\CNTRL\

CNTRLQAS.DBF'
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists

Please do needful. Your valuable reply will be highly appreciable

Regards,

Sahil.

[Reagan · Accepted solution]

Hello

Go to the control file locations (Check pfile or spfile) and delete all the existing control files and then execute the script.

Regards

RB

[Former Member · Accepted solution]

Dear deepak /Reagan,

                   I have delete old file then applied command.control file created. Now I m facing problem during applying log.

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

AUTO

ORA-00308: cannot open archived log

'C:\ORACLE\QAS\ORAARCH\QASARCHARC33413_0733502573.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

ORA-00308: cannot open archived log

'C:\ORACLE\QAS\ORAARCH\QASARCHARC33413_0733502573.001'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01195: online backup of file 1 needs more recovery to be consistent

ORA-01110: data file 1: 'C:\ORACLE\QAS\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

Please do needful

[former_member184473 · Accepted solution]

Hello Sahil,

Check note 546006 point 3 to verify if you are able to access the directory that contains the file.

Regards,

Eduardo Rezende

[Reagan · Accepted solution]

Hello

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00308: cannot open archived log
'C:\ORACLE\QAS\ORAARCH\QASARCHARC33413_0733502573.001'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

I believe you are trying to apply the archived logs of the source system. In that case you cannot specify AUTO here when you have just created the control files with the new SID which is QAS.

You need to specify the archived log file manually. that is instead of AUTO you will specify the archived log file with the complete location.

C:\ORACLE\QAS\ORAARCH\QASARCHARC33413_0733502573.001

Here what you need to change is the SID of the archived log as the archived logs from the source system will have a different naming conventions.

Eg:

From: QASARCHARC33413_0733502573.001

To: PASARCHARC33413_0733502573.001

So you probably will need to adapt the full string like this to apply.

C:\ORACLE\QAS\ORAARCH\PASARCHARC33413_0733502573.001

Regards

RB

[former_member188883 · Accepted solution]

Hi Sahil,

Please update the initSID.ora file for parameter log_archive_format to match your archive file nomenclature. Probably if you have SID specified in this paramter , change the SID to QAS instead to PRA & save the file.

Shutdown database

execute command create spfile from pfile;

startup database in mount state

execute recovery command.

Hope this helps.

Regards,

Deepak Kori

[former_member188883]

Hi Sahil,

Based on the error message

CNTRLQAS.DBF'
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already

Please rename all the control files existing in your system before re-creating new control files.

Hope this helps.

Regards,

Deepak Kori

[Former Member]

Dear Deepak,

            Thanks a lot for your reply,I have try above from

C:\ORACLE\QAS\ORIGLOGA\CNTRL\

CNTRLQAS.DBF

But same problem.

Regards

Sahil