| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re[4]: Compressing Export Dumps
Hello Simon,
I did such exports sequentially (using cron jobs) therefore i had no
problems with it.
Try to look at locks maybe your sessions are blocking each other.
Did you use parameter CONSISTENT=Y ?
Saturday, May 18, 2002, 6:03:18 PM, you wrote:
SW> Hi Sergey and all, SW> Tried to impliment the on-the-fly gzip but some breakages!! SW> I created 7 different pipes and 7 different export jobs. SW> The first job run manually completed successfuly but all the SW> croned jobs are stuck -the daemon fired them off but nothing is taking place! SW> The Log files are empty and the zipped dumps are no where to be seen! SW> A "ps -ef|grep exp" shows that the jobs are active. It's now coming to 10 SW> Hrs. SW> Any known issues with multi-occurences of pipe-files/gzip etc ?
SW> Thanks
SW> -----Original Message----- SW> Sent: Friday, May 17, 2002 5:18 AM SW> To: Multiple recipients of list ORACLE-L
SW> Hello Simon,
SW> The command mknod p does the same thing as mkfifo (it just calls mknod SW> p). SW> I did large exports many times using gzip. So, it's your decision SW> whether to use compress or gzip. I did not have any troubles SW> at all. You don't have to remove the pipe and can easily reuse it SW> whether you want.
SW> 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 SW> <
SW>> I'm looking at the two options, yet to ascertain whether second method SW> works SW>> with gzip. SW>> Do you know of any known troubles (Block/File corruption) with first SW> method ? SW>> Do I have to "rm yourinfo" or I can re-use the piping file ( as in SW> 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 SW> 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). Received on Mon May 20 2002 - 00:33:17 CDT
 |
 |