Checks using RMAN

You can get detailed information using PREVIEW like which files the backup set contains, which archivelogs will be used, etc…

RMAN> RESTORE DATABASE PREVIEW;
RMAN> RESTORE ARCHIVELOG ALL PREVIEW;

With VALIDATE you can be sure that you will be able to use that backup to restore your database as it reads all the files.

RMAN> RESTORE DATABASE VALIDATE;
RMAN> RESTORE ARCHIVELOG ALL VALIDATE;

Using RESTORE… PREVIEW

RESTORE DATABASE PREVIEW;
RESTORE TABLESPACE users PREVIEW;
RESTORE DATAFILE 3 PREVIEW;
RESTORE ARCHIVELOG FROM LOGSEQ 200 PREVIEW;
RESTORE ARCHIVELOG FROM TIME 'SYSDATE-7' PREVIEW;
RESTORE ARCHIVELOG FROM SCN 234546 PREVIEW;

Using RESTORE… PREVIEW SUMMARY

RESTORE DATABASE PREVIEW SUMMARY;
RESTORE TABLESPACE users PREVIEW SUMMARY;
RESTORE DATAFILE 3 PREVIEW SUMMARY;
RESTORE ARCHIVELOG FROM LOGSEQ 200 PREVIEW SUMMARY;
RESTORE ARCHIVELOG FROM TIME 'SYSDATE-7' PREVIEW SUMMARY;
RESTORE ARCHIVELOG FROM SCN 234546 PREVIEW SUMMARY;

CROSSCHECK

RMAN> CROSSCHECK backup;
RMAN> CROSSCHECK copy;
RMAN> CROSSCHECK archivelog all;
RMAN> CROSSCHECK backup of controlfile;
RMAN> CROSSCHECK backup of database;

Database check using RMAN:

RMAN> VALIDATE DATABASE;

Checking files stored in FRA:

RMAN> VALIDATE RECOVERY AREA;

RMAN reads all blocks and checks them for corruption.

If corrupted blocks are found, information about them is recorded in V$DATABASE_BLOCK_CORRUPTION

RMAN> BACKUP VALIDATE DATABASE;
RMAN> BACKUP VALIDATE DATABASE ARCHIVELOG ALL;