We had a database crash two months back and while performing the recovery(RMAN) one of the restored data file was corrupted. *BIG SHOCK* to everyone..We ran the dbverify on the restored files, the corruption showed up easily.. But not a single clue on the RMAN backup logs'.
We asked Oracle Support, if rman checks for corruption in the data files when the data files are being backed up.. He said "No"..
Oracle Ver: 8.1.7.2/Sun 2.6
..Ponnusamy
At 11:40 AM 2/24/2003 -0800, DENNIS WILLIAMS wrote:
Stephen RMAN ignored your corrupted block? Ya gotta tell us more man! We're relying on it to catch everything. Did you have the MAXCORRUPT parameter set?
Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED]
-----Original Message----- Sent: Monday, February 24, 2003 11:45 AM To: Multiple recipients of list ORACLE-L
I think more recent versions of Oracle have options for skipping corrupt blocks with exports.
One possible way: If you have a valid primary key index on the table, and the index is in a good tablespace, you might be able to cycle through all the primary keys, select the row corresponding to that primary key and insert it into a new table. I was able to do this about a month ago with a 8.1.7 database. In my case, I think it was a block header that was corrupt, not data; so I got all the data OK. It was rather slow, grabbing and inserting one row at a time; but I got all the data. As long as I didn't do anything that would cause a table scan of any kind, I could get the data.
By the way, rman not only failed to spot the corruption, but backed it up AND restored the corruption! My initial attempt was to just rename the datafile at the file system level, then recover it from the previous backup. I could relate another one of those TAR non-support -- total and complete NON-support! -- on this one.
> -----Original Message----- > > So my question is, if all backups contain the corrupted > block, how would > I copy all non-corrupted blocks from this table into a new table? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ponnusamy INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
