Networker Tibero tbrmgr 백업

2024. 12. 27. 17:02

위로 아래

테스트 환경

<Networker Server>
OS : RHEL 9.4
Networker Version : 19.10
hostname : hfmbkp01
ip : 192.168.1.213
Hardware : R640

<Tibero DB>
OS : Ubuntu 24.04.1
Tibero Version : 6.7.1
hostname : tibero01
ip : 192.168.1.214
TB_HOME : /home/tibero01/tibero6
TB_SID : tibero / tibero2 (멀티 인스턴스)
Hardware : R640

NFS mount :
1.     /tibero_full
2.        /tibero_incr
3.        /tibero_arch
4.        /tibero_multi

script 위치 : /nsr/scripts/
log 위치 : /nsr/scirpts/logs/

<DD9300>
OS : DDOS 7.10
hostname : dd9300Lvtek / dd9300Lvtek.Lvtek-Sonic
ip : 192.168.1.90
Hardware : DD9300
mtree :
1.     /data/col1/tibero_full (NFS)
2.        /data/col1/tibero_incr (NFS)
3.        /data/col1/tibero_arch (NFS)
4.        /data/col1/tibero_multi (NFS)
5.        /data/col1/tibero_boost (ddboost 백업용)

백업 시나리오

백업 시나리오

NetWorker 백업 명령 시작
pre command 스크립트를 통해 tbrmgr 백업 수행 (full, incr, arch)
백업본을 /tibero_full 디렉토리에 저장
NetWorker 백업으로 saveset을 /tibero_full 지정
DD9300의 tibero_boost 에 저장

Tibero DB 데이터 확인

datafile 확인
SELECT FILE_NAME FROM DBA_DATA_FILES;

총 용량 확인
SELECT SUM(bytes)/1024/1024/1024||'GB' FROM DBA_DATA_FILES;

tbrmgr 백업 pre-command 스크립트 작성

스크립트 링크 생성

백업본 저장 위치

로그 생성 위치

full 백업

#!/bin/bash
export TB_HOME=/home/tibero01/tibero6
export TB_SID=tibero
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin:$TB_HOME/client/lib:/usr/lib/x86_64-linux-gnu

LOG_DIR="/nsr/scripts/logs"
LOG_FILE="${LOG_DIR}/full_$(date +%Y%m%d).log"

echo "===== Start Time : $(date '+%Y-%m-%d %H:%M:%S') =====" > "$LOG_FILE"

/home/tibero01/tibero6/client/bin/tbrmgr backup -w -o /tibero_full >> "$LOG_FILE"

echo "===== End Time : $(date '+%Y-%m-%d %H:%M:%S') =====" >> "$LOG_FILE"

incr 백업

#!/bin/bash
export TB_HOME=/home/tibero01/tibero6
export TB_SID=tibero
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin:$TB_HOME/client/lib:/usr/lib/x86_64-linux-gnu

LOG_DIR="/nsr/scripts/logs"
LOG_FILE="${LOG_DIR}/incr_$(date +%Y%m%d).log"

echo "===== Start Time : $(date '+%Y-%m-%d %H:%M:%S') =====" > "$LOG_FILE"

/home/tibero01/tibero6/client/bin/tbrmgr backup -i -w -o /tibero_incr >> "$LOG_FILE"

echo "===== End Time : $(date '+%Y-%m-%d %H:%M:%S') =====" >> "$LOG_FILE"

exit 0

arch 백업

#!/bin/bash
export TB_HOME=/home/tibero01/tibero6
export TB_SID=tibero
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin:$TB_HOME/client/lib:/usr/lib/x86_64-linux-gnu

LOG_DIR="/nsr/scripts/logs"
LOG_FILE="${LOG_DIR}/arch_$(date +%Y%m%d).log"

echo "===== Start Time : $(date '+%Y-%m-%d %H:%M:%S') =====" > "$LOG_FILE"

/home/tibero01/tibero6/client/bin/tbrmgr backup -a -o /tibero_arch >> "$LOG_FILE"

echo "===== End Time : $(date '+%Y-%m-%d %H:%M:%S') =====" >> "$LOG_FILE"

exit 0