Check Physical And Logical Data Corruption Using RMAN

RMAN can be used to check for physical and logical corruption in the datafiles.

RMAN> connect target /
RMAN> run {
# set disk to be default device type
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
# number of concurrent sessions to spawn
CONFIGURE DEVICE TYPE DISK PARALLELISM 10 BACKUP TYPE TO BACKUPSET;
# check datafiles for corruption 10 datafiles in each session
BACKUP VALIDATE CHECK LOGICAL DATABASE FILESPERSET=10;
}

You will find corruptions information recorded in the V$DATABASE_BLOCK_CORRUPTION view.