create_stdby_rman_dg03.sql

[oracle@dataguard03 ~]$ rman target sys/xxxxxxx@testdg_dg02_dg auxiliary sys/xxxxxxx@testdg_dg03_dg

Recovery Manager: Release 11.2.0.3.0 - Production on Tue Dec 6 17:00:42 2016

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: TESTDG (DBID=2862720525)
connected to auxiliary database: TESTDG (not mounted)

RMAN> duplicate target database for standby dorecover nofilenamecheck;

Starting Duplicate Db at 06-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=12 device type=DISK

contents of Memory Script:
{
set until scn 1064724;
sql clone "alter system set control_files =
''+DATA/testdg_dg03/controlfile/current.267.929898065'', ''+HISTO/testdg_dg03/controlfile/current.278.929898065'' comment=
''Set by RMAN'' scope=spfile";
restore clone standby controlfile;
}
executing Memory Script

[...]

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=13
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=14
channel ORA_AUX_DISK_1: reading from backup piece /oradata/testdg_dg02/14rmq7f4_1_1
channel ORA_AUX_DISK_1: piece handle=/oradata/testdg_dg02/14rmq7f4_1_1 tag=TAG20161206T165916
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+FRA/testdg_dg03/archivelog/2016_12_06/thread_1_seq_13.261.929898087 thread=1 sequence=13
channel clone_default: deleting archived log(s)
archived log file name=+FRA/testdg_dg03/archivelog/2016_12_06/thread_1_seq_13.261.929898087 RECID=2 STAMP=929898088
archived log file name=+FRA/testdg_dg03/archivelog/2016_12_06/thread_1_seq_14.262.929898087 thread=1 sequence=14
channel clone_default: deleting archived log(s)
archived log file name=+FRA/testdg_dg03/archivelog/2016_12_06/thread_1_seq_14.262.929898087 RECID=1 STAMP=929898087
media recovery complete, elapsed time: 00:00:01
Finished recover at 06-DEC-16
Finished Duplicate Db at 06-DEC-16