In Windows: -
set term off
set head off
set feedback off
set verify off
prompt COLD BACKUP in progress .....
spool c:\startcopy.bat
select 'copy '||name||' c:\DBBACKUP' from v$datafile;
select 'copy '||name||' c:\DBBACKUP' from v$controlfile;
select 'copy '||name||' c:\DBBACKUP' from v$tempfile;
select 'copy '||member||' c:\DBBACKUP' from v$logfile;
spool off
shutdown IMMEDIATE
host c:\startcopy.bat
startup
host del c:\startcopy.bat
prompt COLD BACKUP successfully completed.
set term on
set head on
set feedback on
set verify on
In Linux: -
set term off
set head off
set feedback off
set verify off
prompt COLD BACKUP in progress .....
spool /u01/app/oracle/startcopy.bat
select 'copy '||name||' /uo1/app/oracle/DBBACKUP' from v$datafile;
select 'copy '||name||' /u01/app/oracle/DBBACKUP' from v$controlfile;
select 'copy '||name||' /u01/app/oracle/DBBACKUP' from v$tempfile;
select 'copy '||member||' /u01/app/oracle/DBBACKUP' from v$logfile;
spool off
shutdown IMMEDIATE
host /u01/app/oracle/startcopy.bat
startup
host del /u01/app/oracle/startcopy.bat
prompt COLD BACKUP successfully completed.
set term on
set head on
set feedback on
set verify on
