Validate the Migrated Backups

Validate migrated backups to check for physical and logical corruption.

Use the RESTORE...VALIDATE command to validate backups. Validation checks that backups are restorable and that there is no corruption. RMAN performs a block-level check of backups and verifies that all required database files are available.

Validation does not actually restore backups and no data is written to storage. Data is streamed from Oracle Cloud Infrastructure Object Storage to your on-premise database. After validation is completed, the data is discared. Note that the validation does consume CPU, memory, and network resources to read backups and analyze them. You may incur network traffic charges for data being moved from Oracle Cloud Infrastructure Object Storage. The time taken for validation depends on the size of your backups.

To validate migrated backups:

Run the RESTORE command with the VALIDATE option.
The following command checks for physical and logical corruptions in your backups:
```
RMAN> RESTORE DATABASE VALIDATE CHECK LOGICAL;
```

Review the RMAN output to ensure that there are no errors.

The following is a sample output. Note that the output shows "new media label" while reading data from the Oracle Cloud Infrastructure bucket.

Starting restore at 24-09-2019 08:14:50
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=328 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=497 device type=DISK
allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: SID=12 device type=SBT_TAPE
channel ORA_SBT_TAPE_1: Oracle Database Backup Service Library VER=12.2.0.2

new media label is "objectstorage.us-ashburn-1..ecloud.com/n/dbcl/my_target" for piece "ORCL_1527520098_vgucjceb_1_1_20190924_1019851211"
new media label is "objectstorage.us-ashburn-1..ecloud.com/n/dbcl/my_target" for piece "ORCL_1527520098_viucjcgr_1_1_20190924_1019851291"
new media label is "objectstorage.us-ashburn-1..ecloud.com/n/dbcl/my_target" for piece "ORCL_1527520098_vhucjcfo_1_1_20190924_1019851256"
channel ORA_SBT_TAPE_1: starting validation of datafile backup set
channel ORA_SBT_TAPE_1: reading from backup piece ORCL_1527520098_vgucjceb_1_1_20190924_1019851211
channel ORA_SBT_TAPE_1: piece handle=ORCL_1527520098_vgucjceb_1_1_20190924_1019851211 tag=TAG20190924T200010
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: validation complete, elapsed time: 00:00:25
channel ORA_SBT_TAPE_1: starting validation of datafile backup set
channel ORA_SBT_TAPE_1: reading from backup piece ORCL_1527520098_vhucjcfo_1_1_20190924_1019851256
channel ORA_SBT_TAPE_1: piece handle=ORCL_1527520098_vhucjcfo_1_1_20190924_1019851256 tag=TAG20190924T200010
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: validation complete, elapsed time: 00:00:15
channel ORA_SBT_TAPE_1: starting validation of datafile backup set
channel ORA_SBT_TAPE_1: reading from backup piece ORCL_1527520098_viucjcgr_1_1_20190924_1019851291
channel ORA_SBT_TAPE_1: piece handle=ORCL_1527520098_viucjcgr_1_1_20190924_1019851291 tag=TAG20190924T200010
channel ORA_SBT_TAPE_1: restored backup piece 1
channel ORA_SBT_TAPE_1: validation complete, elapsed time: 00:00:07
Finished restore at 24-09-2019 08:15:42