V$PROXY_ARCHIVEDLOG definition in Oracle Database 11.2
V$PROXY_ARCHIVEDLOG
select
RECID, -- RECID NUMBER
STAMP, -- STAMP NUMBER
DEVICE_TYPE, -- DEVICE_TYPE VARCHAR2(17)
HANDLE, -- HANDLE VARCHAR2(513)
COMMENTS, -- COMMENTS VARCHAR2(81)
MEDIA, -- MEDIA VARCHAR2(65)
MEDIA_POOL, -- MEDIA_POOL NUMBER
TAG, -- TAG VARCHAR2(32)
STATUS, -- STATUS VARCHAR2(1)
DELETED, -- DELETED VARCHAR2(3)
THREAD#, -- THREAD# NUMBER
SEQUENCE#, -- SEQUENCE# NUMBER
RESETLOGS_CHANGE#, -- RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME, -- RESETLOGS_TIME DATE
FIRST_CHANGE#, -- FIRST_CHANGE# NUMBER
FIRST_TIME, -- FIRST_TIME DATE
NEXT_CHANGE#, -- NEXT_CHANGE# NUMBER
NEXT_TIME, -- NEXT_TIME DATE
BLOCKS, -- BLOCKS NUMBER
BLOCK_SIZE, -- BLOCK_SIZE NUMBER
START_TIME, -- START_TIME DATE
COMPLETION_TIME, -- COMPLETION_TIME DATE
ELAPSED_SECONDS, -- ELAPSED_SECONDS NUMBER
RMAN_STATUS_RECID, -- RMAN_STATUS_RECID NUMBER
RMAN_STATUS_STAMP, -- RMAN_STATUS_STAMP NUMBER
TERMINAL, -- TERMINAL VARCHAR2(3)
KEEP, -- KEEP VARCHAR2(3)
KEEP_UNTIL, -- KEEP_UNTIL DATE
KEEP_OPTIONS -- KEEP_OPTIONS VARCHAR2(11)
from
GV$PROXY_ARCHIVEDLOG
where
inst_id = USERENV('Instance')