Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Exports > 2GB -- need scripts

Re: Exports > 2GB -- need scripts

From: Tom Pall <tom_at_cdproc.com>
Date: Mon, 20 Nov 2000 15:13:05 -0600
Message-Id: <10686.122547@fatcity.com> 





Cool.



You should be getting lots of pages at



8774472907_at_skytel.com, Arun.






> Use the below said script in your shell script it will export files greater 

> than 2 gb.

> 

> echo "FULL EXPORT OF BLINK ON FOX HAS STARTED" |mailx 8774472907_at_skytel.com

> . /export/home/oracle/aruns_data/oracle_env

> ORACLE_SID=BLINK


> export ORACLE_SID

> cd $EXPORT_DIR

> #

> #  set maximum file size for each chunk of the export file

> #

> MAXFILESIZE=2000m

> export MAXFILESIZE

> #

> # create filenames for the parts of the backup... for now let's go to 3

> #

> FILENAME1=$EXPORT_DIR/fullexport/backup1_$ORACLE_SID.dmp

> FILENAME2=$EXPORT_DIR/fullexport/backup2_$ORACLE_SID.dmp

> FILENAME3=$EXPORT_DIR/fullexport/backup3_$ORACLE_SID.dmp

> LOGFILE=$LOGS/backup_$ORACLE_SID.log

> #

> #

> #  create the pipes

> #

> mkfifo exportpipeaa

> mkfifo exportpipeab

> mkfifo exportpipeac

> mkfifo wrkpipe

> umask 000

> #

> # start the readers from the pipes to create the export files

> #

> dd if=exportpipeaa of=$FILENAME1 &

> dd if=exportpipeab of=$FILENAME2 &

> dd if=exportpipeac of=$FILENAME3 &

> #

> # start the reader from the wrkpipe to compress and split the export

> #

> dd if=wrkpipe|compress|split -b $MAXFILESIZE - exportpipe &

> #

> # start the export for real

> #

> exp "/" file=wrkpipe full=y compress=n buffer=4096000 LOG=$LOGFILE

> #

> # clean up after ourselves

> #

> rm exportpipeaa exportpipeab exportpipeac wrkpipe

> #

> #  if you haven't used all the pipes, the dd may still linger on

> #    make sure to REALLY clean up

> #

> ps -ef|grep exportpipe|grep -vi grep|awk '{printf ("kill -9 %d; 

> \n",$2)}'>kill.lst

> chmod u+x kill.lst

> sh kill.lst

> rm kill.lst

> echo "FULL EXPORT OF BLINK ON FOX IS COMPLETE" |mailx 8774472907_at_skytel.com

> -------------------------------

> 

> 

> 

> 

> >From: "Wang, Linda" <lwang_at_messagemedia.com>

> >Reply-To: ORACLE-L_at_fatcity.com

> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

> >Subject: RE: Exports > 2GB -- need scripts

> >Date: Mon, 20 Nov 2000 08:30:28 -0800

> >

> >Compress and split the exported file on the fly looks fine.

> >But when I tried to uncompress and combine those split

> >files on the fly, only the first compressed file was

> >uncompressed.   -Linda

> >

> >-----Original Message-----

> >Sent: Monday, November 20, 2000 3:40 AM

> >To: Multiple recipients of list ORACLE-L

> >

> >

> >compress < exp_pipe | split -b2048m - <name> &

> >

> > > ----------

> > > From: Allan Davis Sahadeo[SMTP:asahadeo_at_neal-and-massy.com]

> > > Reply To: ORACLE-L_at_fatcity.com

> > > Sent: Sunday, November 19, 2000 22:10

> > > To: Multiple recipients of list ORACLE-L

> > > Subject: Re: Exports > 2GB -- need scripts

> > >

> > > Thanks Winnie,

> > > But is there a way to combine both compressing and splitting? This 

> >script

> > > only splits but doesn't compress.Is there a way to do both on the fly ?

> > > Allan.

> > > ----- Original Message -----

> > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>

> > > Sent: Friday, November 17, 2000 6:30 PM

> > >

> > >

> > > >

> > > >

> > > > This is how you spilt the files if the compresses form of export > 2GB

> > > >

> > > > for export:

> > > >

> > > > mknod /tmp/exp_pipe p

> > > > cd <to the directory where you want to put the split file>

> > > > split -b2047m < /tmp/exp_pipe &

> > > > exp user/pwd file=/tmp/exp_pipe <other options>

> > > >

> > > > Winnie

> > > >

> > > >

> > > >

> > > >

> > > >

> > > > "Rajendran, Srini" <SRAJENDRAN_at_nlfs.com>@fatcity.com on 11/17/2000

> > > 01:54:40

> > > > PM

> > > >

> > > > Please respond to ORACLE-L_at_fatcity.com

> > > >

> > > > Sent by:  root_at_fatcity.com

> > > >

> > > >

> > > > To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

> > > > cc:

> > > >

> > > >

> > > >

> > > > if you are running oracle 8i, you can specify multiple files as dump

> > > > destination.

> > > >

> > > > -----Original Message-----

> > > > Sent: Friday, November 17, 2000 4:23 PM

> > > > To: Multiple recipients of list ORACLE-L

> > > >

> > > >

> > > > I was wondering, if the size of the compressed file did exceed 2 gigs

> > > then

> > > > we would indeed be in a bit of a predicament. Since an export does

> > > compress

> > > > fairly nicely, we may not encounter such a problem. But what if we

> > > did...

> > > > What would we do then ? Do we split our compressed files ? And if so 

> >how

> > > do

> > > > we ?

> > > > Allan.

