This content has been marked as final. Show 7 replies
There is no command to show what Database have files actives on ASM.
You can place on ASM only one File(like SPFILE) and the others on Filesystem.
And on ASM you can see some directory of that database but you don't have sure if it is used or not, some database are migrated from ASM to filesystem and the DBA dont remove the files of ASM.
The only way to know if that database have files on ASM or not is checking V$ of Database to see where is store these files.
Using ASMCMD utilty and command "lsct" you will get who (Database and others resource) is currently connect on ASM.
Edited by: Levi Pereira on Sep 20, 2012 3:57 PM
the datailfe, controlfile and sp parameters are obviously the defacto ways to get that infor but if the controlfile, FRA or spfile is located on ASM it will show up in the alert log at start time. Use the tac command to read from bottom of file. this will give you the last time the database was started. assuming of course you still have that info in the alert log and it hasnt been wiped/truncated/archived since last start.
cd to bdump and run following, obviously passing in your own alert log
tac alert_<sid>.log | egrep -i "db_create_file_dest|control_files|spfile" | more