Re: Help wanted - How to export to tape directly by using cron under UNIX(NCR) with ORACLE V6 ?

yyin_at_mcs.kent.edu (Yu Yin) writes:

>Hi netters,
 

>I'm using Oracle V6 based on NCR Unix, and I want to backup the system by
>cron nightly. As part of it, I want to export Oracle database to tape
>directly. When I called Oracle Support, they let me put the device name
>after the equal sign of file, which is 'file=/dev/rmt/c0t1d0s0' at the
>command line after exp user/pass. And I did. But it still asked the volume
>size, which is 'volume size (<ret> for no restriction)>'. This means I still
>cannot export it automatically.
 

>QUESTION: Is there any way to have the <return>for Volume Size answered
>automatically, or as a parameter that I can feed to the procedure in a shell
>script.
I am not working with Oracle anymore but the answers i still can give ;-)

1. For export directly to tape we always had to ln dev/rmt/X to dev/rmt/X.dmp
2. You don't want to use sytem/passwd in the command line because everyone can see the command line with ps.
3. For Answering questions i used to use a here shell like

export $OPTIONS <<!
sys/change_on_install
$VOLUME_SIZE
....
....
!

Jan.

-- 
Jan Wortelboer,  University of Amsterdam
                 Computer Science Department  Email: janw_at_fwi.uva.nl
Unix             Kruislaan 403 Kamer F003     Phone: +31 20 525 7501
systems manager  1098 SJ AMSTERDAM            Fax  : +31 20 525 7490