sql statement: alter system set log_archive_config = ''dg_config=(dg1,dg2)'' comment= '''' scope=spfile

sql statement: alter system set log_archive_dest_1 = ''location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles)'' comment= '''' scope=spfile

sql statement: alter system set log_archive_dest_2 = ''service=dg1 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=dg1'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started) Oracle instance started

Total System Global Area 313159680 bytes

Fixed Size 2252824 bytes Variable Size 171970536 bytes Database Buffers 134217728 bytes Redo Buffers 4718592 bytes allocated channel: ch8 channel ch8: SID=19 device type=DISK

contents of Memory Script: { backup as copy current controlfile for standby auxiliary format '/u01/app/oracle/oradata/dg/control01.ctl'; } executing Memory Script

Starting backup at 16-APR-14 channel ch1: starting datafile copy copying standby control file output file name=/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_dg1.f tag=TAG20140416T042545 RECID=19 STAMP=845007946 channel ch1: datafile copy complete, elapsed time: 00:00:03 Finished backup at 16-APR-14

contents of Memory Script: { sql clone 'alter database mount standby database'; } executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script: { set newname for clone tempfile 1 to new; switch clone tempfile all; set newname for clone datafile 1 to new; set newname for clone datafile 2 to new; set newname for clone datafile 3 to new; set newname for clone datafile 4 to new; backup as copy reuse datafile 1 auxiliary format new datafile 2 auxiliary format new datafile 3 auxiliary format new datafile 4 auxiliary format new ; sql 'alter system archive log current'; } executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_temp_%u_.tmp in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 16-APR-14 channel ch1: starting datafile copy input datafile file number=00001 name=/u01/app/oracle/oradata/dg/system01.dbf channel ch2: starting datafile copy input datafile file number=00002 name=/u01/app/oracle/oradata/dg/sysaux01.dbf channel ch3: starting datafile copy input datafile file number=00003 name=/u01/app/oracle/oradata/dg/undotbs01.dbf channel ch4: starting datafile copy input datafile file number=00004 name=/u01/app/oracle/oradata/dg/users01.dbf output file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_users_2ap5rj2m_.dbf tag=TAG20140416T042557 channel ch4: datafile copy complete, elapsed time: 00:00:07 output file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_undotbs1_29p5rj2m_.dbf tag=TAG20140416T042557 channel ch3: datafile copy complete, elapsed time: 00:00:45 output file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_sysaux_28p5rj2m_.dbf tag=TAG20140416T042557 channel ch2: datafile copy complete, elapsed time: 00:02:36 output file name=/u01/app/oracle/oradata/dg/DG2/datafile/o1_mf_system_27p5rj2m_.dbf tag=TAG20140416T042557 channel ch1: datafile copy complete, elapsed time: 00:03:16 Finished backup at 16-APR-14

sql statement: alter system archive log current