Document Type | Technical Information
Category | Backup/Recovery
Applicable Product Version | 7FS02PS
Document Number | TBATI004
Overview
There is a difference depending on whether the --all-incarnation option is applied when unregistering the Catalog DB.
By default, if the --all-incarnation option is not applied, only the current incarnation information is unregistered. To delete all information of the registered database, you must add the --all-incarnation option.
This explains the differences depending on whether the --all-incarnation option is applied when unregistering the Catalog DB.
Method
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. Start with 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 re-registration required (when started with 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. Check 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. unregister without --all_incarnation option โ Only current incarnation deleted
$ 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. Check 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 โ Delete all from existing incarnation to current incarnation (--all-incarnation option used)
$ 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. Check RC_DATABASE, RC_DB_INCARNATION
SQL> select * from RC_DATABASE; 0 row selected. SQL> select * from RC_DB_INCARNATION; 0 row selected.