Tuesday, September 5, 2017

Check block corruption in oracle database



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;

Featured Post

Apply Patch 22191577 latest GI PSU to RAC and DB homes using Opatch auto or manual steps

Patch 22191577: GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.4.160119 (JAN2016) Unzip the patch 22191577 Unzip latest Opatch Version in or...