ORA-01578: ORACLE data block corrupted

ORA-00604: error occurred at recursive SQL level 1

ORA-01110: data file 2: '/pac/ls1fbddb/data/ls1fbddb/sysaux01.dbf'

ORA-01578: ORACLE data block corrupted (file # 2, block # 405)

Solution:  before going to recover block had full DB backup with all archive logs.

we need to check which block is corrupted using below command:

select * from v$database_block_corruption;

you can identified which block is corrupted using DBVerify  utility for e.g.

Now, let me check the same using DBV utility.

dbv file=’ /pac/ls1fbddb/data/ls1fbddb/sysaux01.dbf'

this utility gives some output and DB blocks details.

So, let me check for the corruption using RMAN “validate database”.

Rman target /

Run {validate database;}

Validate all DB datafiles and backup. And check in which datafile block corrupted.

Then u need to execute below command to recover block.

run {blockrecover datafile 2 block 405;}

recovery completed.