oracle rman validate backup - ghdrako/doc_snipets GitHub Wiki

RMAN is completely capable of validating that your backups as well as your existing Oracle database are free of any possible logical or physical block corruption.

To validate your database’s control files, all datafiles, and SPFILE (if one exists), use the following command in RMAN:

RMAN> VALIDATE DATABASE;

The following RMAN command will validate just one datafile—in this case, one of the datafiles for the SYSTEM tablespace:

RMAN> VALIDATE DATAFILE 1;

RMAN> run
{
    allocate channel ch1 type 'SBT_TAPE';
    VALIDATE BACKUPSET <backupset_number>;
    release channel ch1;
}

Validate that datafiles or archived redo logs that have been backed up contain no logical or physical corruption:

RMAN> run {
    BACKUP VALIDATE
    CHECK LOGICAL
    DATABASE AND ARCHIVELOG ALL;
}