SCRIPT FOR HOT BACKUP

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

set term off

alter database begin backup;

spool c:\dbcopy.bat
select 'copy '||name||' C:\HOTBACKUP' from v$datafile;
select 'copy '||name||' c:\HOTBACKUP' from v$tempfile;


spool off


host md c:\HOTBACKUP
host c:\dbcopy.bat

set term on

host del c:\dbcopy.bat

alter database backup controlfile to 'c:\HOTBACKUP\control.ctl';
alter database end backup;
alter system switch logfile;
prompt HOT BACKUP successfully completed.


set head on
set feedback on