Re: Compress while EXPORT.. but the unix process never dies...

From: Thomas A. Lowery <stlowery_at_yahoo.com>
Date: Wed, 24 Jan 2001 01:00:34 -0500
Message-Id: <10750.127342@fatcity.com>

rm -f mypipe
mknode mypipe p

cat mypipe | gzip -9 - > oracle.dmp.gz&  # start the compression in
                                         # background.
pp=$!                                    # get the process id from
                                         # previously background

... export stuff here ... file=mypipe

echo "$0 status message here, export `date`"

wait $pp                                 # wait until the background
                                         # process is completed.

echo "$0 completed export using compression process $pp `date`" exit

nohup the complete script for disconnected execution.

Tom

On Tue, Jan 23, 2001 at 04:15:40PM -0800, Seley, Linda wrote:
> Our production environment has very similar script which runs every night.
> When I do a ps I see many instances of this script still running, one for
> each day since the last time I went through and manually killed them. I see
> three big differences, we aren't using nohup but I don't think that's our
> problem ;-), our script does the rm at the end instead of the beginning, and
> there is a sleep after the compress command.... Does anyone have any ideas
> on how I can get rid of these lingering processes?
>
>
> -----Original Message-----
> Sent: Tuesday, January 23, 2001 6:51 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Arul,
>
> just update the table names and run it in the $ prompt.
> #!/usr/bin/ksh
> rm -f /tmp/regress_pipe
> /usr/sbin/mknod /tmp/regress_pipe p
> nohup compress < /tmp/regress_pipe > /tmp/regress.dmp.Z &
> exp / file=/tmp/regress_pipe tables=TAB1,TAB2 buffer=100000 compress=n
> consistent=y log=exp-regress.log
>
> Baskar
>
> -----Original Message-----
> Sent: 23 January 2001 12:01
> To: Multiple recipients of list ORACLE-L
>
>
>
> I would like to know how to take " Compressed Export of Oracle db in
> UNIX ".

-- 
Thomas A. Lowery	stlowery_at_yahoo.com
http://tlowery.hypermart.net

_________________________________________________________
Do You Yahoo!?

Received on Wed Jan 24 2001 - 00:00:34 CST