Note
This view is available starting with V4.0.0.
Purpose
The DBA_OB_LS_REPLICA_TASKS view displays the disaster recovery tasks at the replica level that are running for the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| LS_ID | NUMBER(38) | NO | The ID of the log stream. |
| TASK_TYPE | VARCHAR2(64) | NO | The task type. Valid values:
|
| TASK_ID | VARCHAR2(200) | NO | The task ID. |
| TASK_STATUS | VARCHAR2(2048) | YES | The task status. Valid values:
|
| PRIORITY | CHAR(5) | NO | The task priority. Valid values:
|
| TARGET_REPLICA_SVR_IP | VARCHAR2(46) | YES | The IP address of the server where the target replica resides. |
| TARGET_REPLICA_SVR_PORT | NUMBER(38) | YES | The port number of the server where the target replica resides. |
| TARGET_PAXOS_REPLICA_NUMBER | NUMBER(38) | YES | The number of Paxos replicas in the log stream. |
| TARGET_REPLICA_TYPE | VARCHAR2(16) | YES | The type of the target replica. |
| SOURCE_REPLICA_SVR_IP | VARCHAR2(46) | YES | The IP address of the server where the source replica resides. For tasks such as removing a replica or modifying the number of Paxos replicas, this field is invalid and is displayed as NULL. |
| SOURCE_REPLICA_SVR_PORT | NUMBER(38) | YES | The port number of the server where the source replica resides. For tasks such as removing a replica or modifying the number of Paxos replicas, this field is invalid and is displayed as 0. |
| SOURCE_PAXOS_REPLICA_NUMBER | NUMBER(38) | YES | The number of Paxos replicas in the log stream. |
| SOURCE_REPLICA_TYPE | VARCHAR2(16) | YES | The type of the source replica. For tasks such as removing a replica or modifying the number of Paxos replicas, this field is invalid and is displayed as NULL. |
| DATA_SOURCE_SVR_IP | VARCHAR2(46) | YES | The IP address of the data source.
Note
|
| DATA_SOURCE_SVR_PORT | NUMBER(38) | YES | The port number of the data source.
Note
|
| IS_MANUAL | CHAR(6) | NO | The source of the disaster recovery task. Valid values:
Note
|
| TASK_EXEC_SVR_IP | VARCHAR2(46) | YES | The IP address of the server where the task is executed. |
| TASK_EXEC_SVR_PORT | NUMBER(38) | YES | The port number of the server where the task is executed. |
| CREATE_TIME | TIMESTAMP(6) | NO | The time when the task was generated. |
| START_TIME | TIMESTAMP(6) | NO | The time when the task was scheduled. |
| MODIFY_TIME | TIMESTAMP(6) | NO | The time when the task status was updated. |
| COMMENT | VARCHAR2(2048) | YES | The remarks about the reason for generating the task. |
| CONFIG_VERSION | VARCHAR2(128) | YES | The config_version information of the clog layer when the disaster recovery task was executed.
NoteThis field is available starting with V4.4.0. |
Sample query
Query the disaster recovery tasks at the replica level that are running for the current tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_OB_LS_REPLICA_TASKS\G
The query result is as follows:
*************************** 1. row ***************************
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:
1 row in set
References
View all running Replica-level disaster recovery tasks for all tenants: CDB_OB_LS_REPLICA_TASKS
View the history of completed Replica-level disaster recovery tasks for all tenants: CDB_OB_LS_REPLICA_TASK_HISTORY
View the history of completed Replica-level disaster recovery tasks for the current tenant: DBA_OB_LS_REPLICA_TASK_HISTORY