Validate RMAN Backups

Validate Database Files

Connect to RMAN
RMAN> validate database;
RMAN> validate backupset 22;
RMAN> validate datafile 5 block 2;

Speed up Validation Process

run
{
allocate channel c1 device type disk;
allocate channel c2 device type disk;
validate database;
}

Check Physical / Logical DB Corruptions

RMAN> backup validate database archivelog all;
RMAN> backup validate check logical database archivelog all;

Validate Backups Before Restore

RMAN> restore database validate;
RMAN> restore archivelog all validate;

Was this article helpful?

Related Articles

Leave a Comment