/
activate, promote

activate, promote

Owned by Vijayganesh Sivaprakasam
Nov 20, 2024
2 min read
dbvcli activate {-d|--name} CONFIGURATION_NAME [--OPTIONS] dbvcli promote {-d|--name} CONFIGURATION_NAME [--OPTIONS]

Activate the standby cluster

Option

Type

Description

Option

Type

Description

--user-script

key=val

optional script or scripts to execute after activation on primary or standby host (key must be primary or standby host; value must be an existing user script)

-bash-4.2$ ./dbvcli -d PG5433 activate Connecting to the Local Agent at :7890 ✓ A Local Agent connection can only be used for this operation if executed on the standby host: centlin72.oraclekiwi.co.nz A Local Agent connection is not available; attempting a Control Center connection. Connecting to the Control Center at centlin72.oraclekiwi.co.nz:4433 ✓ Checking available actions for this configuration ✓ Configuration PG5433 (centlin71.oraclekiwi.co.nz -> centlin72.oraclekiwi.co.nz) ┌───────────────┐┌───────────────┐ │ ││ │ │ Primary ││ Standby │ │ ││ │ │ ONLINE ││ HOT STANDBY │ │ ││ │ └───────────────┘└───────────────┘ The standby cluster will be activated after recovering all WAL records that it has received. If using WAL file shipping, any WAL backups that are available on the standby host will be applied prior to activation. Optional User Scripts 1/2 There are no scripts defined for host centlin72.oraclekiwi.co.nz Optional User Scripts 2/2 There are no scripts defined for host centlin71.oraclekiwi.co.nz Confirmation This configuration is ready for activation. Select Yes to proceed with activating the standby cluster, or No to cancel the operation. Confirm Activation: (•) Yes ( ) No 2024-11-01 14:02:59 2024-11-01 14:02:59 Preparing for activation 2024-11-01 14:02:59 Disabling Observer 2024-11-01 14:02:59 done 2024-11-01 14:02:59 Applying WAL records on standby cluster 2024-11-01 14:02:59 No WAL backups to apply 2024-11-01 14:02:59 Activating standby database 2024-11-01 14:02:59 Promoting the standby cluster... 2024-11-01 14:03:01 done 2024-11-01 14:03:01 Switching primary and standby roles 2024-11-01 14:03:01 Primary database host is now centlin72.oraclekiwi.co.nz 2024-11-01 14:03:01 Standby database host is now centlin71.oraclekiwi.co.nz 2024-11-01 14:03:01 Waiting for Agents to respond to role switch 2024-11-01 14:03:01 Task succeeded