Oracle Database Cold backup Unix

Code ResourceAuthor: Mohit Sharma

Difficulty Level:

Published: 20th Dec 2006 Read: 6662 times

Filed in: Oracle

Add Comment

Sponsored Links

Oracle Database Cold backup sql script to generate .sh file in Unix

Sample Code

SET Heading Off
SET Verify Off
SET FeedBack Off
SET LineSize 132
SET PageSize 1000
SET termout off
Spool /orabackup/cold_back.sh
SELECT 'sqlplus /nologging' FROM dual;
SELECT 'connect / as sysdba' FROM dual;
SELECT 'Shutdown immediate' FROM Dual;
/* Data Files */
SELECT 'cp ' || File_Name || ' /orabackup/coldbackup ' || CHR(10) ||'compress -f ' || '/orabackup/coldbackup' || '/' || SUBSTR(File_Name, INSTR(File_Name, '/', -1)+1) FROM DBA_Data_Files
/
/* Redo Log Files */
SELECT 'cp ' || Member || ' /orabackup/coldbackup ' || CHR(10) || 'compress -f ' || '/ioabackup/hotbackup' || '/' || SUBSTR(Member, INSTR(Member, '/', -1)+1) FROM V$LogFile
/
/* Control Files */
SELECT 'cp ' || name || ' /orabackup/coldbackup ' FROM V$controlfile
/
/* Init and Config Files */
SELECT 'cp $ORACLE_HOME/dbs/initioa' || '.ora /orabackup/coldbackup 'FROM Dual;
SELECT 'cp $ORACLE_HOME/dbs/configioa' || '.ora /orabackup/coldbackup ' FROM Dual;
SELECT 'sqlplus /nologging' FROM dual;
SELECT 'Startup' FROM Dual;
SELECT 'Exit' FROM dual;
SELECT 'chmod 777 /orabackup/cold_back.sh from dual;
select 'sh /orabackup/cold_back.sh' from dual;
Spool Off;