SELECT
  file#,
  error 
FROM
  v$recover_file;

FILE# 		ERROR
---------- 	---------------------------------------------
		4 	FILE NOT FOUND
		11 	FILE NOT FOUND
		
/*  v$datafile COM v$recover_file  */	
		
SELECT 
	file#, 
	name 
FROM
	v$datafile 
	join v$recover_file using (file#);

FILE# 		NAME
---------- 	----------------------------------------
		4 	/u05/oradata/ord/users01.dbf
		11 	/u08/oradata/ord/idx02.dbf