V$RECOVERY_FILE_STATUS
Columns ___________________________ FILENUM FILENAME STATUS
Related:
Simon Sheppard SS64.com