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-----
From: Srinivasan Venkat Raman [mailto:svenki_at_hclinsys.com] Sent: Tuesday, August 22, 2000 11:02 AM
To: Multiple recipients of list ORACLE-L Subject: ORA - 1578 - ORACLE data block corrupted - URGENT!!!

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." Received on Tue Aug 22 2000 - 10:45:17 CDT