Errors in file /opt/oradiag/diag/rdbms/phsub/phsub2/trace/phsub2_pz99_23564.trc (incident=496822):
ORA-01578: ORACLE data block corrupted (file # 1, block # 112636)
ORA-01110: data file 1: '/oracle/oradata1/phsub/system01.dbf'
Incident details in: /opt/oradiag/diag/rdbms/phsub/phsub2/incident/incdir_496822/phsub2_pz99_23564_i496822.trc
SELECT DISTINCT owner, segment_name
FROM gv$database_block_corruption dbc
JOIN dba_extents e ON dbc.file# = e.file_id AND dbc.block# BETWEEN e.block_id and e.block_id+e.blocks-1
ORDER BY 1,2;
SELECT segment_type, segment_name
FROM dba_extents
WHERE file_id = 1
AND 112636 BETWEEN block_id AND block_id + blocks -1;
Validate datafile 249 block 226263 ;
VALIDATE CHECK LOGICAL DATAFILE 249;
VALIDATE DATAFILE 249;