发新话题
打印

[[[ 求助贴 ]]] 如何在rman备份中加入备份spfile的命令呢.

[[[ 求助贴 ]]] 如何在rman备份中加入备份spfile的命令呢.

sqlplusw可以这样执行
SQL> create pfile='c:\controlfile\init.ora' from spfile;
文件已创建。

到了rman里面

RMAN>run {
2> sql 'create pfile='c:\controlfile\init.ora' from spfile' ;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 06/17/2008 09:31:40
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: c
RMAN-01007: at line 2 column 20 file: standard input
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00579: the following error occurred at 06/17/2008 09:31:40
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-02001: unrecognized punctuation symbol ":"
怎么办呢?

TOP

命令写错了嘛,多了一个单引号嘛===>>2> sql 'create pfile='c:\controlfile\init.ora' from spfile' ;

TOP

没 看 出 区 别 ?

TOP

发新话题