Database Software

I've been digging around all the posts and have not found anything to help me debug this problem.
I have a repeatable RMAN Duplicate job (10.2.0.5) that I use to copy a production backup to an alternate host/database. Production backups are on DISK - NAS device - attached to both servers. I've run this script many times with success but I'm having this error now. The only difference is that the backup I'm trying to restore from was created with a special retention to keep it longer than the default retention policy. I am able to see the backup pieces in the catalog AND the associated archive log backups that I need for this duplilcate to work. Below is my duplicate command and output.
Notes:
- There is only 1 incarnation of my database so Note ID: 1457769.1 does not apply
- While connected to catalog, target, and aux - I was able to list and validate the backups and archivelogs needed
- The backup has a tag=BKP_FULL_PREFOLDERLOAD (backup taken: 7/7 8:45am-9:20am)
- Here are the archive logs needed for recovery:
SEQUENCE# NEXT_CHANGE# FIRST_TIME
7148 9714410514249 07/07/11 08:00:42
7149 9714410584518 07/07/11 09:30:42
7150 9714410587326 07/07/11 12:00:16

- I have debug trace output below - but not sure how to interpret it (currently digging into this)

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
run {
allocate auxiliary channel x1 type disk;
allocate auxiliary channel x2 type disk;
allocate auxiliary channel x3 type disk;
allocate auxiliary channel x4 type disk;
set until time "to_date('07/07/11 09:20:45','mm/dd/yy hh24:mi:ss')";
duplicate target database to nxg1q;
release channel x1;
release channel x2;
release channel x3;
release channel x4;
}

output:

Recovery Manager: Release 10.2.0.5.0 - Production on Wed Jul 20 03:23:32 2011

Copyright (c) 1982, 2007, Oracle. All rights reserved.

RMAN>
connected to recovery catalog database

RMAN>
connected to target database: NXG1P (DBID=3243936468)

RMAN>
connected to auxiliary database: NXG1Q (not mounted)

RMAN>
RMAN> run {
2> allocate channel d1 type disk;
3> allocate channel d2 type disk;
4> allocate channel d3 type disk;
5> allocate channel d4 type disk;
6> allocate auxiliary channel x1 type disk;
7> allocate auxiliary channel x2 type disk;
8> allocate auxiliary channel x3 type disk;
9> allocate auxiliary channel x4 type disk;
10> set until time "to_date('07/07/11 09:20:44','mm/dd/yy hh24:mi:ss')";
11> duplicate target database to nxg1q;
12> release channel d1;
13> release channel d2;
14> release channel d3;
15> release channel d4;
16> release channel x1;
17> release channel x2;
18> release channel x3;
19> release channel x4;
20> }
allocated channel: d1
channel d1: sid=292 devtype=DISK

allocated channel: d2
channel d2: sid=199 devtype=DISK

allocated channel: d3
channel d3: sid=304 devtype=DISK

allocated channel: d4
channel d4: sid=402 devtype=DISK

allocated channel: x1
channel x1: sid=155 devtype=DISK

allocated channel: x2
channel x2: sid=154 devtype=DISK

allocated channel: x3
channel x3: sid=153 devtype=DISK

allocated channel: x4
channel x4: sid=157 devtype=DISK

executing command: SET until clause

Starting Duplicate Db at 20-JUL-11

contents of Memory Script:
{
set until scn 9714410485300;
set newname for clone datafile 1 to new;
set newname for clone datafile 2 to new;
set newname for clone datafile 3 to new;
set newname for clone datafile 4 to new;
set newname for clone datafile 5 to new;
set newname for clone datafile 6 to new;
set newname for clone datafile 7 to new;
set newname for clone datafile 8 to new;
set newname for clone datafile 9 to new;
restore
check readonly
clone database
;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-JUL-11

released channel: d1
released channel: d2
released channel: d3
released channel: d4
released channel: x1
released channel: x2
released channel: x3
released channel: x4
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/20/2011 03:24:08
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of datafile 7

RMAN> **end-of-file**


^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

RMAN> list backup of datafile 7;


List of Backup Sets
===================
...
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
43770160 Incr 0 7.49G DISK 00:35:32 07-JUL-11
BP Key: 43770165 Status: AVAILABLE Compressed: YES Tag: BKP_FULL_PREFOLDERLOAD
Piece Name: /csc06porasa2_orabkup/csc06porasa2/nxg1p/nxg1p_femgqv8o_1_1
Keep: LOGS Until: 16-AUG-11
List of Datafiles in backup set 43770160
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
7 0 Incr 9714410485296 07-JUL-11 +PDATA/nxg1p/datafile/nxg_ts.527.709399199
...

RMAN> list backupset 43774674;


List of Backup Sets
===================

BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
43774674 5.62M DISK 00:00:02 07-JUL-11
BP Key: 43774679 Status: AVAILABLE Compressed: YES Tag: BKP_ARCHIVELOGS
Piece Name: /csc06porasa2_orabkup/csc06porasa2/nxg1p/nxg1p_fomgratb_1_1

List of Archived Logs in backup set 43774674
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 7150 9714410584518 07-JUL-11 9714410587326 07-JUL-11

*** Same result for other 2 archive logs

^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Here is an excerpt from the debug trace: (Notice: error 6026 and error 3015)

DBGRCVMAN: ENTERING translateSeekBpBsKey
DBGRCVMAN: translateSeekBpBsKey bskey=43770160
DBGRCVMAN: EXITING translateSeekBpBsKey got key=43770160
DBGSQL: ENTERED krmkgtbp [15:15:10.833]
DBGRCVMAN: ENTERING getBackupPiece
DBGRCVMAN: bskey = 43770160
DBGRCVMAN: next bskey=43770467
DBGRCVMAN: EXITING getBackupPiece
DBGSQL: ocirc = 0 [15:15:10.907] (krmkgtbp)
DBGRCVMAN: ENTERING getBackupPiece
DBGRCVMAN: bskey = 43770467
DBGRCVMAN: end of backupset
DBGRCVMAN: EXITING getBackupPiece no more records
DBGSQL: EXITED krmkgtbp [15:15:10.999] elapsed time [00:00:00:00.165]

DBGSQL: EXEC SQL AT RCVCAT begin dbms_rcvman . translateBpBsKeyCancel
; end ; [15:15:10.999]
DBGSQL: sqlcode=0 [15:15:11.012]
DBGMISC: krmicomp: error 6026 signalled during compilation [15:15:11.0
24]
DBGMISC: krmicomp: error 6026 signalled during compilation [15:15:11.0
24]
DBGMISC: ENTERED krmkmrsr [15:15:11.025]

DBGSQL: EXEC SQL AT TARGET select /*+ rule +*/ nvl(round(sum(MBYT
ES_PROCESSED)),0) ,nvl(round(sum(INPUT_BYTES)),0) ,nvl(round(sum(OUTPUT_BYTES)),
0) from V$RMAN_STATUS start with (RECID=:b1 and STAMP=:b2) connect by prior R
ECID=parent_recid [15:15:11.025]
DBGSQL: sqlcode=0 [15:15:11.039]
DBGSQL: :b1 = 12786
DBGSQL: :b2 = 757005295

DBGSQL: EXEC SQL at TARGET FETCH/CLOSE of prior statement [15:15:11.
053]
DBGSQL: sqlcode=0 [15:15:11.161]
DBGSQL: :b1 = 0
DBGSQL: :b2 = 0
DBGSQL: :b3 = 0

DBGSQL: EXEC SQL at TARGET FETCH/CLOSE of prior statement [15:15:11.
176]
DBGSQL: sqlcode=0 [15:15:11.176]

DBGSQL: EXEC SQL AT TARGET begin sys . dbms_backup_restore . commitR
manStatusRow ( row_id => :row_id , row_stamp => :row_stamp , mbytes => :mb , sta
tus => :status , ibytes => :ib , obytes => :ob , odevtype => :odevtype ) ; end ;
[15:15:11.189]
DBGSQL: sqlcode=0 [15:15:11.223]
DBGSQL: :b1 = 12786
DBGSQL: :b2 = 757005295
DBGSQL: :b3 = 0
DBGSQL: :b4 = 4
DBGSQL: :b5 = 0
DBGSQL: :b6 = 0
DBGSQL: :b7 = <EMPTY STRING>
DBGMISC: EXITED krmkmrsr [15:15:11.235] elapsed time [00:00:00:00.210]
DBGMISC: krmicomp: error 3015 signalled during compilation [15:15:11.2
36]
DBGMISC: ENTERED krmkmrsr [15:15:11.236]


^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Does anyone see what I'm missing or doing wrong?
Thanks!
Ann

Edited by: user2220875 on Jul 20, 2011 3:05 PM

Edited by: user2220875 on Jul 20, 2011 3:07 PM