Oracle错误小记:重建controlfiles错误

Oracle错误小记:重建controlfiles错误

执行创建控制文件脚本的时候报如下错误：

SQL> @/orac/controlfile.sql

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

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

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

and to leave enter EXIT.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

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

and to leave enter EXIT.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

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

and to leave enter EXIT.

SP2-0734: unknown command beginning "'/orac/ora..." - rest of line ignored.

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

  1  CREATE CONTROLFILE REUSE DATABASE "JASON" NORESETLOGS  ARCHIVELOG

  2      MAXLOGFILES 16

  3      MAXLOGMEMBERS 3

  4      MAXDATAFILES 100

  5      MAXINSTANCES 8

  6      MAXLOGHISTORY 292

  7  LOGFILE

  8    GROUP 1 '/orac/oradata/jason/redo01.log'  SIZE 50M,

  9    GROUP 2 '/orac/oradata/jason/redo02.log'  SIZE 50M,

 10    GROUP 3 '/orac/oradata/jason/redo03.log'  SIZE 50M

 11* -- STANDBY LOGFILE、

只需要执行如下语句可以解决

SQL> set sqlbl on

关于sqlbl参数解释如下（来自官方），是因为我们的SQL脚本中存在空白行，因此在执行脚本时会报错。

SET SQLBL[ANKLINES] {ON | OFF}

SET SQLBLANKLINES is not supported in iSQL*Plus

Controls whether SQL*Plus puts blank lines within a SQL command or script. ON interprets blank lines and new lines as part of a SQL command or script. OFF, the default value, does not allow blank lines or new lines in a SQL command or script or script.

Enter the BLOCKTERMINATOR to stop SQL command entry without running the SQL command. Enter the SQLTERMINATOR character to stop SQL command entry and run the SQL statement