문서유형ㅣ기술정보
분야ㅣ백업/복구
적용제품버전ㅣ7FS02PS
문서번호ㅣTBATI017
개요
RMGR_PRIMARY_SID파라미터를 사용하여 Standby 서버에서 RMGR(복구 관리자)을 이용해 백업하는 방안에 대해 설명합니다.
방법
1. Standby의 tbdsn.tbr에 primary 서버의 접속 정보
RMGR 연결을 위해 Primary DB의 접속 정보를 입력합니다.
$ vi $TB_HOME/client/config/tbdsn.tbr
tibero7_p=(
(INSTANCE=(HOST=192.168.179.65)
(PORT=7070)
(DB_NAME=tibero7)
)
)2. Standby의 tip 파일에 RMGR_PRIMARY_SID 파라미터 추가
해당 파라미터는 동적 적용도 가능합니다.
$ vi $TB_HOME/config/$TB_SID.tip
RMGR_PRIMARY_SID=tibero7_p #-- Standby 서버의 tbdsn.tbr에 입력한 Primary 서버의 SID 입력
$ cmrctl stop db --name tibero7_2_2 --option immediate
MSG SENDING SUCCESS!
$ cmrctl show
Resource List of Node cms
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net1 UP (private) 192.168.179.66/7550
COMMON cluster cls_standby UP inc: net1, pub: N/A
cls_standby file cls_standby:0 UP /home/rmgr1/tibero7_2_2/cm/config/cls_p_cfile_01
cls_standby file cls_standby:1 UP /home/rmgr1/tibero7_2_2/cm/config/cls_p_cfile_02
cls_standby service tibero7 DOWN Database, Active Cluster (auto-restart: OFF)
cls_standby db tibero7_2_2 DOWN tibero7, /home/rmgr1/tibero7_2_2, failed retry cnt: 0
=====================================================================
$ cmrctl start db --name tibero7_2_2 --option recovery
BOOT SUCCESS! (MODE : RECOVERY)
$ cmrctl show
Resource List of Node cms
=====================================================================
CLUSTER TYPE NAME STATUS DETAIL
----------- -------- -------------- -------- ------------------------
COMMON network net1 UP (private) 192.168.179.66/7550
COMMON cluster cls_standby UP inc: net1, pub: N/A
cls_standby file cls_standby:0 UP /home/rmgr1/tibero7_2_2/cm/config/cls_p_cfile_01
cls_standby file cls_standby:1 UP /home/rmgr1/tibero7_2_2/cm/config/cls_p_cfile_02
cls_standby service tibero7 UP Database, Active Cluster (auto-restart: OFF)
cls_standby db tibero7_2_2 UP(RECO) tibero7, /home/rmgr1/tibero7_2_2, failed retry cnt: 0
=====================================================================
3. RMGR_PRIMARY_SID 동적 적용
Standby 서버에서 RMGR_PRIMARY_SID 파라미터를 동적으로 설정합니다.
$ tbsql sys/tibero SQL> show param rmgr_primary_sid NAME TYPE VALUE ---------------------------- -------- ---------------------------------------- RMGR_PRIMARY_SID STRING SQL> alter system set RMGR_PRIMARY_SID="tibero7_p" System altered. SQL> show param rmgr_primary_sid NAME TYPE VALUE ---------------------------- -------- ---------------------------------------- RMGR_PRIMARY_SID STRING tibero7_p
4. Standby에서 RMGR을 이용한 백업 진행
$ tbrmgr backup -w -o /home/rmgr1/backup
==============================================================================
= Recovery Manager(RMGR) starts =
= =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==============================================================================
archive log check succeeded
RMGR '-o' option used
: backing up to /home/rmgr1/backup
==============================================================================
RMGR - Backup (FULL)
==============================================================================
Initializing the backup progress, it may take few minutes...
BACKUP (set_id: 1, ts_id: 0, df_id: 0)
100.0% |===============================>| 14080/14080 blks 0.00s
Synchronizing...
BACKUP (set_id: 1, ts_id: 1, df_id: 1)
100.0% |===============================>| 25600/25600 blks 1.00s
Synchronizing...
BACKUP (set_id: 1, ts_id: 3, df_id: 2)
100.0% |===============================>| 12800/12800 blks 0.00s
Synchronizing...
BACKUP (set_id: 1, ts_id: 4, df_id: 3)
100.0% |===============================>| 40960/40960 blks 2.00s
Synchronizing...
Switching an online logfile...
Backing up archive logfiles...
Archivelog log-tibero-t0-r0-s10.arc (thread: 0, set_id: 1, low_tsn: 80053, next_tsn: 80086) backed up
Archive logfiles backup succeeded
Backing up the control file...
Control file backup succeeded
Database backup succeeded
RMGR backup ends
$ tbsql sys/tibero
SQL> select * from v$backup_set;
SET_ID STATUS BACKUP_TYPE BASE_SET
---------- ------------------------------------- ------------ ----------
START_TIME
--------------------------------------------------------------------------------
FINISH_TIME
--------------------------------------------------------------------------------
ELAPSED_SECONDS START_TSN FINISH_TSN RESETLOGS_TSN
--------------- ---------- ---------- -------------
BACKUP_OPTION LOGFILE_BACKUP_OPTION
------------------------------------- -------------------------------
PARTIAL_BACKUP_OPTION OUTPUT_SIZE_MB STORAGE
--------------------------------------- -------------- ---------
BACKUP_PATH
--------------------------------------------------------------------------------
1 COMPLETED FULL 0
2025/01/16 11:26:12
2025/01/16 11:26:26
14 80053 80085 0
NONE WITH_ARCHIVELOG
NONE 802 DISK
/home/rmgr1/backup
1 row selected.
$ ls -l
합계 821492
-rw-------. 1 rmgr1 rmgr1 512 1월 16 11:26 bkl_1_t0_r0_s10.arc
-rw-------. 1 rmgr1 rmgr1 115343360 1월 16 11:26 bkp_20250116_1_0_0_0
-rw-------. 1 rmgr1 rmgr1 209715200 1월 16 11:26 bkp_20250116_1_1_1_0
-rw-------. 1 rmgr1 rmgr1 104857600 1월 16 11:26 bkp_20250116_1_3_2_0
-rw-------. 1 rmgr1 rmgr1 335544320 1월 16 11:26 bkp_20250116_1_4_3_0
-rw-------. 1 rmgr1 rmgr1 75743232 1월 16 11:26 bkp_20250116_1_cf_0