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.V_$BACKUP_FILES

Object Details

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

[View Source]

Columns

Name	Datatype	Length
PKEY	NUMBER
BACKUP_TYPE	VARCHAR2	(32)
FILE_TYPE	VARCHAR2	(32)
KEEP	VARCHAR2	(3)
KEEP_UNTIL	DATE
KEEP_OPTIONS	VARCHAR2	(13)
STATUS	VARCHAR2	(16)
FNAME	VARCHAR2	(1024)
TAG	VARCHAR2	(32)
MEDIA	VARCHAR2	(80)
RECID	NUMBER
STAMP	NUMBER
DEVICE_TYPE	VARCHAR2	(255)
BLOCK_SIZE	NUMBER
COMPLETION_TIME	DATE
COMPRESSED	VARCHAR2	(3)
OBSOLETE	VARCHAR2	(3)
BYTES	NUMBER
BS_KEY	NUMBER
BS_COUNT	NUMBER
BS_STAMP	NUMBER
BS_TYPE	VARCHAR2	(32)
BS_INCR_TYPE	VARCHAR2	(32)
BS_PIECES	NUMBER
BS_COPIES	NUMBER
BS_COMPLETION_TIME	DATE
BS_STATUS	VARCHAR2	(16)
BS_BYTES	NUMBER
BS_COMPRESSED	VARCHAR2	(3)
BS_TAG	VARCHAR2	(1024)
BS_DEVICE_TYPE	VARCHAR2	(255)
BP_PIECE#	NUMBER
BP_COPY#	NUMBER
DF_FILE#	NUMBER
DF_TABLESPACE	VARCHAR2	(30)
DF_RESETLOGS_CHANGE#	NUMBER
DF_CREATION_CHANGE#	NUMBER
DF_CHECKPOINT_CHANGE#	NUMBER
DF_CKP_MOD_TIME	DATE
RL_THREAD#	NUMBER
RL_SEQUENCE#	NUMBER
RL_RESETLOGS_CHANGE#	NUMBER
RL_FIRST_CHANGE#	NUMBER
RL_FIRST_TIME	DATE
RL_NEXT_CHANGE#	NUMBER
RL_NEXT_TIME	DATE
CON_ID	NUMBER

Query Text

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


SELECT PKEY
,      BACKUP_TYPE
,      FILE_TYPE
,      KEEP
,      KEEP_UNTIL
,      KEEP_OPTIONS
,      STATUS
,      FNAME
,      TAG
,      MEDIA
,      RECID
,      STAMP
,      DEVICE_TYPE
,      BLOCK_SIZE
,      COMPLETION_TIME
,      COMPRESSED
,      OBSOLETE
,      BYTES
,      BS_KEY
,      BS_COUNT
,      BS_STAMP
,      BS_TYPE
,      BS_INCR_TYPE
,      BS_PIECES
,      BS_COPIES
,      BS_COMPLETION_TIME
,      BS_STATUS
,      BS_BYTES
,      BS_COMPRESSED
,      BS_TAG
,      BS_DEVICE_TYPE
,      BP_PIECE#
,      BP_COPY#
,      DF_FILE#
,      DF_TABLESPACE
,      DF_RESETLOGS_CHANGE#
,      DF_CREATION_CHANGE#
,      DF_CHECKPOINT_CHANGE#
,      DF_CKP_MOD_TIME
,      RL_THREAD#
,      RL_SEQUENCE#
,      RL_RESETLOGS_CHANGE#
,      RL_FIRST_CHANGE#
,      RL_FIRST_TIME
,      RL_NEXT_CHANGE#
,      RL_NEXT_TIME
,      CON_ID
FROM SYS.V_$BACKUP_FILES;

Dependencies

[top of page]

SYS.V_$BACKUP_FILES references the following:

SYS: V_LBRECSET_T; V_LISTBACKUPPIPE

SYS.V_$BACKUP_FILES is referenced by following:

PUBLIC: V$BACKUP_FILES