Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

validate backupset

Neo-bJun 16 2015 — edited Jun 18 2015

Hello all,

I am using Oracle 11gR2.

I am taking backup of my database as below:

backup incremental level 0 device type disk tag 'LEV0' database include current controlfile plus archivelog tag 'LEV0' not backed up 2 times

In order to take another copy of the backups I am :

backup backupset from tag 'LEV0' format '/destination/backup_location'

The above statements generate the same backupset key to two different location the first to ASM disk group +FRA and the second to '/destination/backup_location'.

Let us say that the above commands created backup sets as bellow:

Backup set key           backup piece key                    Location

19173                         37470                                      +FRA....

19173                         37471                                       '/destination/backup_location'                   

When I am trying to validate backup set as below:

validate backupset 19173;

it is reading from +FRA or '/destination/backup_location'    (Randomly sometimes it reads the backup sets from +FRA sometimes from '/destination/backup_location'   )

My question is there any way to force the "validate backupset 19173;" to read from +FRA only while validating the backupsets ?

Regards,

This post has been answered by Levi Pereira on Jun 17 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 16 2015
Added on Jun 16 2015
12 comments
1,742 views