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

VIEW: SYS.V_$ARCHIVED_LOG

Object Details
Object Name: V_$ARCHIVED_LOG
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
RECID NUMBER

STAMP NUMBER

NAME VARCHAR2 (513)
DEST_ID NUMBER

THREAD# NUMBER

SEQUENCE# NUMBER

RESETLOGS_CHANGE# NUMBER

RESETLOGS_TIME DATE

RESETLOGS_ID NUMBER

FIRST_CHANGE# NUMBER

FIRST_TIME DATE

NEXT_CHANGE# NUMBER

NEXT_TIME DATE

BLOCKS NUMBER

BLOCK_SIZE NUMBER

CREATOR VARCHAR2 (7)
REGISTRAR VARCHAR2 (7)
STANDBY_DEST VARCHAR2 (3)
ARCHIVED VARCHAR2 (3)
APPLIED VARCHAR2 (9)
DELETED VARCHAR2 (3)
STATUS VARCHAR2 (1)
COMPLETION_TIME DATE

DICTIONARY_BEGIN VARCHAR2 (3)
DICTIONARY_END VARCHAR2 (3)
END_OF_REDO VARCHAR2 (3)
BACKUP_COUNT NUMBER

ARCHIVAL_THREAD# NUMBER

ACTIVATION# NUMBER

IS_RECOVERY_DEST_FILE VARCHAR2 (3)
COMPRESSED VARCHAR2 (3)
FAL VARCHAR2 (3)
END_OF_REDO_TYPE VARCHAR2 (10)
BACKED_BY_VSS VARCHAR2 (3)
CON_ID NUMBER

Query Text

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


SELECT RECID
,      STAMP
,      NAME
,      DEST_ID
,      THREAD#
,      SEQUENCE#
,      RESETLOGS_CHANGE#
,      RESETLOGS_TIME
,      RESETLOGS_ID
,      FIRST_CHANGE#
,      FIRST_TIME
,      NEXT_CHANGE#
,      NEXT_TIME
,      BLOCKS
,      BLOCK_SIZE
,      CREATOR
,      REGISTRAR
,      STANDBY_DEST
,      ARCHIVED
,      APPLIED
,      DELETED
,      STATUS
,      COMPLETION_TIME
,      DICTIONARY_BEGIN
,      DICTIONARY_END
,      END_OF_REDO
,      BACKUP_COUNT
,      ARCHIVAL_THREAD#
,      ACTIVATION#
,      IS_RECOVERY_DEST_FILE
,      COMPRESSED
,      FAL
,      END_OF_REDO_TYPE
,      BACKED_BY_VSS
,      CON_ID
FROM SYS.V_$ARCHIVED_LOG;

Dependencies

[top of page]

SYS.V_$ARCHIVED_LOG references the following:

SYS.V_$ARCHIVED_LOG is referenced by following:

SchemaPUBLIC
SynonymV$ARCHIVED_LOG