Oracle错误小记:重建controlfiles错误

执行创建控制文件脚本的时候报如下错误：SQL> @/orac/controlfile.sqlSP2-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 HELPand 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 HELPand 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 HELPand 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*PlusControls 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更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12Web系统从Oracle迁移至MySQLLinux下使用PHP远程连接Oracle相关资讯 Oracle错误

cannot set user id: Resource （09/01/2014 20:07:20）
Oracle错误1406，提取的列值被截断（02/18/2014 09:38:12）

Oracle的PLS-00231 错误分析（04/19/2014 16:49:28）
安装Linux X86-64的Oracle10201出（01/19/2014 10:46:22）

本文评论查看全部评论（0）