Oracle 12.2 Enterprise Edition (patches July 2018), on oracle Linux 6 (oracle VM)
From standby:
rman target sys/<pass>@prim auxiliary sys/<pass>@stdby cmdfile=/tmp/duplicate.rman
/tmp/duplicate.rman holds
duplicate target database for standby nofilenamecheck dorecover;
works for restore but not don't start recovery (known BUG 28645817 )
Workaround proposed: recover from service (1987763.1)
but it stalls on first datafile although connection to primary is fine during
recover database from service EZTESTRUIS noredo using compressed backupset;
alert_log shows:
Incremental restore complete of datafile 1 +DATASLOW/EZTESTEVER/DATAFILE/system.359.1007912199
checkpoint is 6400475
last deallocation scn is 1447582
and nothing more.
From another session I can see rman is waiting for primary:
column sid format 9999
column spid format 99999
column client_info format a25
column event format a30
column secs format 9999
SELECT SID, SPID, CLIENT_INFO, event, seconds_in_wait secs, p1, p2, p3
FROM V$PROCESS p, V$SESSION s
WHERE p.ADDR = s.PADDR
and CLIENT_INFO like 'rman channel=%'
5 /
SID SPID CLIENT_INFO EVENT SECS P1 P2
----- ------------------------ ------------------------- ------------------------------ ----- ---------- ----------
P3
----------
93 26056 rman channel=ORA_DISK_1 remote db operation 3311 1 7
0
The connection is fine as restore worked.
Any hint?
recover database from service EZTESTRUIS noredo using compressed backupset;