반응형
/********************************************************************************************
-- 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 "=============================================================="

반응형

+ Recent posts