Note
This view is available starting with V4.0.0.
Purpose
This view displays all tasks that should be generated (including those that have been generated and those that have not yet been generated).
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:
|
| 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 required Paxos replicas of the target replica. |
| 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 replica removal and modification of the number of required 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 replica removal and modification of the number of required Paxos replicas, this field is invalid and is displayed as 0. |
| SOURCE_PAXOS_REPLICA_NUMBER | NUMBER(38) | YES | The number of required Paxos replicas of the source replica. |
| SOURCE_REPLICA_TYPE | VARCHAR2(16) | YES | The type of the source replica. For tasks such as replica removal and modification of the number of required Paxos replicas, this field is invalid and is displayed as NULL. |
| 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. |
| COMMENT | VARCHAR2(2048) | YES | The remarks about the reason for task generation. |
| CONFIG_VERSION | VARCHAR2(128) | YES | The config_version information of the clog layer when the disaster recovery task is executed.
NoteThis field is available starting with V4.4.0. |
Sample query
Query the tasks that should be generated for the current tenant.
obclient> SELECT * FROM SYS.V$OB_LS_REPLICA_TASK_PLAN\G
The query result is as follows:
*************************** 1. row ***************************
LS_ID: 1
TASK_TYPE: ADD REPLICA
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
TASK_EXEC_SVR_IP: 172.xx.xxx.243
TASK_EXEC_SVR_PORT: 2882
COMMENT: add paxos replica according to locality
CONFIG_VERSION:
1 row in set