Thursday, September 07, 2006

crs_stat Utility

I am in Geneva this week, teaching part of a RAC 10g class at the World Trade Center togehter with Tamás Kerepes from Budapest. He is an enormously skilled collegue of mine and I am happy to get to know him.

I have demonstrated the migration of an entire cluster database from OCFS to ASM life in the class yesterday, including all datafiles, redologs, controlfiles, spfile and backups. This was a really thrilling and a little tricky process, but I succeeded at the end!I will post about the procedure soon.

I came across a nice little option for the crs_stat utility which I was not aware of and which Tamás pointed out to me:crs_stat -t gives a short listing of the contents of the cluster registry rather than the long listing of the simply scr_stat without the -f.This can come in very handy with a large cluster registry!Look at the difference!Here is a demo:[oracle@ed-toraclin9a oracle]$ crs_stat --helpUsage: crs_stat [resource_name [...]] [-v] [-l] [-q] [-c cluster_member] crs_stat [resource_name [...]] -t [-v] [-q] [-c cluster_member] crs_stat -p [resource_name [...]] [-q] crs_stat [-a] application -g crs_stat [-a] application -r [-c cluster_member] crs_stat -f [resource_name [...]] [-q] [-c cluster_member] crs_stat -ls [resource_name [...]] [-q][oracle@ed-toraclin9a oracle]$ crs_statNAME=ora.RDBB.RDBB1.instTYPE=applicationTARGET=ONLINESTATE=ONLINE on ed-toraclin9a

NAME=ora.RDBB.RDBB2.instTYPE=applicationTARGET=ONLINESTATE=ONLINE on ed-toraclin9b

NAME=ora.RDBB.dbTYPE=applicationTARGET=ONLINESTATE=ONLINE on ed-toraclin9b

NAME=ora.ed-toraclin9a.ASM1.asmTYPE=applicationTARGET=ONLINESTATE=ONLINE on ed-toraclin9a