executing Memory Script

    sql statement: alter system set  db_unique_name =  ‘’stdby” comment= ”” scope=spfile

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

    sql statement: alter system set  log_file_name_convert =  ”/u01/app/oracle/oradata/orcl/”, ”/u01/app/oracle/oradata/stdby/” comment= ”” scope=spfile

    sql statement: alter system set  log_archive_dest_1 =  ”location=/u01/app/oracle/flash_recovery_area/STDBY/ valid_for=(ALL_LOGFILES,ALL_ROLES) db_unique_name=stdby” comment= ”” scope=spfile

    sql statement: alter system set  log_archive_dest_2 =  ‘’service=orcl ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=orcl” comment= ”” scope=spfile

    sql statement: alter system set  fal_client =  ‘’stdby” comment= ”” scope=spfile

    sql statement: alter system set  fal_server =  ”orcl” comment= ”” scope=spfile

    sql statement: alter system set  standby_file_management =  ”AUTO” comment= ”” scope=spfile

    sql statement: alter system set  log_archive_config =  ”dg_config=(orcl,stdby)” comment= ”” scope=spfile

    Oracle instance shut down

    connected to auxiliary database (not started)

    Oracle instance started

    Total System Global Area     422678528 bytes

    Fixed Size                     1300324 bytes

    Variable Size                121637020 bytes

    Database Buffers             293601280 bytes

    Redo Buffers                   6139904 bytes

    contents of Memory Script:

    {

    backup as copy current controlfile for standby auxiliary format  ‘/u01/app/oracle/oradata/orcl/control01.ctl’;

    sql clone ‘alter database mount standby database’;

    }

    executing Memory Script

    Starting backup at 18-APR-09

    channel d1: starting datafile copy

    copying standby control file

    output file name=/home/oracle/snapcf_orcl.f tag=TAG20090418T062548 RECID=36 STAMP=684483962

    channel d1: datafile copy complete, elapsed time: 00:00:03

    Finished backup at 18-APR-09

    sql statement: alter database mount standby database

    contents of Memory Script:

    {

    set newname for tempfile  1 to

    “/u01/app/oracle/oradata/orcl/temp01.dbf”;

    switch clone tempfile all;

    set newname for datafile  1 to

    “/u01/app/oracle/oradata/orcl/system01.dbf”;

    set newname for datafile  2 to

    “/u01/app/oracle/oradata/orcl/sysaux01.dbf”;

    set newname for datafile  3 to

    “/u01/app/oracle/oradata/orcl/undotbs01.dbf”;

    set newname for datafile  4 to

    “/u01/app/oracle/oradata/orcl/users01.dbf”;

    set newname for datafile  5 to

    “/u01/app/oracle/oradata/orcl/example01.dbf”;

    backup as copy reuse

    datafile  1 auxiliary format

    “/u01/app/oracle/oradata/orcl/system01.dbf”   datafile

    2 auxiliary format

    “/u01/app/oracle/oradata/orcl/sysaux01.dbf”   datafile

    3 auxiliary format

    “/u01/app/oracle/oradata/orcl/undotbs01.dbf”   datafile

    4 auxiliary format

    “/u01/app/oracle/oradata/orcl/users01.dbf”   datafile

    5 auxiliary format

    “/u01/app/oracle/oradata/orcl/example01.dbf”   ;

    sql ‘alter system archive log current’;

    }

    executing Memory Script

    executing command: SET NEWNAME

    renamed tempfile 1 to /u01/app/oracle/oradata/orcl/temp01.dbf in control file

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    executing command: SET NEWNAME

    Starting backup at 18-APR-09

    channel d1: starting datafile copy

    input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf

    channel d2: starting datafile copy

    input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf

    output file name=/u01/app/oracle/oradata/orcl/system01.dbf tag=TAG20090418T062611 RECID=0 STAMP=0

    channel d2: datafile copy complete, elapsed time: 00:01:15

    channel d2: starting datafile copy

    input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf

    output file name=/u01/app/oracle/oradata/orcl/sysaux01.dbf tag=TAG20090418T062611 RECID=0 STAMP=0

    channel d1: datafile copy complete, elapsed time: 00:01:54

    channel d1: starting datafile copy

    input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf

    output file name=/u01/app/oracle/oradata/orcl/example01.dbf tag=TAG20090418T062611 RECID=0 STAMP=0

    channel d1: datafile copy complete, elapsed time: 00:00:15

    channel d1: starting datafile copy

    input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf

    output file name=/u01/app/oracle/oradata/orcl/undotbs01.dbf tag=TAG20090418T062611 RECID=0 STAMP=0

    channel d2: datafile copy complete, elapsed time: 00:01:01

    output file name=/u01/app/oracle/oradata/orcl/users01.dbf tag=TAG20090418T062611 RECID=0 STAMP=0

    channel d1: datafile copy complete, elapsed time: 00:00:01

    Finished backup at 18-APR-09