Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: Compressing Export Dumps
Hi Sergey and all,
Tried to impliment the on-the-fly gzip but some breakages!!
I created 7 different pipes and 7 different export jobs.
The first job run manually completed successfuly but all the
croned jobs are stuck -the daemon fired them off but nothing is taking place!
The Log files are empty and the zipped dumps are no where to be seen!
A "ps -ef|grep exp" shows that the jobs are active. It's now coming to 10
Hrs.
Any known issues with multi-occurences of pipe-files/gzip etc ?
Thanks
-----Original Message-----
Sent: Friday, May 17, 2002 5:18 AM
To: Multiple recipients of list ORACLE-L
Hello Simon,
The command mknod p does the same thing as mkfifo (it just calls mknod
p).
I did large exports many times using gzip. So, it's your decision
whether to use compress or gzip. I did not have any troubles
at all. You don't have to remove the pipe and can easily reuse it
whether you want.
Thursday, May 16, 2002, 8:43:25 PM, you wrote:
SW> Sergey,
SW> Thanks for the mkfifo idea. I've also come across "mknod myfifo p;compess
<
myinfo >> myinfo.Z"
SW> I'm looking at the two options, yet to ascertain whether second method
works
SW> with gzip.
SW> Do you know of any known troubles (Block/File corruption) with first
method ?
SW> Do I have to "rm yourinfo" or I can re-use the piping file ( as in
ascript) ?
SW> Thanks once again,
SW> Simon
SW> -----Original Message----- SW> Sent: Thursday, May 16, 2002 2:48 PM SW> To: Multiple recipients of list ORACLE-L
SW> Hello Simon,
SW> You can make it like this:
SW> mkfifo yourfifo SW> gzip <yourfifo >outfile.dmp.gz & SW> exp ... file=yourfifo SW> rm yourfifo
SW> Thursday, May 16, 2002, 4:38:40 PM, you wrote:
SW>> Hi all,
SW>> My export dumps are too big (80 GB) for my filesystem and I'm looking
for
SW> a SW>> way SW>> to compress them on the fly -ie without taking *.dmp to disk first but SW>> straight *.dmp.gz SW>> Anybody with an idea on how to archive this ? SW>> Thanking you,
SW>> ---
SW>> CSW
--
Best regards,
Sergey mailto:dsv_at_pptus.oilnet.ru
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sergey V Dolgov
INET: dsv_at_pptus.oilnet.ru
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).
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). Received on Sat May 18 2002 - 06:03:18 CDT
![]() |
![]() |