| 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: Exports > 2GB -- need scripts
--0-646671963-974743728=:84870
Content-Type: text/plain; charset=us-ascii
If the datbase is 45g, I'd expect that the export will be over 2g even if compressed. Even if I compress with gzip which yields a better compression ration that compress, the best ration I get is about 4:1. He's going to need to both compress and split. Something like this would work.
mkfifo expdat.dmp
compress < expdat.dmp | split -b 2048m - export_
exp us/pw parfile=exp.par
To import an individual table however, you need to search through the entire export. That could take quite a long time. What I would recommend doing is to split the export up by table, tablespace, or table related groups of tables (related via FK's) and do individual exports of each. You could do them in parallel to speed it up. That way the export is granular enough that you can quickly recover an individual table without having to scan through a single huge export file.
Allan Davis Sahadeo <asahadeo_at_neal-and-massy.com> wrote:
I was wondering, if the size of the compressed file did exceed 2 gigs then
we would indeed be in a bit of a predicament. Since an export does compress
fairly nicely, we may not encounter such a problem. But what if we did...
What would we do then ? Do we split our compressed files ? And if so how do
we ?
Allan.
----- Original Message -----
To: "Multiple recipients of list ORACLE-L"
Sent: Friday, November 17, 2000 4:50 PM
Here are the scripts for export and import:
For export:
mknod t1.dmp p
compress < t1.dmp> t10.dmp.Z &
exp us/pw parfile=exp.dat
For Import:
/etc/mknod t1.dmp p
dd of=t10.dmp if=t1.dmp &
imp us/pw parfile=imp.dat
Ramani
DBA
>>> 11/17/00 01:25PM >>>
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.
--
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Akhil Ramani
INET: Akhil.Ramani_at_3cc.co.wayne.mi.us
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Allan Davis Sahadeo
INET: asahadeo_at_neal-and-massy.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists
<P> If the datbase is 45g, I'd expect that the export will be over 2g even if compressed. Even if I compress with gzip which yields a better compression ration that compress, the best ration I get is about 4:1. He's going to need to both compress and split. Something like this would work.</P> <P>mkfifo expdat.dmp<BR>compress < expdat.dmp | split -b 2048m - export_<BR>exp us/pw parfile=exp.par</P> <P>To import an individual table however, you need to search through the entire export. That could take quite a long time. What I would recommend doing is to split the export up by table, tablespace, or table related groups of tables (related via FK's) and do individual exports of each. You could do them in parallel to speed it up. That way the export is granular enough that you can quickly recover an individual table without having to scan through a single huge export file.</P> <P> <B><I>Allan Davis Sahadeo <asahadeo_at_neal-and-massy.com></I></B> wrote: <BR> <BLOCKQUOTE style="BORDER-LEFT: #1010ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px">I was wondering, if the size of the compressed file did exceed 2 gigs then<BR>we would indeed be in a bit of a predicament. Since an export does compress<BR>fairly nicely, we may not encounter such a problem. But what if we did...<BR>What would we do then ? Do we split our compressed files ? And if so how do<BR>we ?<BR>Allan.<BR>----- Original Message -----<BR>To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_FATCITY.COM><BR>Sent: Friday, November 17, 2000 4:50 PM<BR><BR><BR>Here are the scripts for export and import:<BR><BR>For export:<BR>mknod t1.dmp p<BR>compress < t1.dmp> t10.dmp.Z &<BR>exp us/pw parfile=exp.dat<BR><BR>For Import:<BR>/etc/mknod t1.dmp p<BR>dd of=t10.dmp if=t1.dmp &<BR>imp us/pw parfile=imp.dat<BR><BR>Ramani<BR>DBA<BR><BR>>>> <CEMAIL_at_SPRINTMAIL.COM>11/17/00 01:25PM >>><BR><BR>I have a 45GB Oracle 8.0.5 database on HPUX. I want to be abl! e<BR>to do nightly exports so that if any of the tables gets "accidentally"<BR>truncated or whatever, we can restore just the table and not<BR>have to restore the entire database.<BR><BR>Does anybody have a script that uses the split(?) utility and<BR>compress so that the export isn't bigger than 2GB? What about<BR>importing? Can just one table be picked out of that large of<BR>an export if the export is split up and compressed? Please let<BR>me know your experience/advice on doing this.<BR><BR>-----<BR>Sent using MailStart.com ( http://MailStart.Com/welcome.html )<BR>The FREE way to access your mailbox via any web browser, anywhere!<BR><BR>--<BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>--<BR>Author:<BR>INET: cemail@sprintmail.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yours! elf from this mailing list, send an E-Mail message<BR>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).<BR><BR>--<BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>--<BR>Author: Akhil Ramani<BR>INET: Akhil.Ramani@3cc.co.wayne.mi.us<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for oth! er information (like subscribing).<BR><BR>-- <BR>Please see the official ORACLE-L FAQ: http://www.orafaq.com<BR>-- <BR>Author: Allan Davis Sahadeo<BR>INET: asahadeo@neal-and-massy.com<BR><BR>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051<BR>San Diego, California -- Public Internet access / Mailing Lists<BR>--------------------------------------------------------------------<BR>To REMOVE yourself from this mailing list, send an E-Mail message<BR>to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in<BR>the message BODY, include a line containing: UNSUB ORACLE-L<BR>(or the name of mailing list you want to be removed from). You may<BR>also send the HELP command for other information (like subscribing).</BLOCKQUOTE><p><br><hr size=1><b>Do You Yahoo!?</b><br><a href="http://calendar.yahoo.com/">Yahoo! Calendar</a> - Received on Mon Nov 20 2000 - 12:08:48 CST
 |
 |