DBA_ROLLING_DATABASES
lists all the databases eligible for configuration with rolling operations.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Rolling operation database identifier |
|
|
|
Oracle database identifier |
|
|
|
Database unique name |
|
|
|
Database role |
|
|
|
Open mode information |
|
|
|
Indicates whether the database is participating in the rolling operation ( |
|
|
|
RDBMS version number |
|
|
|
Running status of the MRP-recovery or LSP-apply process |
|
|
|
Indicates whether the database is an Oracle Real Application Clusters (Oracle RAC) database |
|
|
|
Upgrade status of the system catalog |
|
|
|
Resetlogs SCN at which redo is currently being produced |
|
|
|
Resetlogs ID at which redo is currently being produced |
|
|
|
Last SCN at which redo was produced |
|
|
|
Database unique name of the producer of redo being consumed |
|
|
|
Resetlogs SCN at which redo is currently being consumed |
|
|
|
Resetlogs ID at which redo is currently being consumed |
|
|
|
Last SCN at which redo was consumed |
|
|
|
Time of the last record update |
See Also:
Oracle Data Guard Concepts and Administration for more information about rolling operations.