cancel
Showing results for 
Search instead for 
Did you mean: 

Error while creating control file

Former Member
0 Kudos

I need to recreate a new control file with backup control file (i have a backup of control file .txt mode) when i run control.sql file it giving me error

here there is no change of database name,.all control files are corrupted thats why i need to recreate a control file.

can any one pls help me regarding this

thanks in advance

control.sql


STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS  NOARCHIVELOG

    MAXLOGFILES 255

    MAXLOGMEMBERS 3

    MAXDATAFILES 254

    MAXINSTANCES 50

    MAXLOGHISTORY 1168

LOGFILE

  GROUP 1 (

    'C:\ORACLE\DEV\ORIGLOGA\LOG_G11M1.DBF',

    'C:\ORACLE\DEV\MIRRLOGA\LOG_G11M2.DBF'

  ) SIZE 50M,

  GROUP 2 (

    'C:\ORACLE\DEV\ORIGLOGB\LOG_G12M1.DBF',

    'C:\ORACLE\DEV\MIRRLOGB\LOG_G12M2.DBF'

  ) SIZE 50M,

  GROUP 3 (

    'C:\ORACLE\DEV\ORIGLOGA\LOG_G13M1.DBF',

    'C:\ORACLE\DEV\MIRRLOGA\LOG_G13M2.DBF'

  ) SIZE 50M,

  GROUP 4 (

    'C:\ORACLE\DEV\ORIGLOGB\LOG_G14M1.DBF',

    'C:\ORACLE\DEV\MIRRLOGB\LOG_G14M2.DBF'

  ) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

  'C:\ORACLE\DEV\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

  'C:\ORACLE\DEV\SAPDATA3\UNDO_1\UNDO.DATA1',

  'C:\ORACLE\DEV\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

  'C:\ORACLE\DEV\SAPDATA1\SR3_1\SR3.DATA1',

  'C:\ORACLE\DEV\SAPDATA1\SR3_2\SR3.DATA2',

  'C:\ORACLE\DEV\SAPDATA1\SR3_3\SR3.DATA3',

  'C:\ORACLE\DEV\SAPDATA1\SR3_4\SR3.DATA4',

  'C:\ORACLE\DEV\SAPDATA1\SR3_5\SR3.DATA5',

  'C:\ORACLE\DEV\SAPDATA2\SR3_6\SR3.DATA6',

  'C:\ORACLE\DEV\SAPDATA2\SR3_7\SR3.DATA7',

  'C:\ORACLE\DEV\SAPDATA2\SR3_8\SR3.DATA8',

  'C:\ORACLE\DEV\SAPDATA2\SR3_9\SR3.DATA9',

  'C:\ORACLE\DEV\SAPDATA2\SR3_10\SR3.DATA10',

  'C:\ORACLE\DEV\SAPDATA3\SR3_11\SR3.DATA11',

  'C:\ORACLE\DEV\SAPDATA3\SR3_12\SR3.DATA12',

  'C:\ORACLE\DEV\SAPDATA3\SR3_13\SR3.DATA13',

  'C:\ORACLE\DEV\SAPDATA3\SR3_14\SR3.DATA14',

  'C:\ORACLE\DEV\SAPDATA3\SR3_15\SR3.DATA15',

  'C:\ORACLE\DEV\SAPDATA4\SR3_16\SR3.DATA16',

  'C:\ORACLE\DEV\SAPDATA4\SR3_17\SR3.DATA17',

  'C:\ORACLE\DEV\SAPDATA4\SR3_18\SR3.DATA18',

  'C:\ORACLE\DEV\SAPDATA4\SR3_19\SR3.DATA19',

  'C:\ORACLE\DEV\SAPDATA4\SR3_20\SR3.DATA20',

  'C:\ORACLE\DEV\SAPDATA1\SR3700_1\SR3700.DATA1',

  'C:\ORACLE\DEV\SAPDATA1\SR3700_2\SR3700.DATA2',

  'C:\ORACLE\DEV\SAPDATA1\SR3700_3\SR3700.DATA3',

  'C:\ORACLE\DEV\SAPDATA1\SR3700_4\SR3700.DATA4',

  'C:\ORACLE\DEV\SAPDATA2\SR3700_5\SR3700.DATA5',

  'C:\ORACLE\DEV\SAPDATA2\SR3700_6\SR3700.DATA6',

  'C:\ORACLE\DEV\SAPDATA2\SR3700_7\SR3700.DATA7',

  'C:\ORACLE\DEV\SAPDATA2\SR3700_8\SR3700.DATA8',

  'C:\ORACLE\DEV\SAPDATA3\SR3700_9\SR3700.DATA9',

  'C:\ORACLE\DEV\SAPDATA3\SR3700_10\SR3700.DATA10',

  'C:\ORACLE\DEV\SAPDATA3\SR3700_11\SR3700.DATA11',

  'C:\ORACLE\DEV\SAPDATA3\SR3700_12\SR3700.DATA12',

  'C:\ORACLE\DEV\SAPDATA4\SR3700_13\SR3700.DATA13',

  'C:\ORACLE\DEV\SAPDATA4\SR3700_14\SR3700.DATA14',

  'C:\ORACLE\DEV\SAPDATA4\SR3700_15\SR3700.DATA15',

  'C:\ORACLE\DEV\SAPDATA4\SR3700_16\SR3700.DATA16',

  'C:\ORACLE\DEV\SAPDATA1\SR3USR_1\SR3USR.DATA1'

