contents of Memory Script: { backup as copy reuse targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwdg1' auxiliary format '/u01/app/oracle/product/11.2.0/db_1/dbs/orapwdg2' targetfile '/u01/app/oracle/product/11.2.0/db_1/dbs/spfiledg1.ora' auxiliary format '/u01/app/oracle/product/11.2.0/db_1/dbs/spfiledg2.ora' ; sql clone "alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfiledg2.ora''"; } executing Memory Script

Starting backup at 16-APR-14 Finished backup at 16-APR-14

sql statement: alter system set spfile= ''/u01/app/oracle/product/11.2.0/db_1/dbs/spfiledg2.ora''

contents of Memory Script: { sql clone "alter system set core_dump_dest = ''/u01/app/oracle/diag/rdbms/dg/dg2/cdump'' comment= '''' scope=spfile"; sql clone "alter system set db_unique_name = ''dg2'' comment= '''' scope=spfile"; sql clone "alter system set db_recovery_file_dest = ''/u01/app/oracle/fast_recovery_area'' comment= '''' scope=spfile"; sql clone "alter system set DB_RECOVERY_FILE_DEST_SIZE = 4G comment= '''' scope=spfile"; sql clone "alter system set control_files = ''/u01/app/oracle/oradata/dg/control01.ctl'' comment= '''' scope=spfile"; sql clone "alter system set db_create_file_dest = ''/u01/app/oracle/oradata/dg'' comment= '''' scope=spfile"; sql clone "alter system set db_create_online_log_dest_1 = ''/u01/app/oracle/oradata/dg'' comment= '''' scope=spfile"; sql clone "alter system set log_archive_max_processes = 5 comment= '''' scope=spfile"; sql clone "alter system set fal_client = ''dg2'' comment= '''' scope=spfile"; sql clone "alter system set fal_server = ''dg1'' comment= '''' scope=spfile"; sql clone "alter system set standby_file_management = ''AUTO'' comment= '''' scope=spfile"; sql clone "alter system set log_archive_config = ''dg_config=(dg1,dg2)'' comment= '''' scope=spfile"; sql clone "alter system set log_archive_dest_1 = ''location=USE_DB_RECOVERY_FILE_DEST valid_for=(all_logfiles,all_roles)'' comment= '''' scope=spfile"; sql clone "alter system set log_archive_dest_2 = ''service=dg1 lgwr sync valid_for=(online_logfiles,primary_role) db_unique_name=dg1'' comment= '''' scope=spfile"; shutdown clone immediate; startup clone nomount; } executing Memory Script

sql statement: alter system set core_dump_dest = ''/u01/app/oracle/diag/rdbms/dg/dg2/cdump'' comment= '''' scope=spfile

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

sql statement: alter system set db_recovery_file_dest = ''/u01/app/oracle/fast_recovery_area'' comment= '''' scope=spfile

sql statement: alter system set DB_RECOVERY_FILE_DEST_SIZE = 4G comment= '''' scope=spfile

sql statement: alter system set control_files = ''/u01/app/oracle/oradata/dg/control01.ctl'' comment= '''' scope=spfile

sql statement: alter system set db_create_file_dest = ''/u01/app/oracle/oradata/dg'' comment= '''' scope=spfile

sql statement: alter system set db_create_online_log_dest_1 = ''/u01/app/oracle/oradata/dg'' comment= '''' scope=spfile

sql statement: alter system set log_archive_max_processes = 5 comment= '''' scope=spfile

sql statement: alter system set fal_client = ''dg2'' comment= '''' scope=spfile

sql statement: alter system set fal_server = ''dg1'' comment= '''' scope=spfile