기술문서 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
번호 | 제목 | 날짜 | 조회 수 |
---|---|---|---|
64 | Dns 보안 | 2017.08.23 | 20211 |
63 | Sun t2000 manual | 2017.08.24 | 19965 |
62 | AD(Active Directory) | 2017.11.01 | 18595 |
61 | 한글 putty | 2017.09.13 | 12000 |
60 | win-sshfs for windows | 2017.09.13 | 7770 |
59 | HP-UX snmp 중지 설정 | 2017.09.07 | 6862 |
58 | Sun os mirror | 2017.08.24 | 3364 |
57 | HP-UX NFS 설정 | 2017.09.07 | 2952 |
56 | 패스워드및 계정 정책 설정 | 2017.08.30 | 2901 |
55 | TCP/IP Tuning parameter | 2019.03.15 | 2874 |
54 | HP-UX 유지보수 방안 | 2017.09.02 | 2310 |
53 | Veritas SFCFS 점검 방법 | 2017.08.26 | 1633 |
52 | HP-UX 서버 H/W Spec 조사 | 2017.09.07 | 1563 |
51 | TCP 프로토콜 Header 구조 | 2017.11.01 | 1554 |
» | Oracle begin end backup | 2017.08.24 | 1488 |
49 | EP Oracle WebLogic Server | 2017.08.25 | 1466 |
48 | HP-UX에서 rsyncd 를 이용한 백업 설정 | 2017.09.07 | 1365 |
47 | IBM ds3500 guide | 2017.08.24 | 815 |
46 | GeoIP 를 이용한 Apache 설정 - 국가별 접속 차단 | 2018.06.13 | 655 |
45 | HP-UX 볼륨 추가 방법 | 2017.09.07 | 653 |