Mir Sayeed Hassan – Oracle Blog

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

Categories
Archives
- March 2025 (1)
- February 2025 (6)
- January 2025 (1)
- December 2024 (4)
- November 2024 (5)
- May 2024 (5)
- April 2024 (4)
- March 2024 (1)
- November 2023 (5)
- October 2023 (2)
- August 2023 (5)
- July 2023 (2)
- May 2023 (4)
- April 2023 (5)
- January 2023 (2)
- December 2022 (5)
- November 2022 (2)
- September 2022 (2)
- June 2022 (1)
- May 2022 (2)
- January 2022 (2)
- December 2021 (4)
- November 2021 (2)
- October 2021 (4)
- September 2021 (1)
- July 2021 (2)
- June 2021 (3)
- April 2021 (1)
- March 2021 (3)
- February 2021 (9)
- December 2020 (1)
- October 2020 (3)
- August 2020 (5)
- July 2020 (7)
- June 2020 (4)
- May 2020 (2)
- April 2020 (2)
- February 2020 (1)
- January 2020 (3)
- December 2019 (1)
- October 2019 (6)
- July 2019 (1)
- June 2019 (4)
- May 2019 (2)
- April 2019 (1)
- March 2019 (2)
- February 2019 (10)
- January 2019 (4)
- October 2018 (3)
- September 2018 (4)
- July 2018 (3)
- June 2018 (3)
- May 2018 (6)
- April 2018 (1)
- March 2018 (1)
- February 2018 (22)
- January 2018 (3)
- December 2017 (12)
- November 2017 (2)
- October 2017 (29)
- September 2017 (9)

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)
Jobs

Database Administrators

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=====

This entry was posted on Sunday, February 16th, 2025 at 10:45 am and is filed under RMAN. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

« How to perform the export a percentage (%) of data from the schema tables in Oracle 19C Database

How to Configure the Data Guard with Cascading Standby Database on Oracle 19C DB »