Synchronize Database Content to New System | Teradata Business Continuity Manager - Synchronizing Database Content to a New System - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 1.01.01

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
1.01.01
Published
March 2023
Language
English (United States)
Last Update
2023-03-13
dita:mapPath
qra1653979755546.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2550
lifecycle
previous
Product Category
Analytical Ecosystem
Commands may take a long time to complete depending on the number and size of the database tables. While an individual system is being synchronized, a table-level read lock is placed on the table of the source system. This prevents any writes to the table while the table is copied.
  1. From bcmadmin, run the following command to activate a new system without activating its tables:
    bcmadmin> system activate system2 NO TABLES;
  2. Run the following command to mark all the tables in the specified database as available on the standby system:
    bcmadmin> database manage dbtest on system1, system2;
    The tables start in an Unrecoverable state on the new system.
  3. Run the following command to synchronize and activate all the tables in the specified database:
    bcmadmin> database resync dbtest from system1 to system2;