ORA - 1578 - ORACLE data block corrupted

From: Srinivasan Venkat Raman <svenki_at_hclinsys.com>
Date: Tue, 22 Aug 2000 19:26:00 +0530
Message-Id: <10597.115210@fatcity.com>

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 {

<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

ORA - 1578 - ORACLE data block corrupted - URGENT!!!