System tablespace corrupted

From: M Rafiq <rafiq9857_at_hotmail.com>
Date: Wed, 28 Jul 2004 20:17:33 -0400
Message-ID: <BAY2-F26M3h3vLgAusV00031020@hotmail.com>

Env: Windows 2000 SP 4 Oracle 9.2.0.5

While exporting full database, it was observed that there is 1 block is corrupted and other is fractured as per dbv. After checking it was tracked as a sys.table. dbinv alos points that corrupt block due media failure. SA ran Compaq provided utility which says no corruption of media.

Database is a development instance and no archive on. Simple way to restore complete database from cold backup of previous week.

Is there any other way to recover the table completely. DBMS_REPAIR package does not look to work for complete recovery. Full export hanging after generating errors for that block.

Regards
Rafiq

---

Planning a family vacation? Check out the MSN Family Travel guide! http://dollar.msn.com

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Wed Jul 28 2004 - 19:14:25 CDT