????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

????f???л????????????

RMAN> host;

robin@SZDB:~> exit
exit
host command complete

RMAN>