Oracle教程 2023-03-25

Oracle 视图 DBA_ROLLING_STATUS 官方解释，作用，如何使用详细说明

Oracle视图DBA_ROLLING_STATUS被用于查询数据库的卷状态信息。它展示了当前正在进行的和已经结束的卷信息，包括任务的GUID、任务的状态、任务类型、数据库名称等，以及最新的卷或运行信息。

要使用这个视图，可以使用以下查询：

SELECT * FROM DBA_ROLLING_STATUS;

这将返回包含数据库卷状态信息，以及当前正在运行的运行和已完成运行的列表。可以使用以下查询来筛选特定任务：

SELECT * FROM DBA_ROLLING_STATUS
WHERE GUID = ‘XXXX’;

这将返回与提供的GUID关联的滚动状态。

DBA_ROLLING_STATUS displays the overall status of the rolling operation.

Column	Datatype	Description
`REVISION`	`NUMBER`	Revision number of the current upgrade plan
`STATUS`	`VARCHAR2(12)`	Readiness of the facility to begin or resume the rolling operation
`PHASE`	`VARCHAR2(14)`	Current phase of the plan
`NEXT_INSTRUCTION`	`NUMBER`	Instruction ID of the next pending instruction
`REMAINING_INSTRUCTIONS`	`NUMBER`	Number of remaining instructions to execute in the plan
`COORDINATOR_INSTANCE`	`NUMBER`	Instance number from which the rolling operation is being coordinated
`COORDINATOR_PID`	`NUMBER`	Process PID in which the rolling operation is being coordinated
`ORIGINAL_PRIMARY`	`VARCHAR2(128)`	Database unique name of the original primary
`FUTURE_PRIMARY`	`VARCHAR2(128)`	Database unique name of the future primary
`TOTAL_DATABASES`	`NUMBER`	Number of total databases eligible to participate in the rolling operation
`PARTICIPATING_DATABASES`	`NUMBER`	Number of databases configured to participate in the rolling operation
`INIT_TIME`	`TIMESTAMP(6)`	Time of the last call to `DBMS_ROLLING`.`INIT_PLAN`
`BUILD_TIME`	`TIMESTAMP(6)`	Time of the last call to `DBMS_ROLLING`.`BUILD`
`START_TIME`	`TIMESTAMP(6)`	Time of the last call to `DBMS_ROLLING`.`START_UPGRADE`
`SWITCH_TIME`	`TIMESTAMP(6)`	Time of the last call to `DBMS_ROLLING`.`SWITCHOVER`
`FINISH_TIME`	`TIMESTAMP(6)`	Time of the last call to `DBMS_ROLLING`.`FINISH`