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;
Copyright GeekInterview.com
Latest Code Samples
Popular Code Samples
Related Code Samples
Oracle
