RMAN-01009: syntax error: found dot 解决方法
今天调试一个RMAN 的备份脚本,这个脚本以前也用过很多次,,并没有什么问题,今天执行时,就是过不去。
操作系统:RedHat 5.8
数据库: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 脚本的语法问题。
如下:
[Oracle@rac1 scripts]$ rman checksyntaxrman.sh
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-005本文来源gao@daima#com搞(%代@#码@网271:===========================================================
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