In Oracle RMAN there are three different ways to check Data files, Tablespaces, Archive redo logs, control files, SPFILE, Backup set pieces or even an entire pluggable database for corruption like Missing files or even for any physical or logical corruption.
- RMAN Validate command
- RMAN Backup…Validate command, and
- RMAN Restore…Validate command
VALIDATE command
VALIDATE command checks the SPFILE, CONTROL FILE, Data File, Archive Redo logs and backup set pieces for corruptions like missing file or any physical corruption.
[oracle@oracle-db-19c ~]$
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 15:57:43 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN>
RMAN> VALIDATE database;
Starting validate at 01-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=264 device type=DISK
skipping excluded pluggable database CNDBAPDB4_FRESH data files
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00001 name=/u02/oradata/CDB1/system01.dbf
input datafile file number=00003 name=/u02/oradata/CDB1/sysaux01.dbf
input datafile file number=00004 name=/u02/oradata/CDB1/undotbs01.dbf
input datafile file number=00007 name=/u02/oradata/CDB1/users01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:45
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 17842 117768 20182154
File Name: /u02/oradata/CDB1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 81461
Index 0 13341
Other 0 5116
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 18053 93449 20182154
File Name: /u02/oradata/CDB1/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 15299
Index 0 11826
Other 0 48262
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 513 37120 20182154
File Name: /u02/oradata/CDB1/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 36607
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 101 641 1252497
File Name: /u02/oradata/CDB1/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=/u02/oradata/CDB1/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u02/oradata/CDB1/pdbseed/system01.dbf
input datafile file number=00008 name=/u02/oradata/CDB1/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 7365 34560 2160784
File Name: /u02/oradata/CDB1/pdbseed/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16791
Index 0 8479
Other 0 1925
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 11081 42240 2158736
File Name: /u02/oradata/CDB1/pdbseed/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3349
Index 0 1720
Other 0 26090
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 1754 12800 2160781
File Name: /u02/oradata/CDB1/pdbseed/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11046
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00126 name=/u02/oradata/CDB1/pdb1/TBS_MAXWELL_01.dbf
input datafile file number=00010 name=/u02/oradata/CDB1/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u02/oradata/CDB1/pdb1/system01.dbf
input datafile file number=00012 name=/u02/oradata/CDB1/pdb1/users01.dbf
input datafile file number=00127 name=/u02/oradata/CDB1/pdb1/undotbs02.dbf
input datafile file number=00011 name=/u02/oradata/CDB1/pdb1/undotbs01.dbf
input datafile file number=00085 name=/u02/oradata/CDB1/pdb1/data01.dbf
input datafile file number=00163 name=/u02/oradata/CDB1/pdb1/TBS_TOOLS01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:26
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 7957 38400 20181517
File Name: /u02/oradata/CDB1/pdb1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 19086
Index 0 9325
Other 0 2032
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10 OK 0 14956 56320 20177956
File Name: /u02/oradata/CDB1/pdb1/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6679
Index 0 6648
Other 0 28037
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11 OK 0 129 21120 20181517
File Name: /u02/oradata/CDB1/pdb1/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
12 OK 0 17749 27840 20000836
File Name: /u02/oradata/CDB1/pdb1/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6574
Index 0 1233
Other 0 2284
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
85 OK 0 6273 6400 19091899
File Name: /u02/oradata/CDB1/pdb1/data01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
126 OK 0 26650 64000 19856383
File Name: /u02/oradata/CDB1/pdb1/TBS_MAXWELL_01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 30491
Index 0 5939
Other 0 920
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
127 OK 0 25463 25600 19157082
File Name: /u02/oradata/CDB1/pdb1/undotbs02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 137
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
163 OK 0 1109 1280 20030079
File Name: /u02/oradata/CDB1/pdb1/TBS_TOOLS01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 25
Index 0 3
Other 0 143
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00014 name=/u02/oradata/CDB1/pdb2/sysaux01.dbf
input datafile file number=00013 name=/u02/oradata/CDB1/pdb2/system01.dbf
input datafile file number=00016 name=/u02/oradata/CDB1/pdb2/users01.dbf
input datafile file number=00015 name=/u02/oradata/CDB1/pdb2/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:25
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
13 OK 0 7860 37120 20181668
File Name: /u02/oradata/CDB1/pdb2/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 18213
Index 0 9015
Other 0 2032
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14 OK 0 14986 55040 20177976
File Name: /u02/oradata/CDB1/pdb2/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6474
Index 0 6151
Other 0 27429
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15 OK 0 129 21120 20181668
File Name: /u02/oradata/CDB1/pdb2/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
16 OK 0 17749 27840 19834863
File Name: /u02/oradata/CDB1/pdb2/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6592
Index 0 1230
Other 0 2269
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00018 name=/u02/oradata/CDB1/cndbapdb/sysaux01.dbf
input datafile file number=00017 name=/u02/oradata/CDB1/cndbapdb/system01.dbf
input datafile file number=00020 name=/u02/oradata/CDB1/cndbapdb/cndba01.dbf
input datafile file number=00019 name=/u02/oradata/CDB1/cndbapdb/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:25
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
17 OK 0 6462 34560 18948294
File Name: /u02/oradata/CDB1/cndbapdb/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 17483
Index 0 8685
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
18 OK 0 14028 46080 18946864
File Name: /u02/oradata/CDB1/cndbapdb/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3631
Index 0 1977
Other 0 26444
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
19 OK 0 466 12800 18948291
File Name: /u02/oradata/CDB1/cndbapdb/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 12334
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
20 OK 0 19073 19200 18446975
File Name: /u02/oradata/CDB1/cndbapdb/cndba01.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=00026 name=/u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
input datafile file number=00025 name=/u02/oradata/CDB1/cndbapdb2/system01.dbf
input datafile file number=00027 name=/u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
input datafile file number=00028 name=/u02/oradata/CDB1/cndbapdb2/cndba01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:25
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
25 OK 0 7335 34560 18947269
File Name: /u02/oradata/CDB1/cndbapdb2/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16812
Index 0 8483
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
26 OK 0 13455 44800 18946799
File Name: /u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3437
Index 0 1731
Other 0 26177
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
27 OK 0 1520 12800 18947266
File Name: /u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11280
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
28 OK 0 10 17 18912875
File Name: /u02/oradata/CDB1/cndbapdb2/cndba01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 7
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00038 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_sysaux_krc75pd1_.dbf
input datafile file number=00037 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_system_krc75pcx_.dbf
input datafile file number=00040 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_cndba_krc75pd2_.dbf
input datafile file number=00039 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_undotbs1_krc75pd1_.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
---- ------ -------------- ------------ --------------- ----------
37 OK 0 7332 34560 18948165
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_system_krc75pcx_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16815
Index 0 8483
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
38 OK 0 13295 44800 18946805
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_sysaux_krc75pd1_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3497
Index 0 1731
Other 0 26277
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
39 OK 0 1538 12800 18948083
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_undotbs1_krc75pd1_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11262
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
40 OK 0 19073 19200 18446975
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_cndba_krc75pd2_.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=00058 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_sysaux_krlrcwxm_.dbf
input datafile file number=00057 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_system_krlrcwxh_.dbf
input datafile file number=00060 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_users_krlrcwxn_.dbf
input datafile file number=00059 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_undotbs1_krlrcwxn_.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:25
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
57 OK 0 7825 37120 18993168
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_system_krlrcwxh_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 18245
Index 0 9016
Other 0 2034
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
58 OK 0 14218 55040 18991839
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_sysaux_krlrcwxm_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6677
Index 0 6508
Other 0 27637
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
59 OK 0 129 21120 18991880
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_undotbs1_krlrcwxn_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
60 OK 0 17749 27840 18578052
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_users_krlrcwxn_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6592
Index 0 1230
Other 0 2269
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 1142
Finished validate at 01-FEB-23
RMAN> This command will validate all the data files of your database, Including data files of container database as well as all the pluggable databases. This will also validate the current control file and SPFILE.
VALIDATE control files
Let’s say you just want to validate the control files of your database. You can do so like this
[oracle@oracle-db-19c ~]$
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 16:04:18 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN>
RMAN> VALIDATE current controlfile;
Starting validate at 01-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=429 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current control file for validation
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
Control File OK 0 1142
Finished validate at 01-FEB-23
RMAN> VALIDATE archive logs
Similar to control file you can validate archive logs as well
[oracle@oracle-db-19c ~]$
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 16:05:29 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN> VALIDATE archivelog all;
Starting validate at 01-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=266 device type=DISK
specification does not match any archived log in the repository
validate cancelled because there are no files to validate
Finished validate at 01-FEB-23
RMAN> This command will validate all the archive redo log files.
You can combine all these three commands into one and check your database, control file and archive redo logs just by issuing only one command like this
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 16:05:29 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN>
RMAN> VAlIDATE database INCLUDE current controlfile PLUS archivelog;
Starting validate at 01-FEB-23
using channel ORA_DISK_1
specification does not match any archived log in the repository
validate cancelled because there are no files to validate
Finished validate at 01-FEB-23
Starting validate at 01-FEB-23
using channel ORA_DISK_1
skipping excluded pluggable database CNDBAPDB4_FRESH data files
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00001 name=/u02/oradata/CDB1/system01.dbf
input datafile file number=00003 name=/u02/oradata/CDB1/sysaux01.dbf
input datafile file number=00004 name=/u02/oradata/CDB1/undotbs01.dbf
input datafile file number=00007 name=/u02/oradata/CDB1/users01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:26
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 17842 117768 20183804
File Name: /u02/oradata/CDB1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 81461
Index 0 13341
Other 0 5116
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 18021 93449 20183804
File Name: /u02/oradata/CDB1/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 15333
Index 0 11861
Other 0 48225
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 513 37120 20183804
File Name: /u02/oradata/CDB1/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 36607
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 101 641 1252497
File Name: /u02/oradata/CDB1/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=/u02/oradata/CDB1/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u02/oradata/CDB1/pdbseed/system01.dbf
input datafile file number=00008 name=/u02/oradata/CDB1/pdbseed/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 7365 34560 2160784
File Name: /u02/oradata/CDB1/pdbseed/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16791
Index 0 8479
Other 0 1925
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 11081 42240 2158736
File Name: /u02/oradata/CDB1/pdbseed/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3349
Index 0 1720
Other 0 26090
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 1754 12800 2160781
File Name: /u02/oradata/CDB1/pdbseed/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11046
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00126 name=/u02/oradata/CDB1/pdb1/TBS_MAXWELL_01.dbf
input datafile file number=00010 name=/u02/oradata/CDB1/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u02/oradata/CDB1/pdb1/system01.dbf
input datafile file number=00012 name=/u02/oradata/CDB1/pdb1/users01.dbf
input datafile file number=00127 name=/u02/oradata/CDB1/pdb1/undotbs02.dbf
input datafile file number=00011 name=/u02/oradata/CDB1/pdb1/undotbs01.dbf
input datafile file number=00085 name=/u02/oradata/CDB1/pdb1/data01.dbf
input datafile file number=00163 name=/u02/oradata/CDB1/pdb1/TBS_TOOLS01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:16
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 7954 38400 20183445
File Name: /u02/oradata/CDB1/pdb1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 19086
Index 0 9328
Other 0 2032
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10 OK 0 14956 56320 20182287
File Name: /u02/oradata/CDB1/pdb1/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6679
Index 0 6648
Other 0 28037
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11 OK 0 129 21120 20183445
File Name: /u02/oradata/CDB1/pdb1/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
12 OK 0 17749 27840 20000836
File Name: /u02/oradata/CDB1/pdb1/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6574
Index 0 1233
Other 0 2284
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
85 OK 0 6273 6400 19091899
File Name: /u02/oradata/CDB1/pdb1/data01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
126 OK 0 26650 64000 19856383
File Name: /u02/oradata/CDB1/pdb1/TBS_MAXWELL_01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 30491
Index 0 5939
Other 0 920
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
127 OK 0 25463 25600 19157082
File Name: /u02/oradata/CDB1/pdb1/undotbs02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 137
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
163 OK 0 1109 1280 20030079
File Name: /u02/oradata/CDB1/pdb1/TBS_TOOLS01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 25
Index 0 3
Other 0 143
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00014 name=/u02/oradata/CDB1/pdb2/sysaux01.dbf
input datafile file number=00013 name=/u02/oradata/CDB1/pdb2/system01.dbf
input datafile file number=00016 name=/u02/oradata/CDB1/pdb2/users01.dbf
input datafile file number=00015 name=/u02/oradata/CDB1/pdb2/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
13 OK 0 7860 37120 20183541
File Name: /u02/oradata/CDB1/pdb2/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 18213
Index 0 9015
Other 0 2032
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14 OK 0 14986 55040 20182289
File Name: /u02/oradata/CDB1/pdb2/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6474
Index 0 6151
Other 0 27429
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15 OK 0 129 21120 20183541
File Name: /u02/oradata/CDB1/pdb2/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
16 OK 0 17749 27840 19834863
File Name: /u02/oradata/CDB1/pdb2/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6592
Index 0 1230
Other 0 2269
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00018 name=/u02/oradata/CDB1/cndbapdb/sysaux01.dbf
input datafile file number=00017 name=/u02/oradata/CDB1/cndbapdb/system01.dbf
input datafile file number=00020 name=/u02/oradata/CDB1/cndbapdb/cndba01.dbf
input datafile file number=00019 name=/u02/oradata/CDB1/cndbapdb/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
17 OK 0 6462 34560 18948294
File Name: /u02/oradata/CDB1/cndbapdb/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 17483
Index 0 8685
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
18 OK 0 14028 46080 18946864
File Name: /u02/oradata/CDB1/cndbapdb/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3631
Index 0 1977
Other 0 26444
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
19 OK 0 466 12800 18948291
File Name: /u02/oradata/CDB1/cndbapdb/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 12334
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
20 OK 0 19073 19200 18446975
File Name: /u02/oradata/CDB1/cndbapdb/cndba01.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=00026 name=/u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
input datafile file number=00025 name=/u02/oradata/CDB1/cndbapdb2/system01.dbf
input datafile file number=00027 name=/u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
input datafile file number=00028 name=/u02/oradata/CDB1/cndbapdb2/cndba01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
25 OK 0 7335 34560 18947269
File Name: /u02/oradata/CDB1/cndbapdb2/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16812
Index 0 8483
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
26 OK 0 13455 44800 18946799
File Name: /u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3437
Index 0 1731
Other 0 26177
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
27 OK 0 1520 12800 18947266
File Name: /u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11280
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
28 OK 0 10 17 18912875
File Name: /u02/oradata/CDB1/cndbapdb2/cndba01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 7
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00038 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_sysaux_krc75pd1_.dbf
input datafile file number=00037 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_system_krc75pcx_.dbf
input datafile file number=00040 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_cndba_krc75pd2_.dbf
input datafile file number=00039 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_undotbs1_krc75pd1_.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
37 OK 0 7332 34560 18948165
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_system_krc75pcx_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16815
Index 0 8483
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
38 OK 0 13295 44800 18946805
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_sysaux_krc75pd1_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3497
Index 0 1731
Other 0 26277
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
39 OK 0 1538 12800 18948083
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_undotbs1_krc75pd1_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11262
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
40 OK 0 19073 19200 18446975
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_cndba_krc75pd2_.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=00058 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_sysaux_krlrcwxm_.dbf
input datafile file number=00057 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_system_krlrcwxh_.dbf
input datafile file number=00060 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_users_krlrcwxn_.dbf
input datafile file number=00059 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_undotbs1_krlrcwxn_.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
57 OK 0 7825 37120 18993168
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_system_krlrcwxh_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 18245
Index 0 9016
Other 0 2034
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
58 OK 0 14218 55040 18991839
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_sysaux_krlrcwxm_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6677
Index 0 6508
Other 0 27637
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
59 OK 0 129 21120 18991880
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_undotbs1_krlrcwxn_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
60 OK 0 17749 27840 18578052
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_users_krlrcwxn_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6592
Index 0 1230
Other 0 2269
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 1142
Finished validate at 01-FEB-23
RMAN> CHECK LOGICAL clause
the command that I have showed will only check for corruptions like Missing file or Physical corruption. What if we want to check our database or control file against logical corruption. We can do that by simply including “check logical” clause with our validate command like this -
you want to check your database for Physical as well as logical corruption.
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 16:10:38 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN> VALIDATE CHECK LOGICAL database;
Starting validate at 01-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=264 device type=DISK
skipping excluded pluggable database CNDBAPDB4_FRESH data files
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00001 name=/u02/oradata/CDB1/system01.dbf
input datafile file number=00003 name=/u02/oradata/CDB1/sysaux01.dbf
input datafile file number=00004 name=/u02/oradata/CDB1/undotbs01.dbf
input datafile file number=00007 name=/u02/oradata/CDB1/users01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:07
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 17842 117768 20184056
File Name: /u02/oradata/CDB1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 81461
Index 0 13341
Other 0 5116
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 18021 93449 20184056
File Name: /u02/oradata/CDB1/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 15333
Index 0 11861
Other 0 48225
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 513 37120 20184056
File Name: /u02/oradata/CDB1/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 36607
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 101 641 1252497
File Name: /u02/oradata/CDB1/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=/u02/oradata/CDB1/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u02/oradata/CDB1/pdbseed/system01.dbf
input datafile file number=00008 name=/u02/oradata/CDB1/pdbseed/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 7365 34560 2160784
File Name: /u02/oradata/CDB1/pdbseed/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16791
Index 0 8479
Other 0 1925
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 11081 42240 2158736
File Name: /u02/oradata/CDB1/pdbseed/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3349
Index 0 1720
Other 0 26090
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 1754 12800 2160781
File Name: /u02/oradata/CDB1/pdbseed/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11046
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00126 name=/u02/oradata/CDB1/pdb1/TBS_MAXWELL_01.dbf
input datafile file number=00010 name=/u02/oradata/CDB1/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u02/oradata/CDB1/pdb1/system01.dbf
input datafile file number=00012 name=/u02/oradata/CDB1/pdb1/users01.dbf
input datafile file number=00127 name=/u02/oradata/CDB1/pdb1/undotbs02.dbf
input datafile file number=00011 name=/u02/oradata/CDB1/pdb1/undotbs01.dbf
input datafile file number=00085 name=/u02/oradata/CDB1/pdb1/data01.dbf
input datafile file number=00163 name=/u02/oradata/CDB1/pdb1/TBS_TOOLS01.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 7954 38400 20183445
File Name: /u02/oradata/CDB1/pdb1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 19086
Index 0 9328
Other 0 2032
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10 OK 0 14956 56320 20182287
File Name: /u02/oradata/CDB1/pdb1/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6679
Index 0 6648
Other 0 28037
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11 OK 0 129 21120 20183445
File Name: /u02/oradata/CDB1/pdb1/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
12 OK 0 17749 27840 20000836
File Name: /u02/oradata/CDB1/pdb1/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6574
Index 0 1233
Other 0 2284
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
85 OK 0 6273 6400 19091899
File Name: /u02/oradata/CDB1/pdb1/data01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
126 OK 0 26650 64000 19856383
File Name: /u02/oradata/CDB1/pdb1/TBS_MAXWELL_01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 30491
Index 0 5939
Other 0 920
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
127 OK 0 25463 25600 19157082
File Name: /u02/oradata/CDB1/pdb1/undotbs02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 137
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
163 OK 0 1109 1280 20030079
File Name: /u02/oradata/CDB1/pdb1/TBS_TOOLS01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 25
Index 0 3
Other 0 143
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00014 name=/u02/oradata/CDB1/pdb2/sysaux01.dbf
input datafile file number=00013 name=/u02/oradata/CDB1/pdb2/system01.dbf
input datafile file number=00016 name=/u02/oradata/CDB1/pdb2/users01.dbf
input datafile file number=00015 name=/u02/oradata/CDB1/pdb2/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:07
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
13 OK 0 7860 37120 20183541
File Name: /u02/oradata/CDB1/pdb2/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 18213
Index 0 9015
Other 0 2032
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14 OK 0 14986 55040 20182289
File Name: /u02/oradata/CDB1/pdb2/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6474
Index 0 6151
Other 0 27429
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15 OK 0 129 21120 20183541
File Name: /u02/oradata/CDB1/pdb2/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
16 OK 0 17749 27840 19834863
File Name: /u02/oradata/CDB1/pdb2/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6592
Index 0 1230
Other 0 2269
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00018 name=/u02/oradata/CDB1/cndbapdb/sysaux01.dbf
input datafile file number=00017 name=/u02/oradata/CDB1/cndbapdb/system01.dbf
input datafile file number=00020 name=/u02/oradata/CDB1/cndbapdb/cndba01.dbf
input datafile file number=00019 name=/u02/oradata/CDB1/cndbapdb/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
17 OK 0 6462 34560 18948294
File Name: /u02/oradata/CDB1/cndbapdb/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 17483
Index 0 8685
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
18 OK 0 14028 46080 18946864
File Name: /u02/oradata/CDB1/cndbapdb/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3631
Index 0 1977
Other 0 26444
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
19 OK 0 466 12800 18948291
File Name: /u02/oradata/CDB1/cndbapdb/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 12334
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
20 OK 0 19073 19200 18446975
File Name: /u02/oradata/CDB1/cndbapdb/cndba01.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=00026 name=/u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
input datafile file number=00025 name=/u02/oradata/CDB1/cndbapdb2/system01.dbf
input datafile file number=00027 name=/u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
input datafile file number=00028 name=/u02/oradata/CDB1/cndbapdb2/cndba01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
25 OK 0 7335 34560 18947269
File Name: /u02/oradata/CDB1/cndbapdb2/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16812
Index 0 8483
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
26 OK 0 13455 44800 18946799
File Name: /u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3437
Index 0 1731
Other 0 26177
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
27 OK 0 1520 12800 18947266
File Name: /u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11280
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
28 OK 0 10 17 18912875
File Name: /u02/oradata/CDB1/cndbapdb2/cndba01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 7
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00038 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_sysaux_krc75pd1_.dbf
input datafile file number=00037 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_system_krc75pcx_.dbf
input datafile file number=00040 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_cndba_krc75pd2_.dbf
input datafile file number=00039 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_undotbs1_krc75pd1_.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
37 OK 0 7332 34560 18948165
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_system_krc75pcx_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16815
Index 0 8483
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
38 OK 0 13295 44800 18946805
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_sysaux_krc75pd1_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3497
Index 0 1731
Other 0 26277
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
39 OK 0 1538 12800 18948083
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_undotbs1_krc75pd1_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11262
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
40 OK 0 19073 19200 18446975
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_cndba_krc75pd2_.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=00058 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_sysaux_krlrcwxm_.dbf
input datafile file number=00057 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_system_krlrcwxh_.dbf
input datafile file number=00060 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_users_krlrcwxn_.dbf
input datafile file number=00059 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_undotbs1_krlrcwxn_.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
57 OK 0 7825 37120 18993168
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_system_krlrcwxh_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 18245
Index 0 9016
Other 0 2034
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
58 OK 0 14218 55040 18991839
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_sysaux_krlrcwxm_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6677
Index 0 6508
Other 0 27637
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
59 OK 0 129 21120 18991880
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_undotbs1_krlrcwxn_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
60 OK 0 17749 27840 18578052
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_users_krlrcwxn_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6592
Index 0 1230
Other 0 2269
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 1142
Finished validate at 01-FEB-23
RMAN> This command will check the database for missing files as well as Physical and Logical corruptions.
Similarly you can take this command
[oracle@oracle-db-19c ~]$
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 16:13:06 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN>
RMAN> VAlIDATE database INCLUDE current controlfile PLUS archivelog;
Starting validate at 01-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=429 device type=DISK
specification does not match any archived log in the repository
validate cancelled because there are no files to validate
Finished validate at 01-FEB-23
Starting validate at 01-FEB-23
using channel ORA_DISK_1
skipping excluded pluggable database CNDBAPDB4_FRESH data files
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00001 name=/u02/oradata/CDB1/system01.dbf
input datafile file number=00003 name=/u02/oradata/CDB1/sysaux01.dbf
input datafile file number=00004 name=/u02/oradata/CDB1/undotbs01.dbf
input datafile file number=00007 name=/u02/oradata/CDB1/users01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:07
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 17842 117768 20184169
File Name: /u02/oradata/CDB1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 81461
Index 0 13341
Other 0 5116
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3 OK 0 18021 93449 20184151
File Name: /u02/oradata/CDB1/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 15333
Index 0 11861
Other 0 48225
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4 OK 0 513 37120 20184169
File Name: /u02/oradata/CDB1/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 36607
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7 OK 0 101 641 1252497
File Name: /u02/oradata/CDB1/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=/u02/oradata/CDB1/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u02/oradata/CDB1/pdbseed/system01.dbf
input datafile file number=00008 name=/u02/oradata/CDB1/pdbseed/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5 OK 0 7365 34560 2160784
File Name: /u02/oradata/CDB1/pdbseed/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16791
Index 0 8479
Other 0 1925
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6 OK 0 11081 42240 2158736
File Name: /u02/oradata/CDB1/pdbseed/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3349
Index 0 1720
Other 0 26090
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
8 OK 0 1754 12800 2160781
File Name: /u02/oradata/CDB1/pdbseed/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11046
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00126 name=/u02/oradata/CDB1/pdb1/TBS_MAXWELL_01.dbf
input datafile file number=00010 name=/u02/oradata/CDB1/pdb1/sysaux01.dbf
input datafile file number=00009 name=/u02/oradata/CDB1/pdb1/system01.dbf
input datafile file number=00012 name=/u02/oradata/CDB1/pdb1/users01.dbf
input datafile file number=00127 name=/u02/oradata/CDB1/pdb1/undotbs02.dbf
input datafile file number=00011 name=/u02/oradata/CDB1/pdb1/undotbs01.dbf
input datafile file number=00085 name=/u02/oradata/CDB1/pdb1/data01.dbf
input datafile file number=00163 name=/u02/oradata/CDB1/pdb1/TBS_TOOLS01.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 7954 38400 20183445
File Name: /u02/oradata/CDB1/pdb1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 19086
Index 0 9328
Other 0 2032
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
10 OK 0 14956 56320 20182287
File Name: /u02/oradata/CDB1/pdb1/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6679
Index 0 6648
Other 0 28037
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
11 OK 0 129 21120 20183445
File Name: /u02/oradata/CDB1/pdb1/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
12 OK 0 17749 27840 20000836
File Name: /u02/oradata/CDB1/pdb1/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6574
Index 0 1233
Other 0 2284
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
85 OK 0 6273 6400 19091899
File Name: /u02/oradata/CDB1/pdb1/data01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 127
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
126 OK 0 26650 64000 19856383
File Name: /u02/oradata/CDB1/pdb1/TBS_MAXWELL_01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 30491
Index 0 5939
Other 0 920
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
127 OK 0 25463 25600 19157082
File Name: /u02/oradata/CDB1/pdb1/undotbs02.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 137
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
163 OK 0 1109 1280 20030079
File Name: /u02/oradata/CDB1/pdb1/TBS_TOOLS01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 25
Index 0 3
Other 0 143
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00014 name=/u02/oradata/CDB1/pdb2/sysaux01.dbf
input datafile file number=00013 name=/u02/oradata/CDB1/pdb2/system01.dbf
input datafile file number=00016 name=/u02/oradata/CDB1/pdb2/users01.dbf
input datafile file number=00015 name=/u02/oradata/CDB1/pdb2/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:07
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
13 OK 0 7860 37120 20183541
File Name: /u02/oradata/CDB1/pdb2/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 18213
Index 0 9015
Other 0 2032
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
14 OK 0 14986 55040 20182289
File Name: /u02/oradata/CDB1/pdb2/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6474
Index 0 6151
Other 0 27429
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
15 OK 0 129 21120 20183541
File Name: /u02/oradata/CDB1/pdb2/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
16 OK 0 17749 27840 19834863
File Name: /u02/oradata/CDB1/pdb2/users01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6592
Index 0 1230
Other 0 2269
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00018 name=/u02/oradata/CDB1/cndbapdb/sysaux01.dbf
input datafile file number=00017 name=/u02/oradata/CDB1/cndbapdb/system01.dbf
input datafile file number=00020 name=/u02/oradata/CDB1/cndbapdb/cndba01.dbf
input datafile file number=00019 name=/u02/oradata/CDB1/cndbapdb/undotbs01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
17 OK 0 6462 34560 18948294
File Name: /u02/oradata/CDB1/cndbapdb/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 17483
Index 0 8685
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
18 OK 0 14028 46080 18946864
File Name: /u02/oradata/CDB1/cndbapdb/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3631
Index 0 1977
Other 0 26444
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
19 OK 0 466 12800 18948291
File Name: /u02/oradata/CDB1/cndbapdb/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 12334
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
20 OK 0 19073 19200 18446975
File Name: /u02/oradata/CDB1/cndbapdb/cndba01.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=00026 name=/u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
input datafile file number=00025 name=/u02/oradata/CDB1/cndbapdb2/system01.dbf
input datafile file number=00027 name=/u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
input datafile file number=00028 name=/u02/oradata/CDB1/cndbapdb2/cndba01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
25 OK 0 7335 34560 18947269
File Name: /u02/oradata/CDB1/cndbapdb2/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16812
Index 0 8483
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
26 OK 0 13455 44800 18946799
File Name: /u02/oradata/CDB1/cndbapdb2/sysaux01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3437
Index 0 1731
Other 0 26177
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
27 OK 0 1520 12800 18947266
File Name: /u02/oradata/CDB1/cndbapdb2/undotbs01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11280
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
28 OK 0 10 17 18912875
File Name: /u02/oradata/CDB1/cndbapdb2/cndba01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 7
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00038 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_sysaux_krc75pd1_.dbf
input datafile file number=00037 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_system_krc75pcx_.dbf
input datafile file number=00040 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_cndba_krc75pd2_.dbf
input datafile file number=00039 name=/u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_undotbs1_krc75pd1_.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
37 OK 0 7332 34560 18948165
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_system_krc75pcx_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 16815
Index 0 8483
Other 0 1930
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
38 OK 0 13295 44800 18946805
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_sysaux_krc75pd1_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 3497
Index 0 1731
Other 0 26277
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
39 OK 0 1538 12800 18948083
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_undotbs1_krc75pd1_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 11262
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
40 OK 0 19073 19200 18446975
File Name: /u02/oradata/CDB1/EE966433CFF1B7D7E0538A08A8C04375/datafile/o1_mf_cndba_krc75pd2_.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=00058 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_sysaux_krlrcwxm_.dbf
input datafile file number=00057 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_system_krlrcwxh_.dbf
input datafile file number=00060 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_users_krlrcwxn_.dbf
input datafile file number=00059 name=/u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_undotbs1_krlrcwxn_.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
57 OK 0 7825 37120 18993168
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_system_krlrcwxh_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 18245
Index 0 9016
Other 0 2034
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
58 OK 0 14218 55040 18991839
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_sysaux_krlrcwxm_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6677
Index 0 6508
Other 0 27637
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
59 OK 0 129 21120 18991880
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_undotbs1_krlrcwxn_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 0
Index 0 0
Other 0 20991
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
60 OK 0 17749 27840 18578052
File Name: /u02/oradata/CDB1/EECFD8030E829AE2E0538A08A8C02B62/datafile/o1_mf_users_krlrcwxn_.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 6592
Index 0 1230
Other 0 2269
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 1142
Finished validate at 01-FEB-23
RMAN> And put “check logical” clause in it. After that it will also validate all the the mentioned components against missing file, physical corruption as well as logical corruption.
Few More VALIDATE commands
[oracle@oracle-db-19c ~]$ rman target sys/sys@PDB1
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 16:20:22 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1:PDB1 (DBID=2714456025)
RMAN> validate copy of database;
Starting validate at 01-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=429 device type=DISK
no copy of datafile 9 found
no copy of datafile 10 found
no copy of datafile 11 found
no copy of datafile 12 found
no copy of datafile 85 found
no copy of datafile 126 found
no copy of datafile 127 found
no copy of datafile 163 found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of validate command at 02/01/2023 16:20:33
RMAN-06587: one or more datafile copies were not found
RMAN> validate tablespace system;
Starting validate at 01-FEB-23
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00009 name=/u02/oradata/CDB1/pdb1/system01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:01
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9 OK 0 7954 38400 20185002
File Name: /u02/oradata/CDB1/pdb1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 19086
Index 0 9328
Other 0 2032
Finished validate at 01-FEB-23
RMAN> validate spfile;
Starting validate at 01-FEB-23
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of validate command at 02/01/2023 16:20:51
RMAN-07536: command not allowed when connected to a Pluggable Database
RMAN>
[oracle@oracle-db-19c ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed Feb 1 16:21:43 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: CDB1 (DBID=1093429351)
RMAN> validate copy of database;
Starting validate at 01-FEB-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=264 device type=DISK
no copy of datafile 1 found
no copy of datafile 3 found
no copy of datafile 4 found
no copy of datafile 5 found
no copy of datafile 6 found
no copy of datafile 7 found
no copy of datafile 8 found
no copy of datafile 9 found
no copy of datafile 10 found
no copy of datafile 11 found
no copy of datafile 12 found
no copy of datafile 13 found
no copy of datafile 14 found
no copy of datafile 15 found
no copy of datafile 16 found
no copy of datafile 17 found
no copy of datafile 18 found
no copy of datafile 19 found
no copy of datafile 20 found
no copy of datafile 25 found
no copy of datafile 26 found
no copy of datafile 27 found
no copy of datafile 28 found
no copy of datafile 37 found
no copy of datafile 38 found
no copy of datafile 39 found
no copy of datafile 40 found
skipping excluded pluggable database CNDBAPDB4_FRESH data files
no copy of datafile 57 found
no copy of datafile 58 found
no copy of datafile 59 found
no copy of datafile 60 found
no copy of datafile 85 found
no copy of datafile 126 found
no copy of datafile 127 found
no copy of datafile 163 found
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of validate command at 02/01/2023 16:21:51
RMAN-06587: one or more datafile copies were not found
RMAN> validate tablespace system;
Starting validate at 01-FEB-23
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00001 name=/u02/oradata/CDB1/system01.dbf
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1 OK 0 17842 117768 20185477
File Name: /u02/oradata/CDB1/system01.dbf
Block Type Blocks Failing Blocks Processed
---------- -------------- ----------------
Data 0 81461
Index 0 13341
Other 0 5116
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 1142
Finished validate at 01-FEB-23
RMAN> validate spfile;
Starting validate at 01-FEB-23
using channel ORA_DISK_1
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
including current SPFILE in backup set
channel ORA_DISK_1: validation complete, elapsed time: 00:00:00
List of Control File and SPFILE
===============================
File Type Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE OK 0 2
Finished validate at 01-FEB-23
RMAN> 
扫一扫
2350
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
