-- Title : [8i] 오라클 핫백업 스크립트
-- Reference : 웹검색
-- Key word : hot backup script online backup 핫 백업 핫백업 온라인 백업 온라인백업
********************************************************************************************/
raw device 가 아닌 파일 시스템을 테이블 스페이스를 사용하는 예입니다.
자신에게 맞게 수정해서 사용하세요..
PS. 백업 완료 후 아카이브를 3개 남기고 지우게 되어있습니다. 참고하시길...
#!/bin/ksh
# RADIUS3 ORACLE DATABASE ON-LINE(HOT) BACKUP
ORACLE_SID=RADIUS
export ORACLE_SID
ORACLE_HOME=/oracle/app/oracle/product/817
export ORACLE_HOME
DAY=`date +%y%m%d`
export DAY
echo " Begin time for Backup : `date`" > /backup/log/radius3_HOT.$DAY.log
# EACH TABLESPACE BACKUP
$ORACLE_HOME/bin/svrmgrl << EOFarch1 >> /backup/log/HOT.$DAY.log
connect internal
alter system switch logfile;
REM RADIUS TABLESPACE
alter tablespace RADIUS begin backup;
!tar -Ecvf /dev/rmt/0cn /oracle_data/Radius/radius.dbf
alter tablespace RADIUS end backup;
REM INDX TABLESPACE
alter tablespace INDX begin backup;
!tar -cvf /dev/rmt/0cn /oracle/app/oracle/oradata/RADIUS/indx01.dbf
alter tablespace INDX end backup;
REM SYSTEM TABLESPACE
alter tablespace SYSTEM begin backup;
!tar -cvf /dev/rmt/0cn /oracle/app/oracle/oradata/RADIUS/system01.dbf
alter tablespace SYSTEM end backup;
REM TOOLS TABLESPACE
alter tablespace TOOLS begin backup;
!tar -cvf /dev/rmt/0cn /oracle/app/oracle/oradata/RADIUS/tools01.dbf
alter tablespace TOOLS end backup;
REM RBS TABLESPACE
alter tablespace RBS begin backup;
!tar -cvf /dev/rmt/0cn /oracle/app/oracle/oradata/RADIUS/rbs01.dbf
alter tablespace RBS end backup;
REM TEMP TABLESPACE
alter tablespace TEMP begin backup;
!tar -cvf /dev/rmt/0cn /oracle/app/oracle/oradata/RADIUS/temp01.dbf
alter tablespace TEMP end backup;
REM USERS TABLESPACE
alter tablespace USERS begin backup;
!tar -cvf /dev/rmt/0cn /oracle/app/oracle/oradata/RADIUS/users01.dbf
alter tablespace USERS end backup;
# AFTER D/B ARCH. CHANGED, BACKUP CONTROLFILE
alter system switch logfile;
alter database backup controlfile to '/backup/controlfile/controlfile$DAY.backup';
exit
EOFarch1
#ARCHIVE LOG FILE BACKUP
echo ""
echo "============control file backup================" >>
/backup/log/HOT.$DAY.log
tar -cvf /dev/rmt/0cn /backup/controlfile/controlfile$DAY.backup >> /backup/log/HOT.$DAY.log
rm -f /tmp/archive.list
sleep 10
find /oracle_data/oracle/arch/ -ctime -3 > /tmp/archive.list
echo "============archived log list================" >> /backup/log/HOT.$DAY.log
tar -cvf /dev/rmt/0cn -I /tmp/archive.list >> /backup/log/HOT.$DAY.log
find /oracle_data/oracle/arch/ -ctime +3 |xargs rm
#THE END OF BACKUP
echo "=============================================================="
>> /backup/log/HOT.$DAY.log
echo "=============================================================="
echo " End time for Backup : `date`" >> /backup/log/HOT.$DAY.log
echo "=============================================================="