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 -- REGISTER VARCHAR2(3) (ADREG, 0, 'NO', 'YES'), 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 -- AFFIRM VARCHAR2(3) (ADAFF, 0, 'NO', 'YES'), 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 -- VERIFY VARCHAR2(3) (ADVER, 0, 'NO', 'YES') from x$kcrrdest

home |  up  |  mailbox