How do I use uvbackup to validate my database files?

To verify the integrity of your database files, you can run what is commonly referred to as a “dummy backup” using uvbackup. This utility goes through the motions of a backup without actually saving anything. This forces all file groups to be touched, thereby triggering a file corruption message if a corrupt file is encountered.

To verify a single file, provide the path to the file:

find /u2/eclipse/PRODUCT -print|uvbackup -limit 1 -f -v -notag - >/dev/null

To verify an entire database, provide the path to the live or restored database directory (i.e. /u2/eclipse, /mnt/rd1000/rsync/backup-20120130.2000/u2/eclipse):

find /u2/eclipse -print|uvbackup -limit 1 -f -v -notag - >/dev/null

References:

2 thoughts on “How do I use uvbackup to validate my database files?”

Comments are closed.