Document Type | Technical Information
Category | Backup/Recovery
Applicable Product Version | 7FS02PS
Document Number | TBATI008
Overview
This explains the method for registering the Catalog DB in the TAS-TAC environment.
NoteIn the TAC environment, since all instances share the same Control file, it is sufficient to register the Catalog DB on only one instance.
Method
1. Register Catalog DB Connection Information
Register the Catalog DB connection information in tbdsn.tbr.
tac1=(
(INSTANCE=(HOST=localhost)
(PORT=8629)
(DB_NAME=tac)
)
)
#. Register Catalog DB connection information
catalog=(
(INSTANCE=(HOST=192.168.179.65)
(PORT=7333)
(DB_NAME=catalog)
)
)
2. Register to Catalog DB from tac1
$ tbrmgr catalog register --userid sys/tibero@tac1 --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: tac, DB_ID: 561512671, INCARNATION: 0, DB_UNIQUE_NAME: tac] succeeded Catalog registration ends RMGR recovery catalog ends
Caution
An error occurs if you try to register the same DB from tac2$ tbrmgr catalog register --userid sys/tibero@tac2 --cat-userid sys/tibero@catalog ============================================================================== = Recovery Manager(RMGR) starts = = = = TmaxTibero Corporation Copyright (c) 2020-. All rights reserved. = ============================================================================== archive log check succeeded RMGR Error: The database is already registered in Control File.
3. Verify Registration Information in Catalog DB
#. Check in RC_SITE_KEY table catalog [catalog] SQL> select * from rc_site_key where db_unique_name='tac'; DB_UNIQUE_NAME SITE_KEY DBID_KEY DB_ROLE ---------------------------------------- ---------- ---------- ---------- tac 8 561512671 0 1 row selected. #. Check in RC_DATABASE table catalog [catalog] SQL> select * from rc_database; DBID_KEY DBINC_KEY SITE_KEY DB_VER ---------- ---------- ---------- ---------- DB_NAME DB_CREATE_DATE ---------------------------------------- -------------------- CF_CREATE_DATE CF_VER -------------------- ---------- 561512671 0 8 7 tac 2024/08/29 16:21:29 2024/08/29 16:21:29 7 1 row selected.