ORA-01115: IO error reading block from file 20 (block # 61922)
Ramky99Nov 10 2010 — edited Nov 10 2010Hi all,
I'm faced with this error:
ORA-01115: IO error reading block from file 20 (block # 61922)
So I ran DB verify tool against file 20 and got the following:
dbv file=/xxx/tbl_small_static_xxx_01.dbf blocksize=8192
DBVERIFY: Release 8.1.7.0.0 - Production on Wed Nov 10 11:02:43 2010
(c) Copyright 2000 Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE = /xxx/tbl_small_static_xxx_01.dbf
DBVERIFY - Verification complete
Total Pages Examined : 16384
Total Pages Processed (Data) : 4588
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 410
Total Pages Empty : 11386
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
..so no probs???
DB is 8.1.7.0.0
OS is AIX 4.3.3.0
What else can I do if verify says all is OK?
Thanks!
Adam