Nope, SQL-Backtrack. I need to dig into those docs to see if that is a feature or configuration issue.
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: Suzy Vordos 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).