on 02-22-2013 4:35 AM
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>
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...
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.