Re: Block corruption while rebuilding the tablespace
From: Sidney Chen <huanshengchen_at_gmail.com>
Date: Mon, 14 Nov 2011 22:44:24 +0800
Message-ID: <CAM_ddu-Dq-pxT9T9Fua7HpxX7u3st-M9ogeeVEE5BWrQD+C9Sg_at_mail.gmail.com>
What's the oracle version and os platform seems the data block is marked as soft corruption during the recovery, see if you have backup after the nologging operation, if no, i don't think the data is salvageable. if yes, you can try rman block media recovery. see below note and documents.
Date: Mon, 14 Nov 2011 22:44:24 +0800
Message-ID: <CAM_ddu-Dq-pxT9T9Fua7HpxX7u3st-M9ogeeVEE5BWrQD+C9Sg_at_mail.gmail.com>
What's the oracle version and os platform seems the data block is marked as soft corruption during the recovery, see if you have backup after the nologging operation, if no, i don't think the data is salvageable. if yes, you can try rman block media recovery. see below note and documents.
ORA-1578 / ORA-26040 Corrupt blocks by NOLOGGING - Error explanation and
solution [ID 794505.1]
19 Performing Block Media
Recovery<http://download.oracle.com/docs/cd/E11882_01/backup.112/e10642/rcmblock.htm#i1006577>
--
Regards
Sidney Chen
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Nov 14 2011 - 08:44:24 CST