orcl.__db_cache_size=293601280
orcl.__java_pool_size=8388608
orcl.__large_pool_size=8388608
orcl.__oracle_base='F:\app\dsharma'#ORACLE_BASE set from environment
orcl.__pga_aggregate_target=511705088
orcl.__sga_target=780140544
orcl.__shared_io_pool_size=0
orcl.__shared_pool_size=461373440
orcl.__streams_pool_size=0
*._ALLOW_RESETLOGS_CORRUPTION=TRUE
*.audit_file_dest='F:\app\dsharma\admin\stand\adump'
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='F:\app\dsharma\oradata\stand\control01.ctl','F:\app\dsharma\flash_recovery_area\stand\control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='orcl'
*.db_recovery_file_dest='F:\app\dsharma\rman_bckup'
*.db_recovery_file_dest_size=5368709120
*.diagnostic_dest='F:\app\dsharma'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orclXDB)'
*.job_queue_processes=1000
*.local_listener='LISTENER_ORCL'
*.memory_target=1288699904
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
db_unique_name=stand
db_file_name_convert='F:\app\dsharma\oradata\orcl','F:\app\dsharma\oradata\stand'
log_file_name_convert='F:\app\dsharma\oradata\orcl','F:\app\dsharma\oradata\stand'

RMAN> RUN
2> {
3> ALLOCATE AUXILIARY CHANNEL TEST1 DEVICE TYPE DISK;
4> ALLOCATE AUXILIARY CHANNEL TEST2 DEVICE TYPE DISK;
5> ALLOCATE CHANNEL ABC1 DEVICE TYPE DISK;
6> ALLOCATE CHANNEL ABC2 DEVICE TYPE DISK;
7> DUPLICATE TARGET DATABASE
8> FOR STANDBY
9> FROM ACTIVE DATABASE
10> DORECOVER
11> SPFILE
12> SET "db_unique_name"="stand"
13> SET LOG_ARCHIVE_DEST_2="SERVICE=stand ASYNC REGISTER
14> VALID FOR=(online_logfile,primary_role)"
15> SET FAL_CLIENT="stand"
16> SET FAL_SERVER="orcl"
17> NOFILENAMECHECK;
18> }

allocated channel: TEST1
channel TEST1: SID=10 device type=DISK

allocated channel: TEST2
channel TEST2: SID=135 device type=DISK

allocated channel: ABC1
channel ABC1: SID=22 device type=DISK

allocated channel: ABC2
channel ABC2: SID=125 device type=DISK

Starting Duplicate Db at 25-JUL-11

contents of Memory Script:
{
   backup as copy reuse
   targetfile  'F:\app\dsharma\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' auxiliary format
 'F:\app\dsharma\product\11.2.0\dbhome_1\DATABASE\PWDstand.ORA'   targetfile
 'F:\APP\DSHARMA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA' auxiliary format
 'F:\APP\DSHARMA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILESTAND.ORA'   ;
   sql clone "alter system set spfile= ''F:\APP\DSHARMA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILESTAND.ORA''";
}
executing Memory Script

Starting backup at 25-JUL-11
Finished backup at 25-JUL-11

sql statement: alter system set spfile= ''F:\APP\DSHARMA\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILESTAND.ORA''

contents of Memory Script:
{
   sql clone "alter system set  db_unique_name =
 ''stand'' comment=
 '''' scope=spfile";
   sql clone "alter system set  LOG_ARCHIVE_DEST_2 =
 ''SERVICE=stand ASYNC REGISTERVALID FOR=(online_logfile,primary_role)'' comment=
 '''' scope=spfile";
   sql clone "alter system set  FAL_CLIENT =
 ''stand'' comment=
 '''' scope=spfile";
   sql clone "alter system set  FAL_SERVER =
 ''orcl'' comment=
 '''' scope=spfile";
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

sql statement: alter system set  db_unique_name =  ''stand'' comment= '''' scope=spfile

sql statement: alter system set  LOG_ARCHIVE_DEST_2 =  ''SERVICE=stand ASYNC REGISTERVALID FOR=(online_logfile,primary_role)'' comment= '''' scope=spfile

sql statement: alter system set  FAL_CLIENT =  ''stand'' comment= '''' scope=spfile

sql statement: alter system set  FAL_SERVER =  ''orcl'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
released channel: ABC1
released channel: ABC2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 07/25/2011 13:05:09
RMAN-03015: error occurred in stored script Memory Script
RMAN-04014: startup failed: ORA-16025: parameter LOG_ARCHIVE_DEST_2 contains repeated or conflicting attributes

RMAN>

LOG_ARCHIVE_DEST_2 =  ''SERVICE=orcl ASYNC

LOG_ARCHIVE_DEST_1='LOCATION=F:\Oracle\flash_recovery_area\STAN\ARCHIVELOG
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=stand'

LOG_ARCHIVE_DEST_2='SERVICE=ORCL LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=orcl'

RMAN> RUN
2> {
3> ALLOCATE AUXILIARY CHANNEL TEST1 DEVICE TYPE DISK;
4> ALLOCATE AUXILIARY CHANNEL TEST2 DEVICE TYPE DISK;
5> ALLOCATE CHANNEL ABC1 DEVICE TYPE DISK;
6> ALLOCATE CHANNEL ABC2 DEVICE TYPE DISK;
7> DUPLICATE TARGET DATABASE
8> FOR STANDBY
9> FROM ACTIVE DATABASE
10> DORECOVER
11> NOFILENAMECHECK;
12> }