tag:blogger.com,1999:blog-8884584404576003487.post2895667622264296924..comments2024-02-29T09:43:12.251-05:00Comments on ORACLENERD: ORA-01578: ORACLE data block corrupted (file # 7, block # 42061)oraclenerdhttp://www.blogger.com/profile/12412013306950057961noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-8884584404576003487.post-68285901894931368322017-03-31T09:23:23.159-04:002017-03-31T09:23:23.159-04:002017 and it saved me! Thanks!2017 and it saved me! Thanks!Elly Allysonnoreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-19315010205079675882011-02-21T13:35:48.378-05:002011-02-21T13:35:48.378-05:00That's excellent news sir, thank you.
I'l...That's excellent news sir, thank you.<br /><br />I'll drop and begin the load process again. Hopefully this post will die it's natural death. :)oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-49340315977131824392011-02-21T13:31:54.220-05:002011-02-21T13:31:54.220-05:00I see no reason why you should do more work than n...I see no reason why you should do more work than necessary (lazy people are good in tuning).<br />Just drop the object and re-load it. <br />If such an error re-occurs, it might be worth investigating it. <br />I am just somewhat irritated by the fact of a block corruption itself. Can we trust your full stack? We will see in the future.Martin Bergerhttps://www.blogger.com/profile/16504572924713610305noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-60650038751955909672011-02-21T13:24:57.121-05:002011-02-21T13:24:57.121-05:00@Martin
Added the results of that query to the po...@Martin<br /><br />Added the results of that query to the post, it's a table.<br /><br />So you're saying I <i>don't</i> have to rebuild the entire VM or database? Correct?oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-81029133164072168002011-02-21T12:39:54.827-05:002011-02-21T12:39:54.827-05:00ok, I still stick to Note:28814.1.
Let's find ...ok, I still stick to <a href="https://supporthtml.oracle.com/ep/faces/secure/km/DocumentDisplay.jspx?id=28814.1" rel="nofollow">Note:28814.1</a>.<br />Let's find the object in trouble:<br /><br /><i><br />SELECT tablespace_name, <br /> segment_type, <br /> owner, <br /> segment_name <br />FROM dba_extents <br />WHERE file_id = 7 <br /> AND 42061 BETWEEN block_id AND block_id + blocks - 1 <br /></i><br /><br />If the segment_type is a table, just drop that particular table and rel-load it.<br />If it's and index, rebuild it (not online).<br />If it's something else ... le's think about it later.<br /><br />have fun!Martin Bergerhttps://www.blogger.com/profile/16504572924713610305noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-30353892111423055952011-02-21T12:22:57.794-05:002011-02-21T12:22:57.794-05:00I might have known that, but obviously forgot. Her...I <i>might</i> have known that, but obviously forgot. Here's the <a href="http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_7002.htm#i2095331" rel="nofollow">link</a> to the documentation that describes it.<br /><br />It appears that it is just a comma separated list, cool. Unfortunately, I'm updating the FILE_ID for each file loaded (want to be able to easily find the source after it has all been moved around), so I can't do that, unless...oraclenerdhttps://www.blogger.com/profile/12412013306950057961noreply@blogger.comtag:blogger.com,1999:blog-8884584404576003487.post-79449866767339551122011-02-21T12:12:47.883-05:002011-02-21T12:12:47.883-05:00On another note... an external table can have mult...On another note... an external table can have multiple files associated with it, so you don't have to alter it to change the files. Just alter the external table to contain all the files, and do a single select against it.Stewart Brysonhttps://www.blogger.com/profile/16904522901298746643noreply@blogger.com