Monday, October 08, 2007

Execute OS command in RMAN

Here are the examples, the key is to use single quotation mark:

RMAN> host 'ls -l';

total 12
-rw-r--r-- 1 Denis None 801 Oct 2 15:24 README
-rw-r--r-- 1 Denis None 176 Sep 23 20:45 flsharea_chk.sql
-rw-r--r-- 1 Denis None 64 Sep 23 13:32 lvl_0_bkup.cmd
-rw-r--r-- 1 Denis None 37 Sep 23 13:42 lvl_0_bkup_nocomp.cmd
-rw-r--r-- 1 Denis None 64 Sep 23 20:02 lvl_1_bkup.cmd
-rwxr-xr-x 1 Denis None 1704 Oct 2 15:14 sqlnet.log
host command complete

RMAN> host 'pwd';

/cygdrive/e/Denis_Files/ORACLE/Practise_Oracle/flash_recv_area_rman10g
host command complete

1 comment:

Raghu Valusa said...

Thanks Denis for the details.

I am currently working on my RMAN blogpost, and had to execute few OS commands from RMAN prompt.

I tried with ! without '' quotes for OS command and forgot to try with host.

Thanks Again