eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.DBA_ROLLING_DATABASES

Object Details

Object Name:	DBA_ROLLING_DATABASES
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

List of all databases eligible for configuration with rolling upgrade

[View Source]

Columns

Name	Datatype	Length	Comments
RDBID	NUMBER		Rolling upgrade 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)	Is the database participating in the rolling upgrade - YES or NO
VERSION	VARCHAR2	(128)	RDBMS version number
ENGINE_STATUS	VARCHAR2	(14)	Running status of the MRP-recovery or LSP-apply process
RAC	VARCHAR2	(3)
UPDATE_PROGRESS	VARCHAR2	(11)	Update progress of the changes from the future primary
PROD_RSCN	VARCHAR2	(40)	Resetlogs SCN at which redo is currently being produced
PROD_RID	VARCHAR2	(40)	Resetlogs ID at which redo is currently being produced
PROD_SCN	VARCHAR2	(40)	Last SCN at which redo was produced
REDO_SOURCE	VARCHAR2	(128)	Database unique name of the producer of redo being consumed
CONS_RSCN	VARCHAR2	(40)	Resetlogs SCN at which redo is currently being consumed
CONS_RID	VARCHAR2	(40)	Resetlogs ID at which redo is currently being consumed
CONS_SCN	VARCHAR2	(40)	Last SCN at which redo was consumed
UPDATE_TIME	TIMESTAMP(6)	(11)	Time of the last record update

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RDBID
,      DBID
,      DBUN
,      ROLE
,      OPEN_MODE
,      PARTICIPANT
,      VERSION
,      ENGINE_STATUS
,      RAC
,      UPDATE_PROGRESS
,      PROD_RSCN
,      PROD_RID
,      PROD_SCN
,      REDO_SOURCE
,      CONS_RSCN
,      CONS_RID
,      CONS_SCN
,      UPDATE_TIME
FROM SYS.DBA_ROLLING_DATABASES;

Dependencies

[top of page]

SYS.DBA_ROLLING_DATABASES references the following:

SYSTEM: ROLLING$DATABASES; ROLLING$STATUS

SYS.DBA_ROLLING_DATABASES is referenced by following:

PUBLIC: DBA_ROLLING_DATABASES