Re: question about upgrade to 11gR2 RAC

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 16 Jun 2010 00:27:35 +0000 (UTC)
Message-ID: <hv95pn$m1t$4_at_news.eternal-september.org>

On Tue, 15 Jun 2010 21:35:17 +0200, Frank van Bortel wrote:

> ASM to ASM cluster

Well, you don't have much choice when we're talking about RAC. I heard horror stories about OCFS and corruption although I have experienced no such thing. On the other hand, the company that I work for is maintaining 3 node RAC on ASM for a few years now and we didn't have any problems with it.
 1 select instance_number,instance_name,version,status   2* from gv$instance
SQL> / INSTANCE_NUMBER INSTANCE_NAME VERSION STATUS

--------------- ---------------- ----------------- ------------
              1 ADPRD1           10.2.0.4.0        OPEN
              3 ADPRD3           10.2.0.4.0        OPEN
              2 ADPRD2           10.2.0.4.0        OPEN

SQL> select group_number,name,state,total_mb   2 from v$asm_diskgroup
  3 /

GROUP_NUMBER NAME                           STATE         TOTAL_MB
------------ ------------------------------ ----------- ----------
           1 DGDATA                         CONNECTED      2465760
           2 DGFRA                          CONNECTED       698357
           3 DGREDO                         CONNECTED       147454

SQL> select * from v$version;

BANNER

---

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for Linux: Version 10.2.0.4.0 - Production NLSRTL Version 10.2.0.4.0 - Production

SQL> select inst_id,startup_time from gv$instance;

   INST_ID STARTUP_T

---------- ---------
         1 28-MAR-10
         3 28-MAR-10
         2 28-MAR-10

ASM on a RAC cluster functions reliably and fast. I am looking forward to upgrading to 11g which supports larger allocation units.

-- 
http://mgogala.byethost5.com

Received on Tue Jun 15 2010 - 19:27:35 CDT