Re: Oracle block corruption, restore and roll forward

From: Andrew Riley <himsdba_at_yahoo.co.uk>
Date: 3 Nov 2004 08:37:40 -0800
Message-ID: <30e7f1c6.0411030837.4caeee7c@posting.google.com>

Thanks for the feedback. We have made some progress and here is a brief outline.

We used Metalink to identify the object, block number and relevant file. After cloning the database on SAN we restored a good copy of the datafile from an early backup, checked it was OK with DBVerify and recovered. It all completed BUT repicated the corrupt block. We think this was caused by extremely intense I/O on the database (bit of conjecture).

Although the database is 81741, legacy data types forces us to use 804 compatibility meaning we are unable to use DBMS_REPAIR. It also means we are unable to use the data salvage SQL on Metalink (the long raw column data type is explicitly unsupported).

Anyone any idea how we may recover/salvage data other than using select/insert based on low/hi rowid?

We are also registered Oracle users and hope to get assistance from the 'experts' (although they have ignored the 804 compatibility!!!)

Thanks in advance
Andrew Riley Received on Wed Nov 03 2004 - 10:37:40 CST