CHARACTER SET UTF8

;

SQL> @C:\oracle\DEV\sapbackup\control.sql

ORACLE instance started.

Total System Global Area  356515840 bytes

Fixed Size                  1289448 bytes

Variable Size             188744472 bytes

Database Buffers          163577856 bytes

Redo Buffers                2904064 bytes

SP2-0042: unknown command "DATAFILE" - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0044: For a list of known commands enter HELP

and to leave enter EXIT.

SP2-0734: unknown command beginning "'C:\ORACLE..." - rest of line ignored.

SP2-0734: unknown command beginning "CHARACTER ..." - rest of line ignored.

  1  CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS  NOARCHIVELOG

  2      MAXLOGFILES 255

  3      MAXLOGMEMBERS 3

  4      MAXDATAFILES 254

  5      MAXINSTANCES 50

  6      MAXLOGHISTORY 1168

  7  LOGFILE

  8    GROUP 1 (

  9      'C:\ORACLE\DEV\ORIGLOGA\LOG_G11M1.DBF',

10      'C:\ORACLE\DEV\MIRRLOGA\LOG_G11M2.DBF'

11    ) SIZE 50M,

12    GROUP 2 (

13      'C:\ORACLE\DEV\ORIGLOGB\LOG_G12M1.DBF',

14      'C:\ORACLE\DEV\MIRRLOGB\LOG_G12M2.DBF'

15    ) SIZE 50M,

16    GROUP 3 (

17      'C:\ORACLE\DEV\ORIGLOGA\LOG_G13M1.DBF',

18      'C:\ORACLE\DEV\MIRRLOGA\LOG_G13M2.DBF'

19    ) SIZE 50M,

20    GROUP 4 (

21      'C:\ORACLE\DEV\ORIGLOGB\LOG_G14M1.DBF',

22      'C:\ORACLE\DEV\MIRRLOGB\LOG_G14M2.DBF'

23    ) SIZE 50M

24* -- STANDBY LOGFILE

SQL>

Accepted Solutions (1)

Accepted Solutions (1)

former_member182034
Active Contributor
0 Kudos

hi navin,

Please remove the highlighted text from conrtol.sql file and re execute.

-- STANDBY LOGFILE

Please have a look at below link for More info...

SP2-0734

Regards,


Former Member
0 Kudos

i executed it after removing -- STANDBY LOGFILE

not worked  it giving  me same error

Former Member
0 Kudos

problem solved

This happened due to blank line before the DATAFILE clause i removed space line as well as  -- STANDBY LOGFILE line

then after controlfile created successfully

former_member182034
Active Contributor
0 Kudos

Dear,

did you remove the space after -- STANDBY LOGFILE

Please also have a look at above link which i mentioned in my previous reply.

regards,

Former Member
0 Kudos

yes problem solved now

thank you

Answers (0)