RMAN 提示符下执行SQL语句

作者：网络转载发布时间：[ 2013/6/8 10:18:44 ] 推荐标签：

　　b、执行SQL查询语句，如下，没有任何结果输出

RMAN> sql 'select sysdate from dual';

sql statement: select sysdate from dual

RMAN> sql ' select * from v$database ';

sql statement: select * from v$database

　　c、执行带有路径及文件名的SQL语句

--下面的执行那个中没有使用双引号开头以及双单引号括住路径，收到错误提示
RMAN> sql ' create tablespace ts1 datafile '/u02/database/GOBO1/oradata/ts1.dbf' size 10m ';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01006: error signalled during parse
RMAN-02001: unrecognized punctuation symbol "/"

--下面的SQL语句被成功执行
RMAN> sql "create tablespace ts1 datafile ''/u02/database/GOBO1/oradata/ts1.dbf'' size 10m";

sql statement: create tablespace ts1 datafile ''/u02/database/GOBO1/oradata/ts1.dbf'' size 10m

　　d、执行PL/SQL块

RMAN> sql ' begin dbms_lock.sleep(3); end;';

sql statement: begin dbms_lock.sleep(3); end;

　　e、rman块命令方式执行PL/SQL块

RMAN> run{
2> sql ' begin dbms_lock.sleep(3); end; ';
3> }

sql statement: begin dbms_lock.sleep(3); end;

RMAN> run {
2> sql ' drop tablespace ts1 including contents and datafiles ';
3> }

sql statement: drop tablespace ts1 including contents and datafiles

RMAN> shutdown immediate;

database closed
database dismounted
Oracle instance shut down