V$RECOVERY_FILE_STATUS

Columns
   ___________________________
 
   FILENAME
   STATUS
   FILENUM

Related Commands: