VIEW: SYS.GV_$RECOVER_FILE

Source

View Text - Preformatted

select "INST_ID","FILE#","ONLINE","ONLINE_STATUS","ERROR","CHANGE#","TIME","CON_ID" from gv$recover_file

View Text - HTML Formatted

SELECT "INST_ID"
, "FILE#"
, "ONLINE"
, "ONLINE_STATUS"
, "ERROR"
, "CHANGE#"
, "TIME"
, "CON_ID"
FROM GV$RECOVER_FILE