This content has been marked as final. Show 7 replies
Query on v$controlfile, v$datafile, v$tempfile, v$logfile, v$block_change_tracking and "show parameter db_recovery_file_dest, spfile" of each database.
As my knowledge using
$ORACLE_HOME/bin/./srvctl status ASM
we can check the asm is running or not for a database.
But my question is how we can check for 5 database at a time in LINUX environment.
Is there any specific command to check that?
Hi,1 person found this helpful
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
For this u have to manully login in to ur DB and check through
select name from v$datafile;
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
Log into the ASM instance and query the view v$ASM_CLIENT
It's true for 11g
ASMCMD> lsct -g