How To Check If Database Got Corrupted?

Datablock level Corruption can be found out with the help of the following two queries.

SQL> SELECT distinct ‘Data Block# ‘|| block# || ‘ of Data File ‘

|| name || ‘ is corrupted.’

FROM v$backup_corruption a, v$datafile b

WHERE a.file# = b.file#;

2 3 4

no rows selected

SQL> SELECT distinct ‘Data Block# ‘|| block# || ‘ of Data File ‘

|| name || ‘ is corrupted.’

FROM v$copy_corruption a, v$datafile b

WHERE a.file# = b.file#;

2 3 4

no rows selected