sql statements from rman prompt

One of the major advantage of rman utility is we can issue sql commands also from rman prompt.
As it is required for us from rman prompt as we may want to switch a logfile or archive all non archived logfiles or take a tablespace offline/online etc.
So, it is a major advantage to do all this things from rman only. NO need of opening another sql session for this.

Note: though we can issue almost all the sql commands from rman , but any sql commands will not return anything to the rman prompt. Means , select statements will not echo anything to rman prompt.

so, let us check the exmaples:

1) type "SQL" then followed by sql statement inside single quotes followed by ";"

RMAN> SQL 'alter system archive log current';

output
sql statement: alter system archive log current

with that if you issue any wrong sql statement , you will receive an error here.

2) let us check a select statement
RMAN> sql 'select * from v$database';

output
sql statement: select * from v$database

As you can see here, the statement has executed but result has not been echoed to rman prompt

3) we can issue sql command from run block also . (same way)

4) if you are using sinegle quotes in your sql statement then follow the following way:

RMAN> SQL "create tablespace ershad
datafile ' ' c:\database\datafile\test01.dbf ' '
size 10m";

That is the entire statement should be inside double quotes (") and the single quote phase should be inside another single quote.

5) STILL MORE ..............................

you can execute pl/sql blocks also in the same format in rman prompt.

sql ' begin ...... .........; .........; end; ' ;

Hope this will help you out.

Thanks ,
have a nice day

If you do not hope, you will not find what is beyond your hopes.
St. Clement of Alexandra