DUPLICATE LOCATION UNTIL TIME

DUPLICATE target DATABASE TO 'TRGT'

UNTIL TIME "TO_DATE('03/03/2011 20:04:00','MM/DD/YYYY HH24:MI:SS')"  #after controlfile backup

SPFILE

set memory_max_target='4g'

set memory_target='4g'

set control_files='/u02/oracle/TRGT/db/apps_st/data/cntrl01.dbf','/u10/oracle/TRGT/db/apps_st/data/cntrl02.dbf'

set db_file_name_convert='/u10/oracle/SRCDB/db/apps_st/data','/u10/oracle/TRGT/db/apps_st/data','/u11/oracle/SRCDB/db/apps_st/data','/u11/oracle/TRGT/db/apps_st/data'

set log_file_name_convert='/u10/oracle/SRCDB/db/apps_st/data','/u10/oracle/TRGT/db/apps_st/data','/u11/oracle/SRCDB/db/apps_st/data','/u11/oracle/TRGT/db/apps_st/data'

set audit_file_dest='/u02/oracle/TRGT/admin/adump'

set db_recovery_file_dest='/arch/flash_recovery_area'

set diagnostic_dest='/u02/oracle/TRGT'

BACKUP LOCATION '/arch/flash_recovery_area/SRCDB';