Dynamic Performance (V$) Views, 110 of 179

V$PROXY_ARCHIVEDLOG

This view contains descriptions of archived log backups which are taken with a new feature called Proxy Copy. Each row represents a backup of one archived log.

Column Datatype Description

RECID

NUMBER

Proxy copy record ID

STAMP

NUMBER

Proxy copy record stamp

DEVICE_TYPE

VARCHAR2(17)

Type of the device on which the copy resides

HANDLE

VARCHAR2(513)

Proxy copy handle identifies the copy for restore

COMMENTS

VARCHAR2(81)

Comment returned by the operating system or storage subsystem. This value is informational only; not needed for restore

MEDIA

VARCHAR2(65)

Name of the media on which the copy resides. This value is informational only. It is not needed for restore

MEDIA_POOL

NUMBER

The media pool in which the copy resides. This is the same value that was entered in the POOL operand of the Recovery Manager BACKUP command

STATUS

VARCHAR2(1)

Indicates the status of the copy:

A: The object is available.

D: The object is deleted.

X: The object has been "cross-checked" and found not to exist. A subsequent "delete expired" command will change the status to D. If, for some reason, the object really does still exist, then a subsequent "cross-check" command will change the status back to A.

THREAD#

NUMBER

Redo thread number

SEQUENCE#

NUMBER

Redo log sequence number

RESETLOGS _CHANGE#

NUMBER

Resetlogs change number of the database when this log was written

RESETLOGS_TIME

DATE

Resetlogs time of the database when this log was written

FIRST_CHANGE#

NUMBER

First change number in the archived log

FIRST_TIME

DATE

Timestamp of the first change

NEXT_CHANGE#

NUMBER

First change number in the next log

NEXT_TIME

DATE

Timestamp of the next change

BLOCKS

NUMBER

Size of the archived log in blocks

BLOCK_SIZE

NUMBER

Redo log block size

START_TIME

DATE

The starting time

COMPLETION_TIME

DATE

The completion time

ELAPSED_SECONDS

NUMBER

The number of elapsed seconds

Column	Datatype	Description
`RECID`	`NUMBER`	Proxy copy record ID
`STAMP`	`NUMBER`	Proxy copy record stamp
`DEVICE_TYPE`	`VARCHAR2(17)`	Type of the device on which the copy resides
`HANDLE`	`VARCHAR2(513)`	Proxy copy handle identifies the copy for restore
`COMMENTS`	`VARCHAR2(81)`	Comment returned by the operating system or storage subsystem. This value is informational only; not needed for restore
`MEDIA`	`VARCHAR2(65)`	Name of the media on which the copy resides. This value is informational only. It is not needed for restore
`MEDIA_POOL`	`NUMBER`	The media pool in which the copy resides. This is the same value that was entered in the POOL operand of the Recovery Manager BACKUP command
`STATUS`	`VARCHAR2(1)`	Indicates the status of the copy: A: The object is available. D: The object is deleted. X: The object has been "cross-checked" and found not to exist. A subsequent "delete expired" command will change the status to D. If, for some reason, the object really does still exist, then a subsequent "cross-check" command will change the status back to A.
`THREAD#`	`NUMBER`	Redo thread number
`SEQUENCE#`	`NUMBER`	Redo log sequence number
`RESETLOGS _CHANGE#`	`NUMBER`	Resetlogs change number of the database when this log was written
`RESETLOGS_TIME`	`DATE`	Resetlogs time of the database when this log was written
`FIRST_CHANGE#`	`NUMBER`	First change number in the archived log
`FIRST_TIME`	`DATE`	Timestamp of the first change
`NEXT_CHANGE#`	`NUMBER`	First change number in the next log
`NEXT_TIME`	`DATE`	Timestamp of the next change
`BLOCKS`	`NUMBER`	Size of the archived log in blocks
`BLOCK_SIZE`	`NUMBER`	Redo log block size
`START_TIME`	`DATE`	The starting time
`COMPLETION_TIME`	`DATE`	The completion time
`ELAPSED_SECONDS`	`NUMBER`	The number of elapsed seconds