Mir Sayeed Hassan – Oracle Blog

Oracle DBA – Tips & Techniques | Learn with real-time examples

  • Translate

  • It’s Me






  • My Certificates

  • Links

    My Acclaim Certification : Credly Profile
    My Oracle ACE Pro Profile

  • Achievements

    Awarded Top 100 Oracle Blogs from Worldwide - #RANK 39
  • VISITORS COUNT

  • Verified International Academic Qualification from World Education Service (WES)

    Verified International Academic Qualification from World Education Service (WES)

  • Jobs

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

Therefore we could find any error from the above validation, In case if you identify any corruption of blocks or datafiles that need to be repaired and re-issue the backup command.

=====Hence tested and verified in our test env=====

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>