We have a lot of datafiles in our multiple databases residing on same ASM. We create new datafiles with the alias name and access them using aliases from the database. We have a requirement to list all datafiles alias with the actual physical file on the ASM. I have tried to retrieving this information from V$ASM_ALIAS, but not able to find. Can you please help how I can get this information. Sample output needs to be as follows
alias_name file_name
-------------- ----------------------------
+DATA/db/mydb01.dbf +DATA/my_db/DATAFILES/mydb01.98.987689998
Getting alias names from v$datafiles, and then using ASMCMD to get the list where each alias is pointing to is quite lengthy process, and I want to use some oracle views to get this information if possible
SAQ