RMAN-01009: syntax error: found “dot” 解决方法

2014-11-24 18:09:59 · 作者: · 浏览: 0

今天调试一个RMAN 的备份脚本,这个脚本以前也用过很多次,并没有什么问题,今天执行时,就是过不去。


数据库:11.2.0.3


错误如下:


RMAN-00571:===========================================================


RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============


RMAN-00571:===========================================================


RMAN-00552: syntax error in command linearguments


RMAN-01009: syntax error:found "dot": expecting one of: "double-quoted-string,identifier, single-quoted-string, "


RMAN-01007: at line 2 column 1 file:command line arguments


这个错误,提示在第二行有问题。


根据MOS 文档[ID427224.1]的说明:


How to check for correct RMAN syntax [ID427224.1]


我们也可以使用rman checksyntax 命令检查RMAN 脚本的语法问题。


如下:



Argument Value Description


-----------------------------------------------------------------------------


target quoted-string connect-string fortarget database


catalog quoted-string connect-string forrecovery catalog


nocatalog none if specified, thenno recovery catalog


cmdfile quoted-string name of inputcommand file


log quoted-string name of outputmessage log file


trace quoted-string name of outputdebugging message log file


append none if specified, logis opened in append mode


debug optional-args activate debugging


msgno none show RMAN-nnnnprefix for all messages


send quoted-string send a command tothe media manager


pipe string building block forpipe names


timeout integer number of secondsto wait for pipe input


checksyntax none check the commandfile for syntax errors


-----------------------------------------------------------------------------


Both single and double quotes (' or ")are accepted for a quoted-string.


Quotes are not required unless the stringcontains embedded white-space.



RMAN-00571:===========================================================


RMAN-00569: =============== ERROR MESSAGESTACK FOLLOWS ===============


RMAN-00571:===========================================================


RMAN-00552: syntax error in command linearguments


RMAN-01009: syntax error: found"rman": expecting one of: "append, auxiliary, catalog,checksyntax, cmdfile, log, msgno, nocatalog, pipe, script, send, target,timeout, using, @, ;"


RMAN-01007: at line 2 column 1 file:command line arguments