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

RE: my previous message -- of course, if you can't access the table at all, you won't be able to copy it. However, there are some cases where that type of command does work. I had it happen to me back on a version 6 database and what I described did work.

-----Original Message-----

From: Miller, Bryan [mailto:MillerB_at_telergy.net] Sent: Tuesday, August 22, 2000 12:55 PM
To: Multiple recipients of list ORACLE-L Subject: RE: ORA - 1578 - ORACLE data block corrupted - URGENT!!!

You can replace the datafile(s) but if you are not in archivelog mode then it will not be able to do media recovery and data will be lost.

-----Original Message-----

Sent: Tuesday, August 22, 2000 11:02 AM
To: Multiple recipients of list ORACLE-L

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 information which is confidential and legally privileged and the same shall not be used or dealt with by any third party in whatsoever manner."    

-- 
Author: Miller, Bryan
  INET: MillerB_at_telergy.net

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).