개요
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
SQL
복사
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).
SQL
복사
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 ends
SQL
복사
4.
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.
SQL
복사
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
SQL
복사
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.
SQL
복사
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
SQL
복사
8.
RC_DATABASE, RC_DB_INCARNATION 확인
SQL> select * from RC_DATABASE;
0 row selected.
SQL> select * from RC_DB_INCARNATION;
0 row selected.
SQL
복사