GV$CONTROLFILE select inst_id, -- INST_ID NUMBER decode -- STATUS VARCHAR2(7) (bitand (cfflg, 1), 0, '', 1, 'INVALID'), cfnam, -- NAME VARCHAR2(513) decode -- IS_RECOVERY_DEST_FILE VARCHAR2(3) (bitand (cffl2, 1), 0, 'NO', 'YES') from x$kcccf