문서유형ㅣ기술정보
분야ㅣ 백업/복구
적용제품버전ㅣ 7FS02PS
문서번호ㅣ TBATI004
개요
Catalog DB 등록 해제 시 --all-incarnation 옵션 적용에 따른 차이가 존재합니다.
기본적으로 --all-incarnation 옵션이 적용되지 않을 시 현재 incarnation 정보에 대해서만 등록 해제가 진행이 되며, 등록된 데이터베이스의 모든 정보를 삭제할 경우 --all-incarnation 옵션을 추가해야 합니다.
Catalog DB 등록 해제 시 --all-incarnation 옵션 적용 유무에 따른 차이점을 설명합니다.
방법
1. Catalog register
$ tbrmgr catalog register --userid sys/tibero@tibero7_2_1 --cat-userid sys/tibero@catalog
==============================================================================
= Recovery Manager(RMGR) starts =
= =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==============================================================================
archive log check succeeded
==============================================================================
RMGR - Recovery Catalog
==============================================================================
Registration of [DB_NAME: tibero7_2_1, DB_ID: -1533411095, INCARNATION: 207925, DB_UNIQUE_NAME: tibero7_2_1] succeeded
Catalog registration ends
RMGR recovery catalog ends
2. db resetlogs로 기동
[(tibero7_2_1)jinhwa@cloudps2 tbrmgr_log]$ tbdown Tibero instance terminated (NORMAL mode). [(tibero7_2_1)jinhwa@cloudps2 tbrmgr_log]$ tbboot resetlogs Change core dump dir to /home/jinhwa/tibero7_2_1/bin/prof. Listener port = 7060 Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero instance started up (NORMAL RESETLOGS mode). [(tibero7_2_1)jinhwa@cloudps2 tbrmgr_log]$ tbdown Tibero instance terminated (NORMAL mode). [(tibero7_2_1)jinhwa@cloudps2 tbrmgr_log]$ tbboot Change core dump dir to /home/jinhwa/tibero7_2_1/bin/prof. Listener port = 7060 Tibero 7 TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. Tibero instance started up (NORMAL mode).
3. Catalog 재등록 필요 (resetlogs로 기동 시)
$ tbrmgr catalog register --userid sys/tibero@tibero7_2_1 --cat-userid sys/tibero@catalog
==============================================================================
= Recovery Manager(RMGR) starts =
= =
= TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. =
==============================================================================
archive log check succeeded
==============================================================================
RMGR - Recovery Catalog
==============================================================================
Registration of [DB_NAME: tibero7_2_1, DB_ID: -1533411095, INCARNATION: 2088341, DB_UNIQUE_NAME: tibero7_2_1] succeeded
Catalog registration ends
RMGR recovery catalog ends4. RC_DATABASE, RC_DB_INCARNATION 확인
SQL> select * from RC_DATABASE; DBID_KEY DBINC_KEY SITE_KEY DB_VER DB_NAME DB_CREATE_DATE CF_CREATE_DATE CF_VER ---------- ---------- ---------- ---------- --------------- -------------------- -------------------- --------- -1.533E+09 207925 3 7 tibero7_2_1 2024/06/14 11:02:03 2024/06/14 11:02:03 7 -1.533E+09 2088341 3 7 tibero7_2_1 2024/06/14 11:02:03 2024/06/14 11:02:03 7 2 rows selected. SQL> select * from RC_DB_INCARNATION; DBID_KEY DBINC_KEY SITE_KEY RESETLOGS_DATE PREV_RESETLOGS_TSN PREV_RESETLOGS_DATE STATUS ---------- ---------- ---------- -------------------- ------------------ -------------------- ---------- -1.533E+09 2088341 3 2025/02/06 15:26:05 207925 2024/06/19 14:18:30 0 -1.533E+09 207925 3 2024/06/19 14:18:30 174593 2024/06/18 15:48:12 1 2 rows selected.
5. --all_incarnation 옵션 없이 unregister -> 현재 incarnation만 삭제
$ tbrmgr catalog unregister --userid sys/tibero@tibero7_2_1 --cat-userid sys/tibero@catalog ============================================================================== = Recovery Manager(RMGR) starts = = = = TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. = ============================================================================== archive log check succeeded ============================================================================== RMGR - Recovery Catalog ============================================================================== Un-Registration of [DB_NAME: tibero7_2_1, DB_ID: -1533411095, INCARNATION: 2088341, DB_UNIQUE_NAME: tibero7_2_1] succeeded Catalog unregistration ends RMGR recovery catalog ends
6. RC_DATABASE, RC_DB_INCARNATION 확인
SQL> select * from RC_DATABASE; DBID_KEY DBINC_KEY SITE_KEY DB_VER DB_NAME DB_CREATE_DATE CF_CREATE_DATE CF_VER ---------- ---------- ---------- ---------- -------------------- -------------------- -------------------- ---------- -1.533E+09 207925 3 7 tibero7_2_1 2024/06/14 11:02:03 2024/06/14 11:02:03 7 1 row selected. SQL> select * from RC_DB_INCARNATION; DBID_KEY DBINC_KEY SITE_KEY RESETLOGS_DATE PREV_RESETLOGS_TSN PREV_RESETLOGS_DATE STATUS ---------- ---------- ---------- -------------------- ------------------ -------------------- ---------- -1.533E+09 207925 3 2024/06/19 14:18:30 174593 2024/06/18 15:48:12 1 1 row selected.
7. unregister → 기존 incarnation부터 현재 incarnation까지 모두 삭제 (--all-incarnation 옵션 사용)
$ tbrmgr catalog unregister --userid sys/tibero@tibero7_2_1 --cat-userid sys/tibero@catalog --all-incarnation ============================================================================== = Recovery Manager(RMGR) starts = = = = TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. = ============================================================================== archive log check succeeded ============================================================================== RMGR - Recovery Catalog ============================================================================== Un-Registration of all of [DB_NAME: tibero7_2_1, DB_ID: -1533411095, DB_UNIQUE_NAME: tibero7_2_1] succeeded Catalog unregistration ends RMGR recovery catalog ends
8. RC_DATABASE, RC_DB_INCARNATION 확인
SQL> select * from RC_DATABASE; 0 row selected. SQL> select * from RC_DB_INCARNATION; 0 row selected.