Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 128 of 211


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 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback