I trying to script out a database refresh process and following DOC ID 1913937.1.
Target and Destination are 12.2 on RHEL 6.4 with ASM
Duplicating njwqa to njdba from njw-devora1
Recovery Manager: Release 12.2.0.1.0 - Production on Thu Nov 30 13:25:26 2017
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database: NJWQA (DBID=2873712965)
connected to auxiliary database: NJDBA (not mounted)
RMAN>
echo set on
RMAN>
RMAN> run {
2> allocate channel p1 device type disk;
3> allocate channel p2 device type disk;
4> allocate auxiliary channel a1 device type disk;
5> allocate auxiliary channel a2 device type disk;
6> duplicate target database to njdba from active database
7> spfile
8> set control_files='+DATA','+FRA'
9> set cluster_database='false'
10> logfile
11> group 1 ('+DATA','+FRA') SIZE 50m,
12> group 2 ('+DATA','+FRA') SIZE 50m,
13> group 3 ('+DATA','+FRA') SIZE 50m
14> ;
15> release channel p1;
16> release channel p2;
17> release channel a1;
18> release channel a2;
19> }
using target database control file instead of recovery catalog
allocated channel: p1
channel p1: SID=8 instance=njwqa2 device type=DISK
allocated channel: p2
channel p2: SID=664 instance=njwqa1 device type=DISK
allocated channel: a1
channel a1: SID=220 device type=DISK
allocated channel: a2
channel a2: SID=363 device type=DISK
Starting Duplicate Db at 30-NOV-2017 13:25:45
current log archived
------- never progresses beyond this point.
There are no errors in alert logs for the source or target database.
The RMAN process in the target is RUNNING but not doing anything:
Current sql - just isn't completed - nothing blocking it- just fails to execute:
/* Formatted on 11/30/2017 2:00:43 PM (QP5 v5.318) */
SELECT MIN (MAXNC), MIN (MAXNT)
FROM ( SELECT MAX (NEXT_CHANGE#) MAXNC, MAX (NEXT_TIME) MAXNT
FROM (SELECT A.NEXT_CHANGE#, A.NEXT_TIME, A.THREAD# TNO
FROM V$ARCHIVED_LOG A,
X$KCCRT T,
V$DATABASE D,
X$KCCTIR TR
WHERE A.THREAD# = T.RTNUM
AND A.ARCHIVED = 'YES'
AND ( DECODE (BITAND (RTSTA, 67),
0, 'D',
2, 'E',
3, 'E',
66, 'I',
'U') =
'E'
AND RTNLF != 0
AND TR.INST_ID = T.INST_ID
AND TIRNUM = RTNUM
AND T.INST_ID = USERENV ('Instance'))
AND D.RESETLOGS_CHANGE# = A.RESETLOGS_CHANGE#
AND D.RESETLOGS_TIME = A.RESETLOGS_TIME
UNION
SELECT B.NEXT_CHANGE#, B.NEXT_TIME, B.THREAD# TNO
FROM V$BACKUP_REDOLOG B,
X$KCCRT T,
V$DATABASE D,
X$KCCTIR TR
WHERE B.THREAD# = T.RTNUM
AND ( DECODE (BITAND (RTSTA, 67),
0, 'D',
2, 'E',
3, 'E',
66, 'I',
'U') =
'E'
AND RTNLF != 0
AND TR.INST_ID = T.INST_ID
AND TIRNUM = RTNUM
AND T.INST_ID = USERENV ('Instance'))
AND D.RESETLOGS_CHANGE# = B.RESETLOGS_CHANGE#
AND D.RESETLOGS_TIME = B.RESETLOGS_TIME)
GROUP BY TNO)