DBA_ROLLING_DATABASES
DBA_ROLLING_DATABASES lists all the databases eligible for configuration with rolling operations.
| Column | Datatype | NULL | 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 |
See Also: Oracle Data Guard Concepts and Administration for more information about rolling operations.