RMAN> run
2> {
3> duplicate target database for standby
4>    FROM ACTIVE DATABASE
5>    DORECOVER
6>    SPFILE
7>    set db_unique_name='TMDSTB2'
8>    set fal_client='TMDSTB2'
9>    set fal_server='TMDLIVE','TMDSTBY'
10>    set log_archive_config='DG_CONFIG=(TMDLIVE,TMDSTBY,TMDSTB2)'
11>    set log_archive_dest_2='SERVICE=TMDLIVE LGWR ASYNC NOAFFIRM VALID_FOR=(ON
LINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDLIVE'
12>    set log_archive_dest_3='SERVICE=TMDSTBY LGWR ASYNC NOAFFIRM VALID_FOR=(ON
LINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDSTBY'
13>    nofilenamecheck;
14> }

Starting Duplicate Db at 19-SEP-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
current log archived

contents of Memory Script:
{
   backup as copy reuse
   targetfile  'D:\Oracle\product\12.1.0\dbhome_1\DATABASE\PWDtmdlive.ORA' auxil
iary format
 'D:\Oracle\product\12.1.0\dbhome_1\DATABASE\PWDtmdstb2.ORA'   ;
   restore clone from service  'TMDLIVE' spfile to
 'D:\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILETMDSTB2.ORA';
   sql clone "alter system set spfile= ''D:\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATAB
ASE\SPFILETMDSTB2.ORA''";
}
executing Memory Script

Starting backup at 19-SEP-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=51 device type=DISK
Finished backup at 19-SEP-16

Starting restore at 19-SEP-16
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service TMDLIVE
channel ORA_AUX_DISK_1: restoring SPFILE
output file name=D:\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATABASE\SPFILETMDSTB2.ORA
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:08
Finished restore at 19-SEP-16

sql statement: alter system set spfile= ''D:\ORACLE\PRODUCT\12.1.0\DBHOME_1\DATA
BASE\SPFILETMDSTB2.ORA''

contents of Memory Script:
{
   sql clone "alter system set  db_unique_name =
 ''TMDSTB2'' comment=
 '''' scope=spfile";
   sql clone "alter system set  fal_client =
 ''TMDSTB2'' comment=
 '''' scope=spfile";
   sql clone "alter system set  fal_server =
 ''TMDLIVE'', ''TMDSTBY'' comment=
 '''' scope=spfile";
   sql clone "alter system set  log_archive_config =
 ''DG_CONFIG=(TMDLIVE,TMDSTBY,TMDSTB2)'' comment=
 '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_2 =
 ''SERVICE=TMDLIVE LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=TMDLIVE'' comment=
 '''' scope=spfile";
   sql clone "alter system set  log_archive_dest_3 =
 ''SERVICE=TMDSTBY LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=TMDSTBY'' comment=
 '''' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_unique_name =  ''TMDSTB2'' comment= '''' sco
pe=spfile

sql statement: alter system set  fal_client =  ''TMDSTB2'' comment= '''' scope=s
pfile

sql statement: alter system set  fal_server =  ''TMDLIVE'', ''TMDSTBY'' comment=
 '''' scope=spfile

sql statement: alter system set  log_archive_config =  ''DG_CONFIG=(TMDLIVE,TMDS
TBY,TMDSTB2)'' comment= '''' scope=spfile

sql statement: alter system set  log_archive_dest_2 =  ''SERVICE=TMDLIVE LGWR AS
YNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDLIVE'' c
omment= '''' scope=spfile

sql statement: alter system set  log_archive_dest_3 =  ''SERVICE=TMDSTBY LGWR AS
YNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDSTBY'' c
omment= '''' scope=spfile

Oracle instance shut down

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 09/19/2016 10:56:03
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-04006: error from auxiliary database: ORA-03113: end-of-file on communication channel

Mon Sep 19 10:54:48 2016
ALTER SYSTEM SET log_archive_dest_3='SERVICE=TMDSTBY LGWR ASYNC NOAFFIRM VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=TMDSTBY' SCOPE=SPFILE;
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 5
alter database close
ORA-1507 signalled during: alter database close...
alter database dismount
ORA-1507 signalled during: alter database dismount...
Mon Sep 19 10:54:57 2016
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Mon Sep 19 10:54:58 2016
Stopping background process VKTM
Mon Sep 19 10:55:02 2016
Instance shutdown complete