| 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: Exp with Compress, dmp corrupted !
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C07A50.E467D51A
Content-Type: text/plain
I've seen this several times. If your host was swapping during the export, it very likely corrupted your export file.
Can you export it without compress? Are you limited to 2GB file size? Here on hp/ux 11 I am not so I create ~15GB exp file every night and compress it after the exp completes.
Lisa Rutland Koivu
Oracle Database Administrator
Qode.com
4850 North State Road 7
Suite G104
Fort Lauderdale, FL 33319
V: 954.484.3191, x174 F: 954.484.2933 C: 954.658.5849
"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."
-----Original Message-----
From: Leonardo Fernandez [mailto:lfernand_at_cmsenergy.com]
Sent: Tuesday, January 09, 2001 7:36 AM
To: Multiple recipients of list ORACLE-L
Subject: Exp with Compress, dmp corrupted !
Last week it generates an export with:
mknod /tmp/exp_dbacom p
compress < /tmp/exp_dbacom > /conversion/IC_TABLAS.dmp.Z &
expst userid=user/password file=/tmp/exp_dbacom buffer=20000000 parfile=tab1
and when it tries to import with:
mknod /tmp/imp_dbacom p
uncompress < /conversion/IC_TABLAS.dmp.Z > /tmp/imp_dbacom &
impst file=/tmp/imp_dbacom parfile=tab2
I received the following error:
IMP-00037: Character set marker unknown IMP-00021: operating system error - error code (dec 2, hex 0x2) IMP-00000: Import terminated unsuccessfullyI have always "cloned" databases, both are same (init.ora, etc)
Metalink tells me that the file this corrupt one ...
Any idea or suggestion in this respect
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leonardo Fernandez INET: lfernand_at_cmsenergy.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). ------_=_NextPart_001_01C07A50.E467D51A Content-Type: text/html Content-Transfer-Encoding: quoted-printableReceived on Tue Jan 09 2001 - 09:28:56 CST
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Exp with Compress, dmp corrupted !</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>I've seen this several times. If your host was =
swapping during the export, it very likely corrupted your export = file. </FONT></P>
<P><FONT SIZE=3D2>Can you export it without compress? Are you =
limited to 2GB file size? Here on hp/ux 11 I am not so I create = ~15GB exp file every night and compress it after the exp completes. =
</FONT></P>
<BR>
<P><FONT SIZE=3D2>Lisa Rutland Koivu</FONT>
<BR><FONT SIZE=3D2>Oracle Database Administrator</FONT>
<BR><FONT SIZE=3D2>Qode.com</FONT>
<BR><FONT SIZE=3D2>4850 North State Road 7</FONT>
<BR><FONT SIZE=3D2>Suite G104</FONT>
<BR><FONT SIZE=3D2>Fort Lauderdale, FL 33319</FONT>
</P>
<P><FONT SIZE=3D2>V: 954.484.3191, x174</FONT>
<BR><FONT SIZE=3D2>F: 954.484.2933 </FONT>
<BR><FONT SIZE=3D2>C: 954.658.5849</FONT>
<BR><FONT SIZE=3D2><A HREF=3D"http://www.qode.com" =
TARGET=3D"_blank">http://www.qode.com</A></FONT>
</P>
<P><FONT SIZE=3D2>"The information contained herein does not =
express the opinion or position of Qode.com and cannot be attributed to = or made binding upon Qode.com."</FONT></P>
<BR>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Leonardo Fernandez [<A =
HREF=3D"mailto:lfernand_at_cmsenergy.com">mailto:lfernand_at_cmsenergy.com</A>= ]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, January 09, 2001 7:36 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Exp with Compress, dmp corrupted !</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>Last week it generates an export with:</FONT>
<BR><FONT SIZE=3D2>mknod /tmp/exp_dbacom p</FONT>
<BR><FONT SIZE=3D2>compress < /tmp/exp_dbacom > =
/conversion/IC_TABLAS.dmp.Z &</FONT>
<BR><FONT SIZE=3D2>expst userid=3Duser/password file=3D/tmp/exp_dbacom =
buffer=3D20000000 parfile=3Dtab1</FONT>
</P>
<P><FONT SIZE=3D2>and when it tries to import with:</FONT>
<BR><FONT SIZE=3D2>mknod /tmp/imp_dbacom p</FONT>
<BR><FONT SIZE=3D2>uncompress < /conversion/IC_TABLAS.dmp.Z =
> /tmp/imp_dbacom &</FONT>
<BR><FONT SIZE=3D2>impst file=3D/tmp/imp_dbacom parfile=3Dtab2</FONT>
</P>
<P><FONT SIZE=3D2>I received the following error:</FONT>
<BR><FONT SIZE=3D2>IMP-00037: Character set marker unknown</FONT>
<BR><FONT SIZE=3D2>IMP-00021: operating system error - error code (dec =
2, hex 0x2)</FONT>
<BR><FONT SIZE=3D2>IMP-00000: Import terminated unsuccessfully</FONT>
<BR><FONT SIZE=3D2>I have always "cloned" databases, both are =
same (init.ora, etc)</FONT>
</P>
<P><FONT SIZE=3D2>Metalink tells me that the file this corrupt one =
...</FONT>
</P>
<P><FONT SIZE=3D2>Any idea or suggestion in this respect</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A =
HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT>
<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Leonardo Fernandez</FONT>
<BR><FONT SIZE=3D2> INET: lfernand_at_cmsenergy.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet = access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------= -----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
 |
 |