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-00571: =========================================================== --下面的SQL语句被成功执行 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{ sql statement: begin dbms_lock.sleep(3); end; RMAN> run { sql statement: drop tablespace ts1 including contents and datafiles RMAN> shutdown immediate; database closed |
f、切换到系统提示符下
RMAN> host; robin@SZDB:~> exit RMAN> |