Standby 서버에서 RMGR을 이용한 백업 방안

$ vi $TB_HOME/client/config/tbdsn.tbr tibero7_p=( (INSTANCE=(HOST=192.168.179.65) (PORT=7070) (DB_NAME=tibero7) ) )

$ 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 =====================================================================

$ 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

$ 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