Faster RMAN Validation with Section and Multiple Channel

1.Configuring the device type disk parallelism 5 and running the validate command with chunk size of 100m

$ cat rman_17.cmd
run
{
validate
section size=100m
database;
}

2.Call the script within the rman command line

$ rman target="/" @rman_17.cmd | tee -a rman_17.log

Recovery Manager: Release 11.2.0.4.0 - Production on Sat May 17 02:44:47 2014

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

connected to target database: CVRMAN (DBID=657566608)

RMAN> run
2> {
3> validate
4> section size=100m
5> database;
6> }
7>
Starting validate at 17-MAY-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=40 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=51 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=39 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=56 device type=DISK
allocated channel: ORA_DISK_5
channel ORA_DISK_5: SID=49 device type=DISK
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00006 name=+DATA/cvrman/datafile/tbs1.294.847433665
input datafile file number=00004 name=+DATA/cvrman/datafile/users.259.847354795
channel ORA_DISK_2: starting validation of datafile
channel ORA_DISK_2: specifying datafile(s) for validation
input datafile file number=00005 name=+DATA/cvrman/datafile/example.308.847525493
channel ORA_DISK_3: starting validation of datafile
channel ORA_DISK_3: specifying datafile(s) for validation
input datafile file number=00003 name=+DATA/cvrman/datafile/undotbs1.258.847354795
channel ORA_DISK_4: starting validation of datafile
channel ORA_DISK_4: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
validating blocks 1 through 12800
channel ORA_DISK_5: starting validation of datafile
channel ORA_DISK_5: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
validating blocks 1 through 12800
channel ORA_DISK_1: validation complete, elapsed time: 00:00:09
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
4    OK     0              18           667             993125
  File Name: +DATA/cvrman/datafile/users.259.847354795
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              91
  Index      0              39
  Other      0              492

File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
6    OK     0              1153         1280            1013566
  File Name: +DATA/cvrman/datafile/tbs1.294.847433665
  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=00001 name=+DATA/cvrman/datafile/system.256.847354793
validating blocks 12801 through 25600
channel ORA_DISK_2: validation complete, elapsed time: 00:00:24
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
5    OK     0              33702        44240           1112415
  File Name: +DATA/cvrman/datafile/example.308.847525493
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              6582
  Index      0              1149
  Other      0              2807

channel ORA_DISK_2: starting validation of datafile
channel ORA_DISK_2: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
validating blocks 25601 through 38400
channel ORA_DISK_3: validation complete, elapsed time: 00:00:27
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
3    OK     0              385          6400            1217652
  File Name: +DATA/cvrman/datafile/undotbs1.258.847354795
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              0
  Index      0              0
  Other      0              6015

channel ORA_DISK_3: starting validation of datafile
channel ORA_DISK_3: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
validating blocks 38401 through 51200
channel ORA_DISK_4: validation complete, elapsed time: 00:00:27
channel ORA_DISK_4: starting validation of datafile
channel ORA_DISK_4: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
validating blocks 51201 through 64000
channel ORA_DISK_5: validation complete, elapsed time: 00:00:29
channel ORA_DISK_5: starting validation of datafile
channel ORA_DISK_5: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
validating blocks 64001 through 76800
channel ORA_DISK_1: validation complete, elapsed time: 00:00:32
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
validating blocks 76801 through 89600
channel ORA_DISK_2: validation complete, elapsed time: 00:00:25
channel ORA_DISK_2: starting validation of datafile
channel ORA_DISK_2: specifying datafile(s) for validation
input datafile file number=00001 name=+DATA/cvrman/datafile/system.256.847354793
validating blocks 89601 through 96000
channel ORA_DISK_3: validation complete, elapsed time: 00:00:24
channel ORA_DISK_3: starting validation of datafile
channel ORA_DISK_3: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
validating blocks 12801 through 25600
channel ORA_DISK_4: validation complete, elapsed time: 00:00:24
channel ORA_DISK_4: starting validation of datafile
channel ORA_DISK_4: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
validating blocks 25601 through 38400
channel ORA_DISK_5: validation complete, elapsed time: 00:00:23
channel ORA_DISK_5: starting validation of datafile
channel ORA_DISK_5: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
validating blocks 38401 through 51200
channel ORA_DISK_1: validation complete, elapsed time: 00:00:22
channel ORA_DISK_1: starting validation of datafile
channel ORA_DISK_1: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
validating blocks 51201 through 64000
channel ORA_DISK_2: validation complete, elapsed time: 00:00:15
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
1    OK     0              15266        96065           1217652
  File Name: +DATA/cvrman/datafile/system.256.847354793
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              64002
  Index      0              13273
  Other      0              3452

channel ORA_DISK_2: starting validation of datafile
channel ORA_DISK_2: specifying datafile(s) for validation
input datafile file number=00002 name=+DATA/cvrman/datafile/sysaux.257.847354793
validating blocks 64001 through 70400
channel ORA_DISK_3: validation complete, elapsed time: 00:00:23
channel ORA_DISK_3: starting validation of datafile
channel ORA_DISK_3: specifying datafile(s) for validation
including current SPFILE in backup set
channel ORA_DISK_4: validation complete, elapsed time: 00:00:22
channel ORA_DISK_4: starting validation of datafile
channel ORA_DISK_4: specifying datafile(s) for validation
including current control file for validation
channel ORA_DISK_3: validation complete, elapsed time: 00:00:02
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
SPFILE       OK     0              2
channel ORA_DISK_4: validation complete, elapsed time: 00:00:01
List of Control File and SPFILE
===============================
File Type    Status Blocks Failing Blocks Examined
------------ ------ -------------- ---------------
Control File OK     0              612
channel ORA_DISK_5: validation complete, elapsed time: 00:00:23
channel ORA_DISK_1: validation complete, elapsed time: 00:00:28
channel ORA_DISK_2: validation complete, elapsed time: 00:00:25
List of Datafiles
=================
File Status Marked Corrupt Empty Blocks Blocks Examined High SCN
---- ------ -------------- ------------ --------------- ----------
2    OK     0              20096        70443           1217763
  File Name: +DATA/cvrman/datafile/sysaux.257.847354793
  Block Type Blocks Failing Blocks Processed
  ---------- -------------- ----------------
  Data       0              13891
  Index      0              10094
  Other      0              26314

Finished validate at 17-MAY-14

Recovery Manager complete.