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