How to validate Data Files, Backup Sets and Data Blocks using RMAN in oracle database?
Anonymous Answered question 26/09/2022
We can validate data files, Backup sets and data blocks of oracle database using RMAN VALIDATE command.
Example 1:
1 2 3 4 5 6 7 8 9 | RMAN> validate backupset 1; Starting validate at 26-SEP-22using channel ORA_DISK_1channel ORA_DISK_1: starting validation of datafile backup setchannel ORA_DISK_1: reading from backup piece D:\APP\ADMIN\FAST_RECOVERY_AREA\DBDB2\BACKUPSET\2022_09_26\O1_MF_NNNDF_TAG20220926T160525_KM38WQ8N_.BKPchannel ORA_DISK_1: piece handle=D:\APP\ADMIN\FAST_RECOVERY_AREA\DBDB2\BACKUPSET\2022_09_26\O1_MF_NNNDF_TAG20220926T160525_KM38WQ8N_.BKP tag=TAG20220926T160525channel ORA_DISK_1: restored backup piece 1channel ORA_DISK_1: validation complete, elapsed time: 00:00:35Finished validate at 26-SEP-22 |
You can also use the validate command to check all data files at once, as shown below:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 | RMAN> validate database; Starting validate at 26-SEP-22using channel ORA_DISK_1channel ORA_DISK_1: starting validation of datafilechannel ORA_DISK_1: specifying datafile(s) for validationinput datafile file number=00003 name=D:\APP\ADMIN\ORADATA\DBDB2\SYSAUX01.DBFinput datafile file number=00001 name=D:\APP\ADMIN\ORADATA\DBDB2\SYSTEM01.DBFinput datafile file number=00005 name=D:\APP\ADMIN\ORADATA\DBDB2\UNDOTBS01.DBFinput datafile file number=00006 name=D:\APP\ADMIN\ORADATA\DBDB2\USERS01.DBFchannel ORA_DISK_1: validation complete, elapsed time: 00:00:55channel ORA_DISK_1: starting validation of datafilechannel ORA_DISK_1: specifying datafile(s) for validationincluding current control file for validationincluding current SPFILE in backup setchannel ORA_DISK_1: validation complete, elapsed time: 00:00:01List of Control File and SPFILE===============================File Type Status Blocks Failing Blocks Examined------------ ------ -------------- ---------------SPFILE OK 0 2Control File OK 0 612Finished validate at 26-SEP-22 |
meda Changed status to publish 26/09/2022