Message-Id: <10597.115210@fatcity.com> From: "Srinivasan Venkat Raman" Date: Tue, 22 Aug 2000 19:26:00 +0530 Subject: 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

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=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 ?

Thnx & Regds,

Svenki

"This communication is for the exclusive use of the intended=20 recipient/s
and shall not attach any = liability on the=20 originator. It may contain
information which = is confidential and legally privileged and the same
shall = not be=20 used or dealt with by any third party in whatsoever manner."