script for cold backup

set head off
set feedback off
set term on
prompt COLD BACKUP in progress .....

set term off

spool c:\dbcopy.bat

select 'copy '||name||' c:\COLDBACKUP' from v$datafile;
select 'copy '||name||' c:\COLDBACKUP' from v$controlfile;
select 'copy '||name||' c:\COLDBACKUP' from v$tempfile;
select 'copy '||member||' c:\COLDBACKUP' from v$logfile;

spool off

shutdown IMMEDIATE
host md c:\COLDBACKUP
host c:\dbcopy.bat
startup
set term on

host del c:\dbcopy.bat
prompt COLD BACKUP successfully completed.

set head on
set feedback on