Document Type | Technical Information
Category | Backup/Recovery
Applicable Product Version | 7FS02PS
Document Number | TBATI015
Overview
This explains how to register managed databases in Tibero's Catalog DB.
Method
How to Register Catalog DB Connection Information
Register the Catalog DB connection information in the managed target tbdsn.tbr.
catalog=(
(INSTANCE=(HOST=192.168.179.65)
(PORT=7333)
(DB_NAME=catalog)
)
)If you are registering directly on the server where the Catalog DB is installed, you must also add the managed DB connection information to the tbdsn.tbr file of the Catalog DB.
tibero7_2_2=(
(INSTANCE=(HOST=192.168.179.65)
(PORT=7070)
(DB_NAME=tibero7)
)
)
Register Target Database in Catalog
Register the database you want to manage in the Catalog.
Execution Syntax
$tbrmgr catalog register --userid <userid>/<passwd>@<SID> --cat-userid <userid>/<passwd>@cat_sid
Execute this on the server where the target DB is installed.
$ tbrmgr catalog register --userid sys/tibero@tibero7_2_2 --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: catalog, DB_ID: 1618608202, INCARNATION: 272923, DB_UNIQUE_NAME: catalog] succeeded
Catalog registration ends
RMGR recovery catalog ends
Verify Registered DB Information in Catalog DB
Check in the Catalog DB.
SQL> select * from rc_database;
DBID_KEY DBINC_KEY SITE_KEY DB_VER
---------- ---------- ---------- ----------
DB_NAME DB_CREATE_DATE
---------------------------------------- --------------------
CF_CREATE_DATE CF_VER
-------------------- ----------
1618608202 272923 1 7
tibero7 2025/01/15 16:15:06
2025/01/15 16:15:06 7
1 row selected.
- DBID_KEY = v$database's DBID
- DBINC_KEY = v$database's RESETLOGS_TSN
- SITE_KEY= Key for distinguishing Primary, Standby (generated by SITE_KEY_SEQ)Check v$database in the registered database.
SQL> select * from v$database;
DBID NAME
---------- ----------------------------------------
DB_CREATE_DATE
--------------------------------------------------------------------------------
CF_CREATE_DATE
--------------------------------------------------------------------------------
CURRENT_TSN OPEN_MODE PROTECTION_MODE RESETLOG_TSN
----------- -------------------- --------------- ------------
RESETLOG_DATE
--------------------------------------------------------------------------------
PREV_RESETLOG_TSN
-----------------
PREV_RESETLOG_DATE
--------------------------------------------------------------------------------
DATABASE_ROLE STANDBY_BECAME_PRIMARY_TSN
----------------- --------------------------
STANDBY_BECAME_PRIMARY_DATE
--------------------------------------------------------------------------------
LOG_MODE FORCE_LOGGING CKPT_TSN
------------ ----------------- ----------
CKPT_DATE
--------------------------------------------------------------------------------
CPU_NAME PLATFORM_NAME
-------------------------------- --------------------------------
CPU_MODEL
--------------------------------------------------------------------------------
OS_UPTIME
--------------------------------------------------------------------------------
CM_OBSERVER
-----------
1618608202 tibero7
2025/01/15 16:15:06
2025/01/15 16:15:06
340941 READ WRITE UNPROTECTED 272923
2025/01/21 13:35:42
125996
2025/01/17 16:16:02
PRIMARY 315003
2025/01/22 15:53:35
ARCHIVELOG NO 315912
2025/01/22 16:32:38
X86 LINUX_X86_64
12th Gen Intel(R) Core(TM) i7-12700
09:34:34 up 1 day, 15:46, 4 users, load average: 0.00, 0.00, 0.00
DISABLED
1 row selected.
Register Multiple DBs in Catalog
Register the Catalog DB connection information in the tbdsn.tbr file on the server of the DBs to be registered.
catalog=(
(INSTANCE=(HOST=192.168.179.65)
(PORT=7333)
(DB_NAME=catalog)
)
)Run the following command on the server where the DB to be registered is installed to register it in the Catalog.
$ tbrmgr catalog register --userid sys/tibero@tibero7_2_2 --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: catalog, DB_ID: 1618608202, INCARNATION: 272923, DB_UNIQUE_NAME: catalog] succeeded
Catalog registration ends
RMGR recovery catalog ends $ 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 endsIn a TSC configuration, since the DB_NAME of Primary and Standby are the same, you must set the DB_UNIQUE_NAME parameter to register in the Catalog.
NoteThe DB_UNIQUE_NAME parameter can only be set statically.
If DB_NAME is the same, you cannot register in the Catalog, so using DB_UNIQUE_NAME is necessary.