Re: Compressing Export Dumps

way back (7.3 version) I wrote a set of scripts to export to a pipe, split and compress the split files.. It was based on the Metalink doc and I *think* copies of them are still out on the archives on www.lazydba.com

but now, when you can split files via export, so the split is done by Oracle and supposedly fool-proof, why not do it that way?

|--------+----------------------->
|        |                       |
|        |                       |
|        |          lembark_at_wrkho|
|        |          rs.com       |
|        |                       |
|        |          05/16/2002   |
|        |          10:38 AM     |
|        |          Please       |
|        |          respond to   |
|        |          ORACLE-L     |
|        |                       |
|--------+----------------------->
  >----------------------------------------------------|
  |                                                    |
  |       To:     ORACLE-L_at_fatcity.com                 |
  |       cc:     (bcc: Rachel Carmichael)             |
  |       Subject:     Re: Compressing Export Dumps    |
  >----------------------------------------------------|

>> If you are on Unix, you can pipe the export into a "split" command and
>> break the file into multiples and compress on the fly. There's a note on
>> metalink about it (note 30528.1)

Easier of you split the zipped result:

    mknod /tmp/dump p;

    gzip --fast < /tmp/dump | split -b $((1024*1024*1024)) date +"dump-%Y%m%d";

Gives a set of 1GB files as output. Simpler to manage since they all have the same size (whatever you set -b to) w/ a runt file at the end.

--
Steven Lembark                               2930 W. Palmer
Workhorse Computing                       Chicago, IL 60647
                                            +1 800 762 1582
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Lembark
  INET: lembark_at_wrkhors.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: Rachel_Carmichael_at_sonymusic.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).