RMAN Duplicate Database does not restore tape backups in parallel (Doc ID 419987.1)

Last updated on NOVEMBER 18, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 27-Sep-2013***


Symptoms

When peforming duplicate with multiple channels where not all pieces
are accessible from all channels duplicate might fail with piece not
found when rman schedules a piece to a channel which cannot restore it.
Here are some examples.

1) If specifying multiple channels with SBT_LIBRARY=oracle.disksbt
and these errors occur during restore, then it's likely related to
this bug:

ORA-19870: error reading backup piece 05i6l96h_1_1
ORA-19507: failed to retrieve sequential file, handle="05i6l96h_1_1", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
                  sbtpvt_open_input: file /tmp/backup_dir1/05i6l96h_1_1 does not exist or cannot
                  be accessed, errno = 2

2) If specifying multiple channels from an SBT Media device and RMAN
appears to be hung during restore then enable KRB_TRACE like so:

    configure channel...device type sbt... debug 6 trace 6;

Repeat restore and monitor for channel trace dumps.  For each channel
trace dump grep for sbt.  If no "sbtinfo" is present between "sbtinit"
and "sbtrestore" then the hanging is likely due to this bug.
It may also be possible that an error arising from backup piece not
found is thrown rather then a hung symptom.  The actual symptom may
depend on how a given SBT Media Manager handles this issue.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms