Re: ORA-01578 errors

<tim.kearsley_at_milton-keynes.gov.uk> wrote in message news:1147344953.728218.203950_at_y43g2000cwc.googlegroups.com...
> Hi all,
>
> Environment is:
>
> IBM H80 64-bit enterprise server
> AIX 5.2
> Oracle Enterprise Edition 9.2.0.6 64-bit
>
> A couple of days ago we started seeing a few overnight jobs fail with
> error ORA-01578 - block corruption. However, checking the indicated
> data file with dbverify has usually proved negative - i.e. no reported
> problem. Also, I identified the object associated with the corrupted
> block - a 10 million row-table - and ran an ANALYZE TABLE VALIDATE
> STRUCTURE CASCADE command against it which again reported no problem.
> A full export of the table likewise indicated no problem. The 1578
> error then went away but re-appeared in a different file/block.
>
> The day before these errors began to appear I had been moving data
> between physical disks using AIX's migratepv command. I therefore
> reasoned that maybe one of the disks I had migrated data to was
> intermittently causing read errors. The logical volumes concerned are
> software mirrored (i.e. two LV copies). However, I ran AIX's certify
> on both disks which contained the data file which apparently had a
> corrupt block and they checked out OK.
>

Check out Note 261460.1 on Metalink, you may be hitting this issue (although Oracle's part of the fix should be in place in 9.2.0.6, you may need to reconfigure LVs.)

-- 
   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)
   http://www.dynamicpsp.com