Articles Comments

AskDba.org Weblog » Archive for September 2008

Question:Sizing ASM LUN

September 8th, 2008 | Add a Comment

We received following question from Mr Orlando through our Contact Page How about a discussion on how to size our LUNS to use with ASM. For instance we have a Dell MD3000 with 44×300GB HDDs (protected by RAID-10) and we’re planning to create LUNs of 2TB on the Storage, and deliver them to Windows 2003. for ASM to use what is common around the world? Just pass the 2TB Luns to Windows or maybe create several 500GB and give them to ASM. This is a RAC10g install, Oracle 10g Standard Edition. Please find below our response to the question. We would also like to hear from others on their experiences and any other suggestions/opinions they may gave. Our Response As per 10gR2 ASM Best Practices document (available on ASM OTN Homepage), we can add … Read entire article »

Filed under: ASM, oracle

How To Recover From Corrupted OCR Disk

September 3rd, 2008 | 15 Comments

It is very common where a DBA is left with corrupted OCR disk without having any good backup. The same situation was experienced by me few days back. One node of RAC database shows the following: NODE1: $ORA_CRS_HOME/bin/crs_stat -t Name Type Target State Host ------------------------------------------------------------ ora.orcl.db application ONLINE ONLINE rac1 ora....11.inst application ONLINE ONLINE rac1 ora....12.inst application ONLINE OFFLINE ora....vice.cs application OFFLINE OFFLINE ora....l11.srv application ONLINE OFFLINE ora....l12.srv application ONLINE … Read entire article »

Filed under: oracle, rac

Issues with CLUSTER_DATABASE parameter

September 3rd, 2008 | Add a Comment

Yesterday, I faced an interesting scenario while upgrading 2 Node RAC Database. I tried setting up CLUSTER_DATABASE=FALSE in spfile from Node 1,but it displayed value as TRUE after restarting database.Same was true for Database startup entries in Alert log. If I did the same setting in Node 2 and started database from node 2, it started in shared mode.I was using shared spfile (on OCFS) for both the systems. CLUSTER_DATABASE is a Real Application Clusters parameter that specifies whether or not Real Application Clusters is enabled. It is mostly used for starting database in Exclusive mode during operations which will require updating dictionary. e.g Upgrading database,Enabling Archivelog and also for changing Database characterset. I had ignored this error  few times but today I wanted to find the cause and resolve it. To diagnose further, I … Read entire article »

Filed under: oracle, rac