Oracle错误小记:重建controlfiles错误

执行创建控制文件脚本的时候报如下错误： SQLgt; @/orac/controlfile.sql SP2-0042: unknown command DATAFILE - rest of lin

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

SQL> @/orac/controlfile.sql

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

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

1.1.9PbootCMS

PbootCMS是一款高效、简洁、强悍的开源PHP企业网站开发建设管理系统。 PbootCMS 1.1.9 更新日志：2018-08-17 1.系统优化及安全修复(重要)； 2.修复自定义表单Mysql时添加失败问题； 3.修复后台模板一些小错误； 4.修复影响缓存效果的一些问题； 5.新增后台在线更新功能；

538

查看详情

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