RE: Exports > 2GB -- need scripts

From: Nancy McCormick <nmccormick_at_sbti.com>
Date: Mon, 20 Nov 2000 13:02:48 -0500
Message-Id: <10686.122519@fatcity.com>

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-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of cemail_at_sprintmail.com
Sent: Friday, November 17, 2000 1:26 PM
To: Multiple recipients of list ORACLE-L Subject: Exports > 2GB -- need scripts

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

Received on Mon Nov 20 2000 - 12:02:48 CST