> > > > ----- Original Message -----

> > > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>

> > > > Sent: Friday, November 17, 2000 4:50 PM

> > > >

> > > >

> > > > Here are the scripts for export and import:

> > > >

> > > > For export:

> > > > mknod t1.dmp p

> > > > compress < t1.dmp> t10.dmp.Z &

> > > > exp us/pw parfile=exp.dat

> > > >

> > > > For Import:

> > > > /etc/mknod t1.dmp p

> > > > dd of=t10.dmp if=t1.dmp &

> > > > imp us/pw  parfile=imp.dat

> > > >

> > > > Ramani

> > > > DBA


> > > >

> > > > >>> <cemail_at_sprintmail.com> 11/17/00 01:25PM >>>

> > > >

> > > > I have a 45GB Oracle 8.0.5 database on HPUX.  I want to be able

> > > > to do nightly exports so that if any of the tables gets "accidentally"

> > > > truncated or whatever, we can restore just the table and not

> > > > have to restore the entire database.

> > > >

> > > > Does anybody have a script that uses the split(?) utility and

> > > > compress so that the export isn't bigger than 2GB?  What about

> > > > importing?  Can just one table be picked out of that large of

> > > > an export if the export is split up and compressed?  Please let

> > > > me know your experience/advice on doing this.

> > > >

> > > > -----

> > > > Sent using MailStart.com ( http://MailStart.Com/welcome.html )

> > > > The FREE way to access your mailbox via any web browser, anywhere!

> > > >

> > > > --

> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > > --

> > > > Author:

> > > >   INET: cemail_at_sprintmail.com

> > > >

> > > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > > San Diego, California        -- Public Internet access / Mailing Lists

> > > > --------------------------------------------------------------------

> > > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > > (or the name of mailing list you want to be removed from).  You may

> > > > also send the HELP command for other information (like subscribing).

> > > >

> > > > --

> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > > --

> > > > Author: Akhil Ramani

> > > >   INET: Akhil.Ramani_at_3cc.co.wayne.mi.us

> > > >

> > > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > > San Diego, California        -- Public Internet access / Mailing Lists

> > > > --------------------------------------------------------------------

> > > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > > (or the name of mailing list you want to be removed from).  You may

> > > > also send the HELP command for other information (like subscribing).

> > > >

> > > > --

> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > > --

> > > > Author: Allan Davis Sahadeo

> > > >   INET: asahadeo_at_neal-and-massy.com

> > > >

> > > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > > San Diego, California        -- Public Internet access / Mailing Lists

> > > > --------------------------------------------------------------------

> > > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > > (or the name of mailing list you want to be removed from).  You may

> > > > also send the HELP command for other information (like subscribing).

> > > >

> > > > --

> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > > --

> > > > Author: Rajendran, Srini

> > > >   INET: SRAJENDRAN_at_nlfs.com

> > > >

> > > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > > San Diego, California        -- Public Internet access / Mailing Lists

> > > > --------------------------------------------------------------------

> > > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > > (or the name of mailing list you want to be removed from).  You may

> > > > also send the HELP command for other information (like subscribing).

> > > >

> > > >

> > > >

> > > > --

> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > > --

> > > > Author:

> > > >   INET: Winnie_Liu_at_infonet.com

> > > >

> > > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > > San Diego, California        -- Public Internet access / Mailing Lists

> > > > --------------------------------------------------------------------

> > > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > > (or the name of mailing list you want to be removed from).  You may

> > > > also send the HELP command for other information (like subscribing).

> > >

> > > --

> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com

> > > --

> > > Author: Allan Davis Sahadeo

> > >   INET: asahadeo_at_neal-and-massy.com

> > >

> > > Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> > > San Diego, California        -- Public Internet access / Mailing Lists

> > > --------------------------------------------------------------------

> > > To REMOVE yourself from this mailing list, send an E-Mail message

> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> > > the message BODY, include a line containing: UNSUB ORACLE-L

> > > (or the name of mailing list you want to be removed from).  You may

> > > also send the HELP command for other information (like subscribing).

> > >

> >--

> >Please see the official ORACLE-L FAQ: http://www.orafaq.com

> >--

> >Author:

> >   INET: ddorr.cs_at_clearstream.com

> >

> >Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> >San Diego, California        -- Public Internet access / Mailing Lists

> >--------------------------------------------------------------------

> >To REMOVE yourself from this mailing list, send an E-Mail message

> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> >the message BODY, include a line containing: UNSUB ORACLE-L

> >(or the name of mailing list you want to be removed from).  You may

> >also send the HELP command for other information (like subscribing).

> >--

> >Please see the official ORACLE-L FAQ: http://www.orafaq.com

> >--

> >Author: Wang, Linda

> >   INET: lwang_at_messagemedia.com

> >

> >Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> >San Diego, California        -- Public Internet access / Mailing Lists

> >--------------------------------------------------------------------

> >To REMOVE yourself from this mailing list, send an E-Mail message

> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in

> >the message BODY, include a line containing: UNSUB ORACLE-L

> >(or the name of mailing list you want to be removed from).  You may

> >also send the HELP command for other information (like subscribing).

> 

> _________________________________________________________________________

> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

> 

> Share information about yourself, create your own public profile at 

> http://profiles.msn.com.

> 

> -- 

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> -- 

> Author: ARUN K C

>   INET: arun_k_c_at_hotmail.com

> 

> Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

> San Diego, California        -- Public Internet access / Mailing Lists

> --------------------------------------------------------------------

> To REMOVE yourself from this mailing list, send an E-Mail message

Received on Mon Nov 20 2000 - 15:13:05 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US