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_REGISTERED_ARCHIVED_LOG

Object Details

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

Details about the registered log files

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONSUMER_NAME	VARCHAR2	(128)	Yes	consumer name of the archived logs
SOURCE_DATABASE	VARCHAR2	(128)		the name of the database which generated the redo logs
THREAD#	NUMBER		Yes	Thread ID of the archived redo log
SEQUENCE#	NUMBER		Yes	Sequence number of the archived redo log file
FIRST_SCN	NUMBER		Yes	SCN of the current archived redo log
NEXT_SCN	NUMBER			SCN of the next archived redo log
FIRST_TIME	DATE			Date of the current archived redo log
NEXT_TIME	DATE			Date of the next archived redo log
NAME	VARCHAR2	(513)		Name of the archived redo log
MODIFIED_TIME	DATE			Time when the archived redo log was registered
DICTIONARY_BEGIN	VARCHAR2	(3)		Indicates whether the beginning of the dictionary build is in this redo log
DICTIONARY_END	VARCHAR2	(3)		Indicates whether the end of the dictionary build is in this redo log
PURGEABLE	VARCHAR2	(3)		Indicates whether this redo log can be permanently removed
RESETLOGS_CHANGE#	NUMBER		Yes	Resetlogs change# of the database when the log was written
RESET_TIMESTAMP	NUMBER		Yes	Resetlogs time of the database when the log was written

Query Text

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


SELECT CONSUMER_NAME
,      SOURCE_DATABASE
,      THREAD#
,      SEQUENCE#
,      FIRST_SCN
,      NEXT_SCN
,      FIRST_TIME
,      NEXT_TIME
,      NAME
,      MODIFIED_TIME
,      DICTIONARY_BEGIN
,      DICTIONARY_END
,      PURGEABLE
,      RESETLOGS_CHANGE#
,      RESET_TIMESTAMP
FROM SYS.DBA_REGISTERED_ARCHIVED_LOG;

Dependencies

[top of page]

SYS.DBA_REGISTERED_ARCHIVED_LOG references the following:

SYS: STREAMS$_CAPTURE_PROCESS
SYSTEM: LOGMNR_LOG$

SYS.DBA_REGISTERED_ARCHIVED_LOG is referenced by following:

PUBLIC: DBA_REGISTERED_ARCHIVED_LOG
SYS: DBMS_CAPTURE_ADM_INTERNAL - show dependent code; DBMS_XSTREAM_UTL_IVK - show dependent code