Cacher is the code snippet organizer for pro developers

DUPLICATE DATABASE TO dup11r2
  UNTIL TIME "TO_DATE('29-MAY-2010 14:16:42','DD-MON-YYYYHH24:MI:SS')"
  SPFILE
    set control_files='D:\dup11r2\c1.ctl'
    set db_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2'
    set log_file_name_convert='D:\Database\Ora11g2\ora11g2','d:\dup11r2'
  BACKUP LOCATION 'D:\dup11r2';