Verify the validity of RMAN backup of oracle 11g database
[oracle@db1 ~] $rman target /
Recovery Manager: Release 11.2.0.3.0-Production on Tue Dec 12 16:08:43 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to target database: PRD (DBID=893924085)
RMAN > list backup of database
Using target database control file instead of recovery catalog
List of Backup Sets
=
BS Key Type LV Size Device Type Elapsed Time Completion Time
18552 Full 5.70G DISK 00:10:08 08-DEC-17
BP Key: 18552 Status: AVAILABLE Compressed: YES Tag: TAG20171208T230015
Piece Name: / backup/scprd1/rman/Full_SCPRD_20171208_18569.bak
List of Datafiles in backup set 18552
File LV Type Ckp SCN Ckp Time Name
6 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/sce_common.296.929901311
7 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/sce_component.298.929901313
10 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse3_data.304.929901317
17 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse10_data.318.929901327
21 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse14_data.326.929901333
25 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse18_data.334.929901339
27 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse20_data.338.929901343
30 Full 1353576289 08-DEC-17 + DATA/scprd/datafile/wmwhse16_data.392.938904035
BS Key Type LV Size Device Type Elapsed Time Completion Time
18674 Full 5.73G DISK 00:09:39 11-DEC-17
BP Key: 18674 Status: AVAILABLE Compressed: YES Tag: TAG20171211T230016
Piece Name: / backup/scprd1/rman/Full_SCPRD_20171211_18691.bak
List of Datafiles in backup set 18674
File LV Type Ckp SCN Ckp Time Name
6 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/sce_common.296.929901311
7 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/sce_component.298.929901313
10 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse3_data.304.929901317
17 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse10_data.318.929901327
21 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse14_data.326.929901333
25 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse18_data.334.929901339
27 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse20_data.338.929901343
30 Full 1363677571 11-DEC-17 + DATA/scprd/datafile/wmwhse16_data.392.938904035
RMAN > validate backupset 18674
Starting validate at 12-DEC-17
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: SID=3401 instance=SCPRD1 device type=DISK
Channel ORA_DISK_1: starting validation of datafile backup set
Channel ORA_DISK_1: reading from backup piece / backup/scprd1/rman/Full_SCPRD_20171211_18691.bak
Channel ORA_DISK_1: piece handle=/backup/scprd1/rman/Full_SCPRD_20171211_18691.bak tag=TAG20171211T230016
Channel ORA_DISK_1: restored backup piece 1
Channel ORA_DISK_1: validation complete, elapsed time: 00:11:45
Finished validate at 12-DEC-17
Only complete verification is carried out for RMAN's FULL.