# Esempio duplicate DB con RMAN
#
# Si effettua collegati localmente all'istanza di destinazione (AUX)
# e connessi in remoto all'istanza sorgente (TARGET)
# L'istanza di destinazione deve essere gia' stata creata ed in MOUNT

export ORACLE_SID=DEST

rman log duplicate.log <<EOF
connect target sys/xxx@source
connect auxiliary /

run {
  allocate auxiliary channel d1 type disk;

  SET NEWNAME FOR DATABASE TO '/oradata/DEST/%b';
  SET UNTIL SEQUENCE xxxxx;

  duplicate target database to DEST
    spfile
      parameter_value_convert 'SOURCE','DEST'
      set db_name='DEST'
      set audit_file_dest='/orahome/app/dest/admin/DEST/adump'
      set control_files='/oradata/DEST/control01.ctl','/orahome/fast_recovery_area/DEST/control02.ctl'
      set db_recovery_file_dest='/orahome/fast_recovery_area'
      set db_recovery_file_dest_size='8G'
      set diagnostic_dest='/orahome/app/dest'
      set local_listener='(ADDRESS = (PROTOCOL=TCP)(HOST=test02.xenialab.it)(PORT=1521))'
      set memory_target='64G'
   LOGFILE
      GROUP 1 ('/oradata/DEST/redo01.log') SIZE 200M REUSE,
      GROUP 2 ('/oradata/DEST/redo02.log') SIZE 200M REUSE,
      GROUP 3 ('/oradata/DEST/redo03.log') SIZE 200M REUSE;
}
EOF