Note
This view is available starting with V4.0.0.
Purpose
The DBA_OB_LS_REPLICA_TASKS view displays the ongoing disaster recovery tasks at the Replica level for the current tenant.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| LS_ID | bigint(20) | NO | The ID of the log stream. |
| TASK_TYPE | varchar(64) | NO | The type of the task. Valid values:
|
| TASK_ID | varchar(200) | NO | The ID of the task. |
| TASK_STATUS | varchar(2048) | YES | The status of the task. Valid values:
|
| PRIORITY | varchar(5) | NO | The priority of the task. Valid values:
|
| TARGET_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the server where the target replica resides. |
| TARGET_REPLICA_SVR_PORT | bigint(20) | YES | The port number of the server where the target replica resides. |
| TARGET_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The number of required Paxos replicas for the log stream. |
| TARGET_REPLICA_TYPE | varchar(16) | YES | The type of the target replica. |
| SOURCE_REPLICA_SVR_IP | varchar(46) | YES | The IP address of the server where the source replica resides. For tasks such as replica removal and modification of the number of required replicas, this field is invalid and is displayed as NULL. |
| SOURCE_REPLICA_SVR_PORT | bigint(20) | YES | The port number of the server where the source replica resides. For tasks such as replica removal and modification of the number of required replicas, this field is invalid and is displayed as 0. |
| SOURCE_PAXOS_REPLICA_NUMBER | bigint(20) | YES | The number of required Paxos replicas for the log stream. |
| SOURCE_REPLICA_TYPE | varchar(16) | YES | The type of the source replica. For tasks such as replica removal and modification of the number of required replicas, this field is invalid and is displayed as NULL. |
| DATA_SOURCE_SVR_IP | varchar(46) | YES | The IP address of the data source.
Note
|
| DATA_SOURCE_SVR_PORT | bigint(20) | YES | The port number of the data source.
Note
|
| IS_MANUAL | varchar(6) | NO | The source of the disaster recovery task. Valid values:
Note
|
| TASK_EXEC_SVR_IP | varchar(46) | YES | The IP address of the server where the task is executed. |
| TASK_EXEC_SVR_PORT | bigint(20) | YES | The port number of the server where the task is executed. |
| CREATE_TIME | datetime | NO | The time when the task was generated. |
| START_TIME | datetime | NO | The time when the task was scheduled. |
| MODIFY_TIME | datetime | NO | The time when the task status was updated. |
| COMMENT | varchar(2048) | YES | The remarks on the reason for generating the task. |
| CONFIG_VERSION | varchar(128) | YES | The config_version information of the clog layer when the disaster recovery task was executed.
NoteThis field was introduced in V4.4.0. |
Sample query
Query the ongoing disaster recovery tasks at the Replica level for the current tenant.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_OB_LS_REPLICA_TASKS\G
The query result is as follows:
*************************** 1. row ***************************
LS_ID: 1
TASK_TYPE: ADD REPLICA
TASK_ID: YB42AC1E87D7-000639016D9D80D7-0-0
TASK_STATUS: INPROGRESS
PRIORITY: HIGH
TARGET_REPLICA_SVR_IP: 172.xx.xxx.243
TARGET_REPLICA_SVR_PORT: 2882
TARGET_PAXOS_REPLICA_NUMBER: 3
TARGET_REPLICA_TYPE: FULL
SOURCE_REPLICA_SVR_IP: 172.xx.xxx.254
SOURCE_REPLICA_SVR_PORT: 2882
SOURCE_PAXOS_REPLICA_NUMBER: 2
SOURCE_REPLICA_TYPE: FULL
DATA_SOURCE_SVR_IP: 0.0.0.0
DATA_SOURCE_SVR_PORT: 0
IS_MANUAL: FALSE
TASK_EXEC_SVR_IP: 172.xx.xxx.243
TASK_EXEC_SVR_PORT: 2882
CREATE_TIME: 2025-07-10 11:04:05
START_TIME: 2025-07-10 11:04:05
MODIFY_TIME: 2025-07-10 11:04:05
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
*************************** 3. row ***************************
LS_ID: 1001
TASK_TYPE: ADD REPLICA
TASK_ID: YB42AC1E87D7-000639016D9D80D8-0-0
TASK_STATUS: INPROGRESS
PRIORITY: HIGH
TARGET_REPLICA_SVR_IP: 172.xx.xxx.243
TARGET_REPLICA_SVR_PORT: 2882
TARGET_PAXOS_REPLICA_NUMBER: 3
TARGET_REPLICA_TYPE: FULL
SOURCE_REPLICA_SVR_IP: 172.xx.xxx.254
SOURCE_REPLICA_SVR_PORT: 2882
SOURCE_PAXOS_REPLICA_NUMBER: 2
SOURCE_REPLICA_TYPE: FULL
DATA_SOURCE_SVR_IP: 0.0.0.0
DATA_SOURCE_SVR_PORT: 0
IS_MANUAL: FALSE
TASK_EXEC_SVR_IP: 172.xx.xxx.243
TASK_EXEC_SVR_PORT: 2882
CREATE_TIME: 2025-07-10 11:04:05
START_TIME: 2025-07-10 11:04:05
MODIFY_TIME: 2025-07-10 11:04:05
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
*************************** 4. row ***************************
LS_ID: 1003
TASK_TYPE: ADD REPLICA
TASK_ID: YB42AC1E87D7-000639016D9D80D9-0-0
TASK_STATUS: INPROGRESS
PRIORITY: HIGH
TARGET_REPLICA_SVR_IP: 172.xx.xxx.231
TARGET_REPLICA_SVR_PORT: 2882
TARGET_PAXOS_REPLICA_NUMBER: 3
TARGET_REPLICA_TYPE: FULL
SOURCE_REPLICA_SVR_IP: 172.xx.xxx.254
SOURCE_REPLICA_SVR_PORT: 2882
SOURCE_PAXOS_REPLICA_NUMBER: 2
SOURCE_REPLICA_TYPE: FULL
DATA_SOURCE_SVR_IP: 0.0.0.0
DATA_SOURCE_SVR_PORT: 0
IS_MANUAL: FALSE
TASK_EXEC_SVR_IP: 172.xx.xxx.231
TASK_EXEC_SVR_PORT: 2882
CREATE_TIME: 2025-07-10 11:04:05
START_TIME: 2025-07-10 11:04:05
MODIFY_TIME: 2025-07-10 11:04:05
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
3 rows in set
References
View all Replica-level disaster recovery tasks running in all tenants: CDB_OB_LS_REPLICA_TASKS
View the history of all Replica-level disaster recovery tasks executed in all tenants: CDB_OB_LS_REPLICA_TASK_HISTORY
View the history of Replica-level disaster recovery tasks executed in the current tenant: DBA_OB_LS_REPLICA_TASK_HISTORY