How to check physical and logical data corruption using RMAN?

If you are not using RMAN to backup data and use technologies like NetApp snapshot which doesn’t check for physical and logical corruption, one can still use RMAN to check for physical and logical corruption in the datafiles and not back the data up.

connect target /

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;
}

Corruptions information are recorded in the V$DATABASE_BLOCK_CORRUPTION view.

One thought on “How to check physical and logical data corruption using RMAN?

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.