Using database instance login, datafile found out there is a file, but found out through asm_file view to empty,
If use the ASM instance login, asm_file is can check out all of the files,
In the 11 g, whether the database instance and ASM instance, query asm_file are the same,
SQL> Select the name from v $datafile;
The NAME
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
286.970958433 + DATA/former/DATAFILE/system.
+ DATA/former/DATAFILE/sysaux. 287.970958473
+ DATA/former/DATAFILE/undotbs1.288.970958499
+ DATA/former/DATAFILE/undotbs2.299.970959001
289.970958501 + DATA/former/DATAFILE/users.
SQL> Select * from v $asm_file;
No rows selected