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.
