Hi,
Have 10.2.0.2. database and got corruption message when tried to write to a table and other users tried reading table and getting corrupt message.
Message below.
ORA-01115: IO error reading block from file 107 (block # 3984674)
ORA-01110: data file 107: '/<vol>/filename3.dbf'
ORA-27091: unable to queue I/O
ORA-27072: File I/O error
SVR4 Error: 5: I/O error
Additional information: 4
Additional information: 3984673
Additional information: -1
dba team are recovering database to standby database but may take days.
Curious as to if could identify blocks which corrupt and create table on non-corrupt blocks on diff volume
1)
First step would have been to identify corrupt blocks by looking at
but no rows in V$DATABASE_BLOCK_CORRUPTION - any idea why?
How could we find the corrupt blocks?
Also it it possible to create new table ignoring the corrupt blocks?
Also is there a way of identifying the rows which are causing the corruption.
large table using several datafiles.
Thanks