In article <37cab7fe.12026948_at_news.earthlink.net>,
andreyNSPAM_at_bookexchange.net (NetComrade) wrote:
> Also you might want to take out gzip if your server is very CPU
> hungry, since it can take up a considerable amount of CPU usage
>
> On Mon, 30 Aug 1999 16:48:59 GMT, andreyNSPAM_at_bookexchange.net
> (NetComrade) wrote:
>
> >One of the Oracle/Unix Gurus has sent me a script a while ago, which
I
> >modified a bit and posting it right now. It's using named pipes (man
> >mknod) and split (man split) and obviously gzip. Good luck.
> >
> >#!/bin/csh -vx
> >
> >setenv ORACLE_BASE=/export/apps/oracle
> >setenv ORACLE_HOME=/export/apps/oracle/734
> >setenv ORACLE_SID=DBLP2
> >
> >setenv UID sys/password
> >setenv FN $ORACLE_BASE/export/`uname -n`_export.`date +%m_%d_%y`.dmp
> >setenv PIPE /tmp/exp_tmp.dmp
> >setenv MAXSIZE 2000m
> >setenv EXPORT_WHAT 'full=y direct=y feedback=100000'
> >setenv EXPORT_LOG=$ORACLE_BASE/export/`uname -n`_export.`date
> >+%m_%d_%y`.log
> >
> >mknod $PIPE p
> >
> >date > EXPORT_LOG
> >( gzip < $PIPE ) | split -b $MAXSIZE - $FN. &
> >exp userid=$UID file=$PIPE $EXPORT_WHAT >>& EXPORT_LOG
> >date >> EXPORT_LOG
> >rm $PIPE
>
> ---------------
> Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 373-5417
> AOL: NetComrade ICQ: 11340726 remove NSPAM to email
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Mon Aug 30 1999 - 13:54:55 CDT
