--- title: "DBA_OB_LS_REPLICA_TASK_HISTORY - OceanBase 数据库 V4.2.4 | OceanBase 文档中心" description: DBA_OB_LS_REPLICA_TASK_HISTORY 说明 从 V4.2.3 版本开始引入。 功能描述 视图 DBA_OB_LS_REPLICA_TASK_HISTORY 用于展示容灾任务执行历史。 字段说明 字段名称 类型 是否可以为 NULL 描述 LS_ID NUMBER(38) NO 日志流 ID T… --- 切换语言 - 中文站 - 简体中文 - International - English - 日本站 - 日本語 文档反馈![](https://mdn.alipayobjects.com/huamei_22khvb/afts/img/A*P8CuR4UJ_FkAAAAAAAAAAAAADiGDAQ/original) OceanBase 数据库分布式版 - V 4.2.4 # DBA_OB_LS_REPLICA_TASK_HISTORY 更新时间：2024-07-11 00:04:56 [编辑](https://github.com/oceanbase/oceanbase-doc/edit/V4.2.4/zh-CN/700.reference/700.system-views/500.system-view-of-oracle-mode/200.dictionary-view-of-oracle-mode/13200.dba_ob_ls_replica_task_history-of-oracle-mode.md) #### 说明 从 V4.2.3 版本开始引入。 ## 功能描述 视图 `DBA_OB_LS_REPLICA_TASK_HISTORY` 用于展示容灾任务执行历史。 ## 字段说明 | **字段名称** | **类型** | **是否可以为 NULL** | **描述** | | --- | --- | --- | --- | | LS_ID | NUMBER(38) | NO | 日志流 ID | | TASK_TYPE | VARCHAR2(64) | NO | 任务类型，取值如下： - `MIGRATE REPLICA`：迁移副本 - `ADD REPLICA`：增加副本 - `TYPE TRANSFORM`：副本类型转换 - `REMOVE PAXOS REPLICA`：删除 Paxos 成员副本 - `REMOVE NON PAXOS REPLICA`：删除非 Paxos 成员副本 - `MODIFY PAXOS REPLICA NUMBER`：修改法定副本数 | | TASK_ID | VARCHAR2(200) | NO | 任务 ID | | TASK_STATUS | VARCHAR2(2048) | YES | 任务状态，取值如下： - `INPROGRESS`：调度运行中 - `COMPLETED`：任务完成 - `CANCELED` ：任务取消 | | PRIORITY | CHAR(5) | NO | 任务优先级，可取值： - `LOW`：低优先级的任务 - `HIGH`：高优先级的任务 | | TARGET_REPLICA_SVR_IP | VARCHAR2(46) | YES | 目标副本所在机器 IP | | TARGET_REPLICA_SVR_PORT | NUMBER(38) | YES | 目标副本所在机器 PORT | | TARGET_PAXOS_REPLICA_NUMBER | NUMBER(38) | YES | 日志流目标法定 Paxos 副本数量 | | TARGET_REPLICA_TYPE | VARCHAR2(16) | YES | 目标副本类型 | | SOURCE_REPLICA_SVR_IP | VARCHAR2(46) | YES | 源端副本所在机器 IP | | SOURCE_REPLICA_SVR_PORT | NUMBER(38) | YES | 源端副本所在机器 PORT | | SOURCE_PAXOS_REPLICA_NUMBER | NUMBER(38) | YES | 日志流原法定 Paxos 副本数量 | | SOURCE_REPLICA_TYPE | VARCHAR2(16) | YES | 源端副本类型 | | DATA_SOURCE_SVR_IP | VARCHAR2(46) | YES | 数据源 IP | | DATA_SOURCE_SVR_PORT | NUMBER(38) | YES | 数据源 PORT | | IS_MANUAL | CHAR(6) | NO | 容灾任务来源，可取值： - `TRUE`：表示手动运维命令触发的容灾任务 - `FALSE`：默认值，表示 RS 层容灾自动生成的容灾任务 | | TASK_EXEC_SVR_IP | VARCHAR2(46) | YES | 任务执行机器 IP | | TASK_EXEC_SVR_PORT | NUMBER(38) | YES | 任务执行机器 PORT | | CREATE_TIME | TIMESTAMP(6) | NO | 任务生成时间 | | START_TIME | TIMESTAMP(6) | NO | 任务调度时间 | | MODIFY_TIME | TIMESTAMP(6) | NO | 任务状态更新时间 | | FINISH_TIME | TIMESTAMP(6) | NO | 任务结束时间 | | EXECUTE_RESULT | VARCHAR2(2048) | YES | 任务执行结果 | | COMMENT | VARCHAR2(2048) | YES | 任务生成原因备注 | ## 查询示例 ```shell obclient [SYS]> SELECT * FROM SYS.DBA_OB_LS_REPLICA_TASK_HISTORY; ``` 查询结果如下： ```shell +-------+-----------------------------+------------------------------------+-------------+----------+-----------------------+-------------------------+-----------------------------+---------------------+-----------------------+-------------------------+-----------------------------+---------------------+--------------------+----------------------+-----------+------------------+--------------------+------------------------------+------------------------------+------------------------------+------------------------------+-------------------------------------+------------------------------------+ | LS_ID | TASK_TYPE | TASK_ID | TASK_STATUS | PRIORITY | TARGET_REPLICA_SVR_IP | TARGET_REPLICA_SVR_PORT | TARGET_PAXOS_REPLICA_NUMBER | TARGET_REPLICA_TYPE | SOURCE_REPLICA_SVR_IP | SOURCE_REPLICA_SVR_PORT | SOURCE_PAXOS_REPLICA_NUMBER | SOURCE_REPLICA_TYPE | DATA_SOURCE_SVR_IP | DATA_SOURCE_SVR_PORT | IS_MANUAL | TASK_EXEC_SVR_IP | TASK_EXEC_SVR_PORT | CREATE_TIME | START_TIME | MODIFY_TIME | FINISH_TIME | EXECUTE_RESULT | COMMENT | +-------+-----------------------------+------------------------------------+-------------+----------+-----------------------+-------------------------+-----------------------------+---------------------+-----------------------+-------------------------+-----------------------------+---------------------+--------------------+----------------------+-----------+------------------+--------------------+------------------------------+------------------------------+------------------------------+------------------------------+-------------------------------------+------------------------------------+ | 1002 | ADD REPLICA | Y13CE64586BD4-000614A080F90C61-0-0 | COMPLETED | HIGH | xx.xx.xx.xx | 5078 | 5 | FULL | xx.xx.xx.xx | 5070 | 4 | FULL | 0.0.0.0 | 0 | TRUE | xx.xx.xx.xx | 5078 | 27-MAR-24 04.56.35.744416 PM | 27-MAR-24 04.56.32.224829 PM | 27-MAR-24 04.56.35.744416 PM | 27-MAR-24 04.56.35.000000 PM | ret:0, OB_SUCCESS; elapsed:3482196; | add replica by manual | | 1002 | MIGRATE REPLICA | Y13CE64586BD4-000614A081890C5E-0-0 | COMPLETED | HIGH | xx.xx.xx.xx | 5077 | 4 | FULL | xx.xx.xx.xx | 5076 | 4 | FULL | 0.0.0.0 | 0 | TRUE | xx.xx.xx.xx | 5077 | 27-MAR-24 04.57.10.488799 PM | 27-MAR-24 04.57.06.753924 PM | 27-MAR-24 04.57.10.488799 PM | 27-MAR-24 04.57.10.000000 PM | ret:0, OB_SUCCESS; elapsed:3732851; | migrate replica by manual | | 1002 | MODIFY PAXOS REPLICA NUMBER | Y13CE64586BD4-000614A081B90C5E-0-0 | COMPLETED | HIGH | xx.xx.xx.xx | 5070 | 3 | NULL | NULL | 0 | 4 | NULL | NULL | NULL | TRUE | xx.xx.xx.xx | 5070 | 27-MAR-24 04.58.12.753859 PM | 27-MAR-24 04.58.12.599322 PM | 27-MAR-24 04.58.12.753859 PM | 27-MAR-24 04.58.12.000000 PM | ret:0, OB_SUCCESS; elapsed:149561; | modify paxos_replica_num by manual | | 1002 | REMOVE NON PAXOS REPLICA | Y13CE64586BD4-000614A081890C5D-0-0 | COMPLETED | HIGH | xx.xx.xx.xx | 5074 | 4 | READONLY | NULL | 0 | 4 | NULL | NULL | NULL | TRUE | xx.xx.xx.xx | 5070 | 27-MAR-24 04.56.43.937924 PM | 27-MAR-24 04.56.43.864253 PM | 27-MAR-24 04.56.43.937924 PM | 27-MAR-24 04.56.43.000000 PM | ret:0, OB_SUCCESS; elapsed:68493; | remove replica by manual | | 1002 | REMOVE PAXOS REPLICA | Y13CE64586BD4-000614A074B90E54-0-0 | COMPLETED | HIGH | xx.xx.xx.xx | 5072 | 4 | FULL | NULL | 0 | 4 | NULL | NULL | NULL | FALSE | xx.xx.xx.xx | 5070 | 27-MAR-24 04.57.55.293592 PM | 27-MAR-24 04.57.55.201006 PM | 27-MAR-24 04.57.55.293592 PM | 27-MAR-24 04.57.55.000000 PM | ret:0, OB_SUCCESS; elapsed:89678; | remove permanent offline replica | | 1002 | TYPE TRANSFORM | Y13CE64586BD4-000614A080F90C62-0-0 | COMPLETED | HIGH | xx.xx.xx.xx | 5074 | 4 | READONLY | xx.xx.xx.xx | 5074 | 5 | FULL | NULL | NULL | TRUE | xx.xx.xx.xx | 5074 | 27-MAR-24 04.56.39.762757 PM | 27-MAR-24 04.56.39.649459 PM | 27-MAR-24 04.56.39.762757 PM | 27-MAR-24 04.56.39.000000 PM | ret:0, OB_SUCCESS; elapsed:99235; | modify replica type by manual | +-------+-----------------------------+------------------------------------+-------------+----------+-----------------------+-------------------------+-----------------------------+---------------------+-----------------------+-------------------------+-----------------------------+---------------------+--------------------+----------------------+-----------+------------------+--------------------+------------------------------+------------------------------+------------------------------+------------------------------+-------------------------------------+------------------------------------+ 6 rows in set (0.06 sec) ``` ## 相关视图或文档 [CDB_OB_LS_REPLICA_TASK_HISTORY](https://www.oceanbase.com/docs/common-oceanbase-database-cn-1000000001034711) 上一篇 下一篇 ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线