cold_backup

define 3 = &/export/hzwork/backup/
define 4 = &test

Set Heading Off
Set Verify Off
Set FeedBack Off
Set LineSize 132
Set PageSize 1000
set termout off
Spool cold_back.sql

select 'connect internal' from dual;

Select 'Startup Force' || CHR(10) ||
'Shutdown Normal' From Dual;

/* Data Files */
Select '!cp ' || File_Name || ' &&3 ' || CHR(10) ||'!compress -f ' || '&&3' || '/' || SubStr(File_Name, InStr(File_Name, '/', -1)+1) From Sys.DBA_Data_Files
/

/* Redo Log Files */
Select '!cp ' || Member || ' &&3 ' || CHR(10) || '!compress -f ' || '&&3' || '/' || SubStr(Member, InStr(Member, '/', -1)+1) From V$LogFile
/

/* Control Files */
Select '!cp ' || name || ' &&3 ' From V$controlfile
/

/* Init and Config Files */
Select '!cp $ORACLE_HOME/dbs/init&&4' || '.ora &&3 'From Dual;

Select '!cp $ORACLE_HOME/dbs/config&&4' || '.ora &&3 ' From Dual;

Select 'Startup' From Dual;
Select 'Exit' from dual;
Spool Off