기술문서 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
번호 | 제목 | 날짜 | 조회 수 |
---|---|---|---|
20 | weblogic admin 패스워드 변경 방법 | 2021.04.06 | 60 |
19 | Tibero 접속 및 관리 | 2023.10.25 | 52 |
18 | qlogic qaucli command - HBA카드 온도체크 | 2022.07.05 | 46 |
17 | Apache Log4j 취약점및 대응방안 | 2022.02.05 | 42 |
16 | vi, vim ^M 제거 | 2021.04.02 | 39 |
15 | Jeus7 Getting Start Guide | 2021.03.09 | 38 |
14 | 2021년도 주요정보통신기반시설 기술적 취약점 분석ㆍ평가 방법 상세가이드 | 2022.06.23 | 37 |
13 | Linux system service bug gives you root on every major distro | 2022.02.05 | 35 |
12 | Red Hat Enterprise Linux technology capabilities and limits | 2021.05.13 | 31 |
11 | wmic useraccount list brief | 2021.04.01 | 29 |
10 | Tibero 관리 2 | 2023.10.25 | 24 |
9 | tibero 7 install for linux | 2023.11.06 | 21 |
8 | Jeus 8.5 설치및 운영 | 2023.10.24 | 21 |
7 | Jeus 8.5 + WebtoB 연동및 운영 | 2023.10.24 | 17 |
6 | Red Hat Enterprise Linux Certification Matrix for Dell PowerEdge Servers | 2023.11.02 | 15 |