Hi,
on 11.2.0.4 on Win 2008 server,
I try to execute a sql statement In RMAN but it fails:
RMAN> sql "create pfile="C:\BACKUP\cold\pfile.ora" from spfile;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: ";"
RMAN-01008: the bad identifier was: C
RMAN-01007: at line 1 column 20 file: standard input
RMAN> sql "create pfile=''C:\BACKUP\cold\pfile.ora'' from spfile;
2> ;
3> "
4> exit
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "exit": expecting one of: ";"
RMAN-01007: at line 4 column 1 file: standard input
RMAN> sql "create pfile='C:\BACKUP\cold\pfile.ora' from spfile;
2> ;
3> exit
4> ;
5> ;;
6> ^C
C:\backup\scripts>rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Mon Mar 20 08:46:22 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1422423220)
RMAN> sql "create pfile='C:\BACKUP\cold\pfile.ora' from spfile;"
2> ;
using target database control file instead of recovery catalog
sql statement: create pfile='C:\BACKUP\cold\pfile.ora' from spfile;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 03/20/2017 09:25:50
RMAN-10015: error compiling PL/SQL program
RMAN> sql "create pfile='C:\BACKUP\cold\initORCL.ora' from spfile;";
sql statement: create pfile='C:\BACKUP\cold\initORCL.ora' from spfile;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of sql command on default channel at 03/20/2017 09:31:48
RMAN-10015: error compiling PL/SQL program
What is the right syntax ?
Thank you.