GV$ARCHIVE_DEST definition in Oracle Database 11.2
GV$ARCHIVE_DEST

select
  inst_id,                                 -- INST_ID NUMBER
  to_number(ADDID),                        -- DEST_ID NUMBER
  ADDXX,                                   -- DEST_NAME VARCHAR2(256)
  decode(                                  -- STATUS VARCHAR2(9)
    ADSTS,1,'VALID', 2,'INACTIVE', 3,'DEFERRED', 4,'ERROR', 5,'DISABLED', 6,'BAD PARAM', 7,'ALTERNATE', 8,'FULL', 'UNKNOWN'),
  decode(                                  -- BINDING VARCHAR2(9)
    ADMND,0,'OPTIONAL','MANDATORY'),
  decode(                                  -- NAME_SPACE VARCHAR2(7)
    ADSES,0,'SYSTEM','SESSION'),
  decode(                                  -- TARGET VARCHAR2(7)
    ADRMT,0,'PRIMARY', 1,'STANDBY', 2,'LOCAL', 3,'REMOTE', 'UNKNOWN'),
  decode(                                  -- ARCHIVER VARCHAR2(10)
    ADPRC,0,'ARCH', 1,'LGWR', 2,'FOREGROUND', 3,'RFS', 4,'ONDEMAND', 'UNKNOWN'),
  decode(                                  -- SCHEDULE VARCHAR2(8)
    ADSCH,0,'INACTIVE', 1,'PENDING', 2,'ACTIVE', 3,'LATENT', 'UNKNOWN'),
  decode(                                  -- DESTINATION VARCHAR2(256)
    ADOMF, 0, ADDNM, 'USE_DB_RECOVERY_FILE_DEST'),
  to_number(ADLSQ),                        -- LOG_SEQUENCE NUMBER
  to_number(ADROP),                        -- REOPEN_SECS NUMBER
  to_number(ADDLY),                        -- DELAY_MINS NUMBER
  to_number(ADMCS),                        -- MAX_CONNECTIONS NUMBER
  to_number(ADNTT),                        -- NET_TIMEOUT NUMBER
  decode(                                  -- PROCESS VARCHAR2(10)
    ADWHO,0,'ARCH', 1,'LGWR', 2,'FOREGROUND', 3,'RFS', 4,'ONDEMAND', 'UNKNOWN'),
  decode(ADREG,0,'NO','YES'),              -- REGISTER VARCHAR2(3)
  to_date(                                 -- FAIL_DATE DATE
    ADFDT,'MM/DD/RR HH24:MI:SS','NLS_CALENDAR=Gregorian'),
  to_number(ADFSQ),                        -- FAIL_SEQUENCE NUMBER
  to_number(ADFBK),                        -- FAIL_BLOCK NUMBER
  to_number(ADFCT),                        -- FAILURE_COUNT NUMBER
  to_number(ADMXF),                        -- MAX_FAILURE NUMBER
  ADFER,                                   -- ERROR VARCHAR2(256)
  ADALT,                                   -- ALTERNATE VARCHAR2(256)
  ADDPD,                                   -- DEPENDENCY VARCHAR2(256)
  ADRFT,                                   -- REMOTE_TEMPLATE VARCHAR2(256)
  to_number(ADQSZ),                        -- QUOTA_SIZE NUMBER
  to_number(ADQSD),                        -- QUOTA_USED NUMBER
  ADMID,                                   -- MOUNTID NUMBER
  decode(                                  -- TRANSMIT_MODE VARCHAR2(12)
    ADLAB,0, decode(ADPAR,0,'SYNCHRONOUS', 'PARALLELSYNC'), 'ASYNCHRONOUS'),
  to_number(ADLAB),                        -- ASYNC_BLOCKS NUMBER
  decode(ADAFF,0,'NO','YES'),              -- AFFIRM VARCHAR2(3)
  decode(                                  -- TYPE VARCHAR2(7)
    ADDTG,0,'PUBLIC','PRIVATE'),
  decode(                                  -- VALID_NOW VARCHAR2(16)
    ADNOW,1,'YES', 2,'WRONG VALID_TYPE', 3,'WRONG VALID_ROLE', 4,'INACTIVE', 'UNKNOWN'),
  decode(                                  -- VALID_TYPE VARCHAR2(15)
    ADVLD,11,'ONLINE_LOGFILE', 12,'ONLINE_LOGFILE', 13,'ONLINE_LOGFILE', 21,'STANDBY_LOGFILE', 22,'STANDBY_LOGFILE', 23,'STANDBY_LOGFILE', 31,'ALL_LOGFILES', 32,'ALL_LOGFILES', 33,'ALL_LOGFILES', 'UNKNOWN'),
  decode(                                  -- VALID_ROLE VARCHAR2(12)
    ADVLD,11,'PRIMARY_ROLE', 12,'STANDBY_ROLE', 13,'ALL_ROLES', 21,'PRIMARY_ROLE', 22,'STANDBY_ROLE', 23,'ALL_ROLES', 31,'PRIMARY_ROLE', 32,'STANDBY_ROLE', 33,'ALL_ROLES', 'UNKNOWN'),
  ADDBUN,                                  -- DB_UNIQUE_NAME VARCHAR2(30)
  decode(ADVER,0,'NO','YES'),              -- VERIFY VARCHAR2(3)
  decode(                                  -- COMPRESSION VARCHAR2(7)
    ADCMP,0,'DISABLE','ENABLE') 
from
  x$krstdest

home |  up