기술문서 Oracle begin end backup
2017.08.24 01:17
스크립트 내용
cat orawork_backup.sh
#!/sbin/sh
######################################################
##
## Oracle Begin-End Backup Script By Guppy
##
#####################################################
ORACLE_SID=ORAWORK
ORACLE_USER=oracle
POLICE=workDB_oracle
SCHEDULE=full
NBU=/usr/openv/netbackup
WORK_PWD=${NBU}/scripts
TIME=`date +%Y%m%d_%H%M%S`
ARCHIVE_LOG=${WORK_PWD}/${ORACLE_SID}/ARCHIVE_DESTINATION
ARCHIVE_LOG_TMP=${WORK_PWD}/${ORACLE_SID}/ARCHIVE_DESTINATION_TMP
ARCHIVE_LOG_LIST=${WORK_PWD}/${ORACLE_SID}/ARCHIVE_LOG_LIST
DBF_LIST=${WORK_PWD}/${ORACLE_SID}/DBF_FILE
DBF_LIST_TMP=${WORK_PWD}/${ORACLE_SID}/DBF_FILE_TMP
LOG=${WORK_PWD}/${ORACLE_SID}/LOG_FILE_${TIME}
CNTL=${WORK_PWD}/${ORACLE_SID}/control.bak
su - $ORACLE_USER -c "sqlplus '/as sysdba' << EOF
select file_name from dba_data_files;
exit
EOF
" > $DBF_LIST_TMP
grep / $DBF_LIST_TMP >$DBF_LIST
su - $ORACLE_USER -c "sqlplus '/as sysdba' << EOF
archive log list;
exit
EOF
" > $ARCHIVE_LOG_TMP
grep "Archive destination" $ARCHIVE_LOG_TMP | awk '{print $3}' > $ARCHIVE_LOG
###########################################################################
su - $ORACLE_USER -c "sqlplus '/as sysdba' << EOF
alter system switch logfile;
alter database begin backup;
exit
EOF
" >> $LOG
$NBU/bin/bpbackup -p $POLICE -s $SCHEDULE -L $LOG -w -f $DBF_LIST
if [ -d $CNTL ]
then
rm -rf $CNTL
fi
su - $ORACLE_USER -c "sqlplus '/as sysdba' << EOF
alter database end backup;
alter database backup controlfile to trace;
alter database backup controlfile to '/usr/openv/netbackup/scripts/ORAWORK/control.bak' reuse;
alter system switch logfile;
select \* from v\$backup;
exit
EOF
" >> $LOG
$NBU/bin/bpbackup -p $POLICE -s $SCHEDULE -L $LOG -w $CNTL
/bin/find `cat $ARCHIVE_LOG` -mtime +25 > $ARCHIVE_LOG_LIST
$NBU/bin/bpbackup -p $POLICE -s $SCHEDULE -L $LOG -w -f $ARCHIVE_LOG_LIST
rm -rf `cat $ARCHIVE_LOG_LIST`
---------------------------------------------------------------------------
[workDB:/usr/openv/netbackup/scripts]crontab -l
# DB On-line backup
0 1 * * * /usr/openv/netbackup/scripts/orawork_backup.sh
댓글 0
번호 | 제목 | 날짜 | 조회 수 |
---|---|---|---|
50 | usage: raspistill [options] - Image parameter commands | 2018.11.16 | 1266 |
49 | 아파치 2.2.29 버젼에서 SSLProtocol 중 TLSv1.2로 설정 | 2019.02.27 | 4430 |
48 | hpux cmsnmpd daemon 중지 | 2019.02.28 | 273 |
47 | TCP/IP Tuning parameter | 2019.03.15 | 2874 |
46 | HP-UX networking - 11.31 10G NIC | 2019.03.19 | 913 |
45 | 주요정보통신기반시설 기술적 취약점 분석 평가 상세 가이드 | 2019.03.20 | 485 |
44 | 정보보호시스템 구축을 위한 실무가이드 | 2019.03.20 | 1882 |
43 | 시스템 개발·운영자를 위한 개인정보보호 가이드라인 | 2019.03.20 | 252 |
42 | 개인정보 안전성 확보조치 기준 해설서개인 정보 보호 | 2019.03.20 | 243 |
41 | Restore Database And Rename Database Files Example | 2019.03.26 | 64325 |
40 | 정보보안 국가기술자격 출제기준 개정 안내 | 2019.03.27 | 1376 |
39 | 정보보안 국가기술자격검정 최종합격자 현황 [1] | 2019.03.27 | 200 |
38 | 불필요한 HTTP Method 차단 | 2019.04.01 | 1168 |
37 | IPsec 동작모드 | 2019.09.07 | 255 |
36 | OSI (Open System Interconnection) 모델의 7개 계층구조 | 2019.09.10 | 275 |