How to validate the database files for backup purpose in Oracle 19C Database.
Posted by Mir Sayeed Hassan on February 16th, 2025
How to validate the database files for backup purpose in Oracle 19C Database.
This is to validate the database files, in case if the backup is failing due to the any corruption of datafiles or control files etc.
Issue the below command
RMAN> validate database; Starting validate at 16-FEB-25 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=3462 device type=DISK channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00003 name=/u01/app/oracle/oradata/PRITESTDB/sysaux01.dbf input datafile file number=00001 name=/u01/app/oracle/oradata/PRITESTDB/system01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/PRITESTDB/undotbs01.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/PRITESTDB/users01.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:35 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 1 OK 0 17870 120329 17147249 File Name: /u01/app/oracle/oradata/PRITESTDB/system01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 82900 Index 0 14459 Other 0 5091 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 3 OK 0 28487 168970 17148627 File Name: /u01/app/oracle/oradata/PRITESTDB/sysaux01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 41375 Index 0 54264 Other 0 44834 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 4 OK 0 385 43520 17148627 File Name: /u01/app/oracle/oradata/PRITESTDB/undotbs01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 43135 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 7 OK 0 101 641 1252497 File Name: /u01/app/oracle/oradata/PRITESTDB/users01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 60 Index 0 15 Other 0 464 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00006 name=/u01/app/oracle/oradata/PRITESTDB/pdbseed/sysaux01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/PRITESTDB/pdbseed/system01.dbf input datafile file number=00008 name=/u01/app/oracle/oradata/PRITESTDB/pdbseed/undotbs01.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:15 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 5 OK 0 7349 34560 2156049 File Name: /u01/app/oracle/oradata/PRITESTDB/pdbseed/system01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 16791 Index 0 8495 Other 0 1925 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 6 OK 0 10912 42240 2154487 File Name: /u01/app/oracle/oradata/PRITESTDB/pdbseed/sysaux01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 3349 Index 0 1736 Other 0 26243 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 8 OK 0 1807 12800 2156046 File Name: /u01/app/oracle/oradata/PRITESTDB/pdbseed/undotbs01.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 10993 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00010 name=/u01/app/oracle/oradata/PRITESTDB/29602899446D21F0E063A574A8C0D95E/datafile/o1_mf_sysaux_mozszfr3_.dbf input datafile file number=00009 name=/u01/app/oracle/oradata/PRITESTDB/29602899446D21F0E063A574A8C0D95E/datafile/o1_mf_system_mozszfq2_.dbf input datafile file number=00011 name=/u01/app/oracle/oradata/PRITESTDB/29602899446D21F0E063A574A8C0D95E/datafile/o1_mf_undotbs1_mozszfr4_.dbf input datafile file number=00015 name=/u01/app/oracle/oradata/PRITESTDB/29602899446D21F0E063A574A8C0D95E/datafile/o1_mf_test_tbs_mozw0dfo_.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:15 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 9 OK 0 6874 35840 17148709 File Name: /u01/app/oracle/oradata/PRITESTDB/29602899446D21F0E063A574A8C0D95E/datafile/o1_mf_system_mozszfq2_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 18100 Index 0 8938 Other 0 1928 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 10 OK 0 12047 48640 17148388 File Name: /u01/app/oracle/oradata/PRITESTDB/29602899446D21F0E063A574A8C0D95E/datafile/o1_mf_sysaux_mozszfr3_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 5185 Index 0 3979 Other 0 27429 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 11 OK 0 1025 12800 17148709 File Name: /u01/app/oracle/oradata/PRITESTDB/29602899446D21F0E063A574A8C0D95E/datafile/o1_mf_undotbs1_mozszfr4_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 11775 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 15 OK 0 1153 1280 2731754 File Name: /u01/app/oracle/oradata/PRITESTDB/29602899446D21F0E063A574A8C0D95E/datafile/o1_mf_test_tbs_mozw0dfo_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 127 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation input datafile file number=00013 name=/u01/app/oracle/oradata/PRITESTDB/29602899446F21F0E063A574A8C0D95E/datafile/o1_mf_sysaux_mozt0tsc_.dbf input datafile file number=00012 name=/u01/app/oracle/oradata/PRITESTDB/29602899446F21F0E063A574A8C0D95E/datafile/o1_mf_system_mozt0ts9_.dbf input datafile file number=00014 name=/u01/app/oracle/oradata/PRITESTDB/29602899446F21F0E063A574A8C0D95E/datafile/o1_mf_undotbs1_mozt0tsd_.dbf channel ORA_DISK_1: validation complete, elapsed time: 00:00:15 List of Datafiles ================= File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 12 OK 0 6884 35840 17148715 File Name: /u01/app/oracle/oradata/PRITESTDB/29602899446F21F0E063A574A8C0D95E/datafile/o1_mf_system_mozt0ts9_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 18085 Index 0 8943 Other 0 1928 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 13 OK 0 11992 48640 17148398 File Name: /u01/app/oracle/oradata/PRITESTDB/29602899446F21F0E063A574A8C0D95E/datafile/o1_mf_sysaux_mozt0tsc_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 5213 Index 0 4009 Other 0 27426 File Status Marked Corrupt Empty Blocks Blocks Examined High SCN ---- ------ -------------- ------------ --------------- ---------- 14 OK 0 1024 12800 17148715 File Name: /u01/app/oracle/oradata/PRITESTDB/29602899446F21F0E063A574A8C0D95E/datafile/o1_mf_undotbs1_mozt0tsd_.dbf Block Type Blocks Failing Blocks Processed ---------- -------------- ---------------- Data 0 0 Index 0 0 Other 0 11776 channel ORA_DISK_1: starting validation of datafile channel ORA_DISK_1: specifying datafile(s) for validation including current control file for validation including current SPFILE in backup set channel ORA_DISK_1: validation complete, elapsed time: 00:00:01 List of Control File and SPFILE =============================== File Type Status Blocks Failing Blocks Examined ------------ ------ -------------- --------------- SPFILE OK 0 2 Control File OK 0 1156 Finished validate at 16-FEB-25