Rman Validate Database| Tablespace | Datafile command 12cR1

[oracle@srv2 ~]$ rman target /

Recovery Manager: Release 12.1.0.2.0 - Production on Mon Aug 5 12:01:07 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

connected to target database: RAC (DBID=2599942250)

RMAN> validate database;

Starting validate at 05-AUG-19
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=79 instance=rac2 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/RAC/DATAFILE/idata.269.1014653909
input datafile file number=00003 name=+DATA/RAC/DATAFILE/sysaux.257.1011959959
input datafile file number=00009 name=+DATA/RAC/DATAFILE/soetbs.273.1015005687
input datafile file number=00001 name=+DATA/RAC/DATAFILE/system.258.1011960053
input datafile file number=00004 name=+DATA/RAC/DATAFILE/undotbs1.260.1011960171
input datafile file number=00005 name=+DATA/RAC/DATAFILE/undotbs2.265.1011960859
input datafile file number=00007 name=+DATA/RAC/DATAFILE/indx.270.1014656575
input datafile file number=00008 name=+DATA/RAC/DATAFILE/ilog.271.1014656841
input datafile file number=00006 name=+DATA/RAC/DATAFILE/users.259.1011960169


channel ORA_DISK_1: validation complete, elapsed time: 00:06:05
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1    OK     0              16699        112640          16154464
  File Name: +DATA/RAC/DATAFILE/system.258.1011960053
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              69432
  Index      0              15350
  Other      0              11159

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2    OK     0              24099        307200          13862082
  File Name: +DATA/RAC/DATAFILE/idata.269.1014653909
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              132070
  Index      0              138908
  Other      0              12123

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3    OK     0              34799        198404          16154334
  File Name: +DATA/RAC/DATAFILE/sysaux.257.1011959959
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              54830
  Index      0              51824
  Other      0              56947

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4    OK     0              1            25600           16154464
  File Name: +DATA/RAC/DATAFILE/undotbs1.260.1011960171
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0
  Index      0              0
  Other      0              25599

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5    OK     0              2561         25600           16154350
  File Name: +DATA/RAC/DATAFILE/undotbs2.265.1011960859
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0
  Index      0              0
  Other      0              23039

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6    OK     0              17           642             1664810
  File Name: +DATA/RAC/DATAFILE/users.259.1011960169
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              30
  Index      0              5
  Other      0              588

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
7    OK     0              12673        12800           12728855
  File Name: +DATA/RAC/DATAFILE/indx.270.1014656575
  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
---- ------ -------------- ------------ --------------- ----------
8    OK     0              12044        12800           13860531
  File Name: +DATA/RAC/DATAFILE/ilog.271.1014656841
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              605
  Index      0              0
  Other      0              151

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
9    OK     0              7679         128896          14507773
  File Name: +DATA/RAC/DATAFILE/soetbs.273.1015005687
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              72746
  Index      0              46799
  Other      0              1672

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:03
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE       OK     0              2
Control File OK     0              1242
Finished validate at 05-AUG-19

RMAN>

RMAN> validate tablespace users;

Starting validate at 05-AUG-19
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=00006 name=+DATA/RAC/DATAFILE/users.259.1011960169
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6    OK     0              17           642             1664810
  File Name: +DATA/RAC/DATAFILE/users.259.1011960169
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              30
  Index      0              5
  Other      0              588

Finished validate at 05-AUG-19

RMAN> validate datafile '+DATA/RAC/DATAFILE/users.259.1011960169';

Starting validate at 05-AUG-19
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=00006 name=+DATA/RAC/DATAFILE/users.259.1011960169
channel ORA_DISK_1: validation complete, elapsed time: 00:00:03
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6    OK     0              17           642             1664810
  File Name: +DATA/RAC/DATAFILE/users.259.1011960169
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              30
  Index      0              5
  Other      0              588

Finished validate at 05-AUG-19

RMAN>