Overview
The CDB_OB_LS_REPLICA_TASKS view displays the ongoing disaster recovery tasks at the replica level for all tenants. It is available only to the system tenant.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID |
| LS_ID | bigint(20) | NO | Log Stream ID |
| TASK_TYPE | varchar(64) | NO | Task type. Valid values:
|
| TASK_ID | varchar(200) | NO | Task ID |
| TASK_STATUS | varchar(2048) | YES | Task status. Valid values:
|
| PRIORITY | varchar(5) | NO | Task priority. Valid values:
|
| TARGET_REPLICA_SVR_IP | varchar(46) | YES | IP Address of the Server Where the Target Replica Resides |
| TARGET_REPLICA_SVR_PORT | bigint(20) | YES | Port number of the server where the target replica resides |
| TARGET_PAXOS_REPLICA_NUMBER | bigint(20) | YES | Quorum Paxos Replicas for Log Stream Targets |
| TARGET_REPLICA_TYPE | varchar(16) | YES | Target Replica Type |
| SOURCE_REPLICA_SVR_IP | varchar(46) | YES | IP address of the server where the source replica resides. This field is invalid and displays as NULL for operations such as deleting a replica or modifying the number of quorum replicas. |
| SOURCE_REPLICA_SVR_PORT | bigint(20) | YES | Port number of the server where the source replica resides. This field is invalid and displays as 0 for operations such as deleting a replica or modifying the quorum count. |
| SOURCE_PAXOS_REPLICA_NUMBER | bigint(20) | YES | Number of Paxos Followers in Log Stream Primary State |
| SOURCE_REPLICA_TYPE | varchar(16) | YES | Type of the source replica. This field is invalid and displays as NULL for operations such as deleting a replica or modifying the quorum count. |
| DATA_SOURCE_SVR_IP | varchar(46) | YES | Data Source IP |
| DATA_SOURCE_SVR_PORT | bigint(20) | YES | Data Source Port |
| IS_MANUAL | varchar(6) | NO | The source of the disaster recovery task. Valid values:
|
| TASK_EXEC_SVR_IP | varchar(46) | YES | IP Address of the Task Execution Machine |
| TASK_EXEC_SVR_PORT | bigint(20) | YES | Port number of the task execution machine |
| CREATE_TIME | datetime | NO | Task Generation Time |
| START_TIME | datetime | NO | Task Scheduling Time |
| MODIFY_TIME | datetime | NO | Last Updated |
| COMMENT | varchar(2048) | YES | Reason for Task Generation Remarks |
| CONFIG_VERSION | varchar(128) | YES | Record the config_version information of the clog layer during disaster recovery task execution. |
Sample query
View the ongoing disaster recovery tasks at the replica level for all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_OB_LS_REPLICA_TASKS\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1005
LS_ID: 1
TASK_TYPE: ADD REPLICA
TASK_ID: YB42AC1E87D7-000639016D9D7F19-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.204
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 10:58:07
START_TIME: 2025-07-10 10:58:07
MODIFY_TIME: 2025-07-10 10:58:07
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
*************************** 2. row ***************************
TENANT_ID: 1006
LS_ID: 1
TASK_TYPE: ADD REPLICA
TASK_ID: YB42AC1E87D7-000639016D9D7F1A-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.204
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 10:58:08
START_TIME: 2025-07-10 10:58:08
MODIFY_TIME: 2025-07-10 10:58:08
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
2 rows in set
References
View the disaster recovery tasks at the replica level currently running for the current tenant: DBA_OB_LS_REPLICA_TASKS
View the execution history of a replica-level disaster recovery task for the current tenant: DBA_OB_LS_REPLICA_TASK_HISTORY
View the execution history of all tenant replica-level disaster recovery tasks: CDB_OB_LS_REPLICA_TASK_HISTORY