Oracle Database Discussions

Hi guys. Lengthy post so bear with me.

Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE 9.2.0.3.0 Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

Solaris 9

We are using HP Dataprotector (Version: Data Protector A.06.00/331) for our tape backups.

I am performing a duplicate into a db (both db's running same version on same box) from a backup we took on Christmas Eve Day and am running into the following:

Duplicate command:

run
{
allocate auxiliary channel dev1 type sbt parms "SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so";
allocate auxiliary channel dev2 type sbt parms "SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so";
allocate auxiliary channel dev3 type sbt parms "SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so";
allocate auxiliary channel dev4 type sbt parms "SBT_LIBRARY=/opt/omni/lib/libob2oracle8_64bit.so";
allocate auxiliary channel dev5 type disk;
set until time "to_date('09-12-24 18:00','YY-MM-DD HH24:MI')";
duplicate target database to $ORACLE_SID;
}
exit;
!


... restores several pieces successfully before hitting the piece below and erroring...

channel dev3: starting archive log restore to default destination
channel dev1: starting archive log restore to default destination
channel dev2: starting archive log restore to default destination
channel dev3: restoring archive log
archive log thread=1 sequence=33605
channel dev4: starting archive log restore to default destination
channel dev1: restoring archive log
archive log thread=1 sequence=33606
channel dev2: restoring archive log
archive log thread=1 sequence=33607
channel dev4: restoring archive log
archive log thread=1 sequence=33608
released channel: dev5
released channel: dev1
released channel: dev2
released channel: dev3
released channel: dev4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/06/2010 18:50:23
RMAN-03015: error occurred in stored script Memory Script
ORA-19507: failed to retrieve sequential file, handle="rcworaprd-vprd2-arch<12321:706439706:1>.dbf", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, error text:
Vendor specific error: OB2_StartObjectRestoreFullName() failed ERR(-2)

RMAN>

Recovery Manager complete.

list backup shows all pieces for sequences 33605 - 33608 are avilable

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
12003 512 SBT_TAPE 00:01:47 Dec 24 2009 09:16:53
BP Key: 12003 Status: AVAILABLE Tag: TAG20091224T091506
Piece Name: rcworaprd-vprd2-arch<12321:706439706:1>.dbf

List of Archived Logs in backup set 12003
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 33606 1687141251 Dec 24 2009 09:15:02 1687141254 Dec 24 2009 09:15:05

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
12004 82M SBT_TAPE 00:01:50 Dec 24 2009 09:16:56
BP Key: 12004 Status: AVAILABLE Tag: TAG20091224T091506
Piece Name: rcworaprd-vprd2-arch<12320:706439706:1>.dbf

List of Archived Logs in backup set 12004
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 33605 1687130993 Dec 24 2009 08:15:05 1687141251 Dec 24 2009 09:15:02

BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
12005 Full 8M SBT_TAPE 00:03:40 Dec 24 2009 09:20:43
BP Key: 12005 Status: AVAILABLE Tag:
Piece Name: c-3206857493-20091224-07
SPFILE Included: Modification time: Nov 06 2009 09:26:23

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
12006 5K SBT_TAPE 00:01:49 Dec 24 2009 10:16:56
BP Key: 12006 Status: AVAILABLE Tag: TAG20091224T101507
Piece Name: rcworaprd-vprd2-arch<12324:706443307:1>.dbf

List of Archived Logs in backup set 12006
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 33608 1687148442 Dec 24 2009 10:15:03 1687148453 Dec 24 2009 10:15:05

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
12007 25M SBT_TAPE 00:01:50 Dec 24 2009 10:16:57
BP Key: 12007 Status: AVAILABLE Tag: TAG20091224T101507
Piece Name: rcworaprd-vprd2-arch<12323:706443307:1>.dbf

List of Archived Logs in backup set 12007
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- -------------------- ---------- ---------
1 33607 1687141254 Dec 24 2009 09:15:05 1687148442 Dec 24 2009 10:15:03



And I checked the tape and all of them are there as well.

The only error I see in the Tape Library log is:
OB2_ReceiveDataL: Got close on socket (ConIpcHandle: 1) (OB2_StartObjectRestoreFullName:399). Error: Details unknown.

You would think that means the connection is getting killed but I've ran it three times at three different times and it fails on the same backup piece.

Anyone run into this before or have any ideas? I have a thread open on an HP forum as well.

Any input is appreciated.

Thanks

Jamie

Edited by: Jamie CC on Jan 7, 2010 7:13 AM