Oracle教程 2023-02-26

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

Oracle 视图 DBA_ROLLING_DATABASES 是一个字典视图，用于展示数据库正在进行轮询升级的信息。它包含轮询每个数据库的名称，状态，进度和结果。

如何使用：

1. 使用以下SQL查询DBA_ROLLING_DATABASES视图以查看数据库正在进行轮询升级：

SELECT * FROM DBA_ROLLING_DATABASES;

2. 您可以进一步限制查询以仅查看指定状态的数据库：

SELECT * FROM DBA_ROLLING_DATABASES WHERE UPGRADE_STATUS = ‘COMPLETED’;

DBA_ROLLING_DATABASES lists all the databases eligible for configuration with rolling operations.

Column	Datatype	Description
`RDBID`	`NUMBER`	Rolling operation database identifier
`DBID`	`NUMBER`	Oracle database identifier
`DBUN`	`VARCHAR2(128)`	Database unique name
`ROLE`	`VARCHAR2(8)`	Database role
`OPEN_MODE`	`VARCHAR2(15)`	Open mode information
`PARTICIPANT`	`VARCHAR2(3)`	Indicates whether the database is participating in the rolling operation (`YES`) or not (`NO`)
`VERSION`	`VARCHAR2(128)`	RDBMS version number
`ENGINE_STATUS`	`VARCHAR2(14)`	Running status of the MRP-recovery or LSP-apply process
`RAC`	`VARCHAR2(3)`	Indicates whether the database is an Oracle Real Application Clusters (Oracle RAC) database
`UPDATE_PROGRESS`	`VARCHAR2(11)`	Upgrade status of the system catalog
`PROD_RSCN`	`VARCHAR(40)`	Resetlogs SCN at which redo is currently being produced
`PROD_RID`	`VARCHAR(40)`	Resetlogs ID at which redo is currently being produced
`PROD_SCN`	`VARCHAR(40)`	Last SCN at which redo was produced
`REDO_SOURCE`	`VARCHAR2(128)`	Database unique name of the producer of redo being consumed
`CONS_RSCN`	`VARCHAR(40)`	Resetlogs SCN at which redo is currently being consumed
`CONS_RID`	`VARCHAR(40)`	Resetlogs ID at which redo is currently being consumed
`CONS_SCN`	`VARCHAR(40)`	Last SCN at which redo was consumed
`UPDATE_TIME`	`TIMESTAMP(6)`	Time of the last record update