Re: Exports > 2GB -- need scripts

Go to the LazyDBA website and under scripts you will find a set of scripts by Rachel Carmichael which do a compressed export and uncompressed import and work very well.

RuthGramolini
----- Original Message -----
From: "Nancy McCormick" <nmccormick_at_sbti.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Monday, November 20, 2000 12:55 PM Subject: RE: Exports > 2GB -- need scripts

> Here is an article I pulled of a site a couple of years ago. It works
very
> nicely.
> Hope this helps.
> Nancy
>
> Exporting a Database That's More Than 2GB When Compressed
> This Tip of the Week entry comes from Devarajan Sundaravaradan, a Senior
> Consultant for Leading Edge Systems, Inc. in Edison, New Jersey.
>
> In HP-UX, there is a 2GB limit on file sizes of 2GB. Many of us have
reached
> this limit when exporting files and the most common solution is to do a
> filesystem compression of the export dump using named pipes and then store
> the compressed file. But what if the compressed file itself passes the 2GB
> limit? There is solution to this, too.
>
> ---------------- Export Section
> # Create new Named pipes.
> mknod -p /dev/split_pipe
> mknod -p /dev/compress_pipe # You can use the existing named pipe
> # itself, instead of creating new.
> ======================================================================
> Create a shell script under a file, named Split_export.sh
> ======================================================================
> # -b1000m indicates to split command to split the input file into every
1000
> MB size.
> # As it splits, the split command will suffix aa, ab, ac, ad ... upto zz
to
> the file name specified.
> # The export file name is expfile.
> nohup split -b1000m < /dev/split_pipe > /DumpDir/expfile &
> nohup compress < /dev/compress_pipe > /dev/split_pipe &
> exp username/password full=y file=/dev/compress_pipe and other parameters
> for export.
> =======================================================================
> After saving the above three commands in split_export.sh, execute the
> following.
> =======================================================================
> chmod a+x split_export.sh
> nohup split_export.sh > /tmp/split_export.log 1>&2 &
> =======================================================================
> After a few minutes you should see files in the export dump directory.
> =======================================================================
>
> ------------------ IMPORT Section
> ======================================================================
> Create a shell script with the following command under the file name
> split_import.sh.
> After creating provide execution permission to this script as follows:
> ======================================================================
> Chmod a+x split_import.sh
> # The import script assumes in this example that the above export script
> created 2 split files
> # called expfileaa and expfileab. The order of the file for the cat
command
> is very important.
> nohup cat /dumpdir/expfileaa /dumpdir/expfileab > /dev/split_pipe &
> # sleep 3 seconds
> Sleep 3
> nohup uncompress < /dev/split_pipe > /dev/compress_pipe &
> #Sleep at this point is very important as some time is needed to
uncompress
> the file and send it to the pipe.
> sleep 60
> imp username/password file=/dev/compress_pipe and other parameters for
> export.
> nohup split_import.sh > /tmp/split_import.log 1>&2 &
> =======================================================================
> Wait for the import to finish.
> =======================================================================
>
> -----Original Message-----
> cemail_at_sprintmail.com
> Sent: Friday, November 17, 2000 1:26 PM
> To: Multiple recipients of list ORACLE-L
>
>
>
> 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: Nancy McCormick
> INET: nmccormick_at_sbti.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
Received on Mon Nov 20 2000 - 12:25:58 CST