| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> ORA - 1578 - ORACLE data block corrupted - URGENT!!!
This is a multi-part message in MIME format.
------=_NextPart_000_007C_01C00C6E.CDD3F590 Content-Type: multipart/alternative;
boundary="----=_NextPart_001_007D_01C00C6E.CDD3F590"
------=_NextPart_001_007D_01C00C6E.CDD3F590 Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
hi gurus,
OS - NT 4
ORACLE - 7.3.4.4
Mode - No Archive log
When accessing db, i am getting the ora 1578.... (file id 8 and block id = 889).. I have found the datafile and the segment also. In that = particular segment one big table is there. i couldn't able to access the = table. Is it logical corruption or Physical? retrieving from the cold = backup is the only way ?
Thnx & Regds,
Svenki
"This communication is for the exclusive use of the intended recipient/s
and shall not attach any liability on the originator. It may contain =
=20
information which is confidential and legally privileged and the same
shall not be used or dealt with by any third party in whatsoever =
manner."
=20
------=_NextPart_001_007D_01C00C6E.CDD3F590 Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type><BASE=20
href=3D"file://C:\Program Files\Common Files\Microsoft =
Shared\Stationery\">
<META content=3D"Microsoft FrontPage Express 2.0" name=3DGENERATOR>
<STYLE>BODY {
BACKGROUND-COLOR: #fffffd; BACKGROUND-POSITION: left top; =
BACKGROUND-REPEAT: repeat-y; COLOR: #427d64; FONT-FAMILY: "Arial"; =
FONT-SIZE: 12pt; FONT-WEIGHT: normal; MARGIN-BOTTOM: 0em; MARGIN-LEFT: =
4em; MARGIN-TOP: 0em
}
P.msoNormal {
BACKGROUND-COLOR: #fffffd; BACKGROUND-POSITION: left top; =
BACKGROUND-REPEAT: repeat-y; COLOR: #427d64; FONT-FAMILY: "Arial"; =
FONT-SIZE: 12pt; FONT-WEIGHT: normal; MARGIN-BOTTOM: 0em; MARGIN-LEFT: =
4em; MARGIN-TOP: 0em
}
LI.msoNormal {
BACKGROUND-COLOR: #fffffd; BACKGROUND-POSITION: left top; =
BACKGROUND-REPEAT: repeat-y; COLOR: #427d64; FONT-FAMILY: "Arial"; =
FONT-SIZE: 12pt; FONT-WEIGHT: normal; MARGIN-BOTTOM: 0em; MARGIN-LEFT: =
4em; MARGIN-TOP: 0em
}
</STYLE>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR></HEAD>
<BODY background=3Dcid:007b01c00c40$b418ac50$0100005a_at_90 =
bgColor=3D#ffffff>
<DIV>hi gurus,</DIV>
<DIV> </DIV>
<DIV>OS - NT 4</DIV>
<DIV>ORACLE - 7.3.4.4</DIV>
<DIV>Mode - No Archive log</DIV>
<DIV> </DIV>
<DIV>When accessing db, i am getting the ora 1578.... (file id 8 and =
block id=20
889).. I have found the datafile and the segment also. In that =
particular=20
segment one big table is there. i couldn't able to access the table. Is =
it=20
logical corruption or Physical? retrieving from the cold backup is the =
only way=20
?</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Thnx & Regds,</DIV>
<DIV> </DIV>
<DIV>Svenki</DIV>
<DIV> </DIV>
<DIV><BR>"This communication is for the exclusive use of the intended=20
recipient/s<BR>and shall not attach any =
liability on the=20
originator. It may contain <BR>information which =
is confidential and legally privileged and the same<BR>shall =
not be=20
used or dealt with by any third party in whatsoever manner."</DIV>
<DIV> </DIV>
<DIV> </DIV>
<P> </P></BODY></HTML>
Received on Tue Aug 22 2000 - 08:56:00 CDT
 |
 |