RAC 修改 ASM实例名 的步骤

 

       DBCA 创建ASM实例时,会生成几个ASM实例,如+ASM1+ASM2 一般来说,安装好之后,是不需要修改ASM实例名的,但是一些特殊情况,还是需要修改的,就像我之前说的:

       RAC ASM 实例名 节点的对应关系

http://www.cndba.cn/Dave/article/950

       

 

       这个名称看上去就不一致,不是很直观。

[oracle@rac1 u01]$ sh crs_stat.sh

Name                           Target     State      Host     

------------------------------ ---------- ---------  -------  

ora.rac.db                     ONLINE     ONLINE     rac1     

ora.rac.rac1.inst              ONLINE     ONLINE     rac2     

ora.rac.rac2.inst              ONLINE     ONLINE     rac1     

--两个实例也是反的

ora.rac.taf.cs                 ONLINE     ONLINE     rac2     

ora.rac.taf.rac1.srv           ONLINE     ONLINE     rac2     

ora.rac.taf.rac2.srv           ONLINE     ONLINE     rac1     

ora.rac1.ASM2.asm              ONLINE     ONLINE     rac1     

ora.rac1.LISTENER_RAC1.lsnr    ONLINE     ONLINE     rac1     

ora.rac1.gsd                   ONLINE     ONLINE     rac1     

ora.rac1.ons                   ONLINE     ONLINE     rac1     

ora.rac1.vip                   ONLINE     ONLINE     rac1     

ora.rac2.ASM1.asm              ONLINE     ONLINE     rac2     

ora.rac2.LISTENER_RAC2.lsnr    ONLINE     ONLINE     rac2     

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2   

 

 

       在这篇Blog里,就是测试RAC下,ASM实例名的修改 2个节点的实例做下倒换。 也可以换成其他名字。 RAC 实例名的修改,放到下一篇

 

.  ASM 实例基本信

1.1 节点1信息

[oracle@rac1 u01]$ export ORACLE_SID=+ASM2

[oracle@rac1 u01]$ sqlplus / as sysdba;

 

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 24 20:49:07 2011

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

 

SQL> select instance_name,status,active_state from v$instance;

 

INSTANCE_NAME    STATUS       ACTIVE_ST

---------------- ------------ ---------

+ASM2            STARTED      NORMAL

 

SQL> show parameter instance

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

active_instance_count                integer

cluster_database_instances           integer     2

instance_groups                      string

instance_name                        string      +ASM2

instance_number                      integer     2

instance_type                        string      asm

open_links_per_instance              integer     4

parallel_instance_group              string

parallel_server_instances            integer     2

SQL>

 

1.2 节点2信息

[oracle@rac2 ~]$ export ORACLE_SID=+ASM1

[oracle@rac2 ~]$ sqlplus / as sysdba   

 

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Mar 24 20:53:02 2011

 

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production

With the Partitioning, Real Application Clusters, OLAP and Data Mining options

 

SQL>  select instance_name,status,active_state from v$instance;

 

INSTANCE_NAME    STATUS       ACTIVE_ST

---------------- ------------ ---------

+ASM1            STARTED      NORMAL

 

SQL> show parameter instance

 

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

active_instance_count                integer

cluster_database_instances           integer     2

instance_groups                      string

instance_name                        string      +ASM1

instance_number                      integer     1

instance_type                        string      asm

open_links_per_instance              integer     4

parallel_instance_group              string

parallel_server_instances            integer     2

SQL>

 

节点rac1 ASM 实例名:+ASM2.

节点rac2ASM 实例名:+ASM1

 

       有点怪异。 2ASM实例给换下。操作过程需要宕机。 所以在系统上线之前就把这些东西配置好。 上线之后就不要在乱动了。 稳定第一。

 

 

. 具体操作步骤:

2.1  在任一个节点上更新OCR

 

步骤如下

1Stop all the db instances that store their data in the asm instance you will be doing the maintenance:
        srvctl stop db -d <db name>

2Stop the asm instance:
        srvctl stop asm -n <node name>
3Remove asm dependencies for the db instance and unregister asm from the OCR:
        srvctl modify inst -d <db name> -i <db instance name> -r

        srvctl remove asm -n <node name>      

 

[oracle@rac1 u01]$ sh crs_stat.sh

Name                       Target     State      Host     

---------------------------------------- ---------- ---------  -------  

ora.rac.db                     ONLINE     ONLINE     rac1     

ora.rac.rac1.inst              ONLINE     ONLINE     rac2     

ora.rac.rac2.inst              ONLINE     ONLINE     rac1     

ora.rac.taf.cs                 ONLINE     ONLINE     rac2     

ora.rac.taf.rac1.srv            ONLINE     ONLINE     rac2     

ora.rac.taf.rac2.srv            ONLINE     ONLINE     rac1     

ora.rac1.ASM2.asm            ONLINE     ONLINE     rac1     

ora.rac1.LISTENER_RAC1.lsnr  ONLINE     ONLINE     rac1     

ora.rac1.gsd                  ONLINE     ONLINE     rac1     

ora.rac1.ons                  ONLINE     ONLINE     rac1     

ora.rac1.vip                  ONLINE     ONLINE     rac1     

ora.rac2.ASM1.asm            ONLINE     ONLINE     rac2     

ora.rac2.LISTENER_RAC2.lsnr  ONLINE     ONLINE     rac2     

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2     

[oracle@rac1 u01]$ srvctl stop db -d rac

[oracle@rac1 u01]$ srvctl stop asm -n rac1

[oracle@rac1 u01]$ srvctl stop asm -n rac2

[oracle@rac1 u01]$ sh crs_stat.sh

Name                           Target     State      Host     

------------------------------ ---------- ---------  -------  

ora.rac.db                     OFFLINE    OFFLINE             

ora.rac.rac1.inst              OFFLINE    OFFLINE             

ora.rac.rac2.inst              OFFLINE    OFFLINE             

ora.rac.taf.cs                 OFFLINE    OFFLINE             

ora.rac.taf.rac1.srv           OFFLINE    OFFLINE             

ora.rac.taf.rac2.srv           OFFLINE    OFFLINE             

ora.rac1.ASM2.asm              OFFLINE    OFFLINE             

ora.rac1.LISTENER_RAC1.lsnr    ONLINE     ONLINE     rac1     

ora.rac1.gsd                   ONLINE     ONLINE     rac1     

ora.rac1.ons                   ONLINE     ONLINE     rac1     

ora.rac1.vip                   ONLINE     ONLINE     rac1     

ora.rac2.ASM1.asm              OFFLINE    OFFLINE             

ora.rac2.LISTENER_RAC2.lsnr    ONLINE     ONLINE     rac2     

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2     

[oracle@rac1 u01]$ srvctl modify inst -d rac -i rac1 -r

[oracle@rac1 u01]$ srvctl modify inst -d rac -i rac2 -r

[oracle@rac1 u01]$ srvctl remove asm -n rac1           

[oracle@rac1 u01]$ srvctl remove asm -n rac2

[oracle@rac1 u01]$ sh crs_stat.sh

Name                       Target     State      Host     

------------------------------ ---------- ---------  -------  

ora.rac.db                   OFFLINE    OFFLINE             

ora.rac.rac1.inst              OFFLINE    OFFLINE             

ora.rac.rac2.inst              OFFLINE    OFFLINE             

ora.rac.taf.cs                 OFFLINE    OFFLINE             

ora.rac.taf.rac1.srv            OFFLINE    OFFLINE             

ora.rac.taf.rac2.srv            OFFLINE    OFFLINE             

ora.rac1.LISTENER_RAC1.lsnr ONLINE     ONLINE     rac1     

ora.rac1.gsd                 ONLINE     ONLINE     rac1     

ora.rac1.ons                 ONLINE     ONLINE     rac1     

ora.rac1.vip                 ONLINE     ONLINE     rac1     

ora.rac2.LISTENER_RAC2.lsnr ONLINE     ONLINE     rac2     

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2     

[oracle@rac1 u01]$

 

2.2 在所有节点上更新/etc/oratab 文件

Location of oratab on some platforms:
* For AIX, HP-UX, or Linux: /etc/oratab
* For Solaris: /var/opt/oracle/oratab

 

节点1

[oracle@rac1 u01]$ cat /etc/oratab | grep -v ^#

+ASM2:/u01/app/oracle/product/10.2.0/db_1:N

rac:/u01/app/oracle/product/10.2.0/db_1:N

 

修改之后:

[oracle@rac1 u01]$ cat /etc/oratab | grep -v ^#

+ASM1:/u01/app/oracle/product/10.2.0/db_1:N

rac:/u01/app/oracle/product/10.2.0/db_1:N

 

节点2

[oracle@rac2 ~]$ cat /etc/oratab |grep -v '^#'

+ASM1:/u01/app/oracle/product/10.2.0/db_1:N

rac:/u01/app/oracle/product/10.2.0/db_1:N

 

修改之后:

[oracle@rac2 ~]$ cat /etc/oratab |grep -v '^#'

+ASM2:/u01/app/oracle/product/10.2.0/db_1:N

rac:/u01/app/oracle/product/10.2.0/db_1:N

 

2.3 在所有节点上修改init 文件和orapw 文件

节点1

[oracle@rac1 u01]$ cd $ORACLE_HOME/dbs

[oracle@rac1 dbs]$ ls

ab_+ASM2.dat  hc_rac2.dat    initdw.ora  initrac2.ora  orapwrac2

hc_+ASM2.dat  init+ASM2.ora  init.ora    orapw+ASM2

[oracle@rac1 dbs]$ mv init+ASM2.ora init+ASM1.ora

[oracle@rac1 dbs]$ mv orapw+ASM2 orapw+ASM1      

[oracle@rac1 dbs]$ ls

ab_+ASM2.dat  hc_rac2.dat    initdw.ora  initrac2.ora  orapwrac2

hc_+ASM2.dat  init+ASM1.ora  init.ora    orapw+ASM1

 

节点2

[oracle@rac2 ~]$ cd $ORACLE_HOME/dbs

[oracle@rac2 dbs]$ ls

ab_+ASM1.dat  hc_rac1.dat    initdw.ora  initrac1.ora  orapwrac1

hc_+ASM1.dat  init+ASM1.ora  init.ora    orapw+ASM1

[oracle@rac2 dbs]$ mv init+ASM1.ora init+ASM2.ora

[oracle@rac2 dbs]$ mv orapw+ASM1 orapw+ASM2      

[oracle@rac2 dbs]$ ls

ab_+ASM1.dat  hc_rac1.dat    initdw.ora  initrac1.ora  orapwrac1

hc_+ASM1.dat  init+ASM2.ora  init.ora    orapw+ASM2

 

2.4 修改ASM pfile 参数

1If using a pfile:
       Replace any references to the old asm instance names with the new asm names. 
Example: 
+ASM1.instance_number=1 -- change to --> +ASMADC1.instance_number=1 

2If using an spfile:
       Connect to the ASM instance, and use SQL commands.
Example on node1 to remove the references to +ASM1: 
  SQL> alter system reset instance_number sid='+ASM1' scope=spfile;

Example on node1 to set the new value: 
  SQL> alter system set instance_number=1 sid='+ASMADC1' scope=spfile;

 

我配置RAC时使用的是pfile,所以需要在所有节点上都修改pfile参数。

 

节点1

[oracle@rac1 dbs]$ cat init+ASM1.ora |grep instance

instance_type=asm

+ASM2.instance_number=2

+ASM1.instance_number=1

 

修改之后:

[oracle@rac1 dbs]$ cat init+ASM1.ora |grep instance

instance_type=asm

+ASM1.instance_number=2

+ASM2.instance_number=1

 

节点2

[oracle@rac2 dbs]$ cat init+ASM2.ora |grep instance

instance_type=asm

+ASM2.instance_number=2

+ASM1.instance_number=1

 

修改之后:

[oracle@rac2 dbs]$ cat init+ASM2.ora |grep instance

instance_type=asm

+ASM1.instance_number=2

+ASM2.instance_number=1

 

2.5 清除相关的目录

       If using 10g, on each node remove any directories and files for the older ASM instance under:  $ORACLE_BASE/admin
       If using 11g, on each node remove any directories and files for the older ASM instance under: $ORACLE_BASE/diag/

   

       You may choose to back these first for historical purposes only.

[oracle@rac1 dbs]$ cd $ORACLE_BASE/admin

[oracle@rac1 admin]$ ls

+ASM  rac

 

这一步,我没有做,历史文件不影响,只是看上去比较乱。可以把相关目录(+ASM)下文件全部清空。

 

2.6 在任意一个节点更新OCR

Example to register the new ASM instance that will run in node1:
  srvctl add asm -n adc1 -i +ASMADC1 -o /c1/app/oracle/product/11.1.0.6/asm_1

       Where adc1 is node_name, +ASMADC1 is the new ASM instance name, and the value given to -o is the ORACLE_HOME for the asm instance.

 

       Register each database instance that stores their data in ASM, with the new ASM instance name.

Example:
  srvctl modify inst -d <db name> -i <instance name> -s +ASMADC<n>

 

具体操作:

[oracle@rac1 admin]$ srvctl add asm -n rac1 -i +ASM1 -o /u01/app/oracle/product/10.2.0/db_1

[oracle@rac1 admin]$ srvctl add asm -n rac2 -i +ASM2 -o /u01/app/oracle/product/10.2.0/db_1

[oracle@rac1 dbs]$ srvctl modify inst -d rac -i rac2 -s +ASM1

[oracle@rac1 dbs]$ srvctl modify inst -d rac -i rac1 -s +ASM2

 

注意: 不要被我这里的顺序误导,正常情况下,就是:

srvctl modify inst -d rac -i rac1 -s +ASM1

 

       我在建RAC的时候,因为安装顺序的问题,到时ASM实例反了。 开始我是按下面命令创建的:

[oracle@rac1 admin]$ srvctl modify inst -d rac -i rac1 -s +ASM1

PRKS-1019 : Cannot create CRS dependency between database instance "rac1" configured on node "rac2" and ASM instance "+ASM1" configured on node "rac1"

 

       但是报错了,后来才发现,我的RAC1 实例,是在rac2 节点上,这里应该就是我们主节点 由此也可以看出,ORACLE 会默认把安装Clusterware的节点作为节点1. 并且写入OCR中。

       我们这个实验只是测试一下ASM实例的修改,下次在测试下实例名修改的问题。 开始错了一步,后面的麻烦事真多啊。

 

[oracle@rac1 u01]$ sh crs_stat.sh

Name                           Target     State      Host     

------------------------------ ---------- ---------  -------  

ora.rac.db                     OFFLINE    OFFLINE              

ora.rac.rac1.inst              OFFLINE    OFFLINE             

ora.rac.rac2.inst              OFFLINE    OFFLINE             

ora.rac.taf.cs                 OFFLINE    OFFLINE             

ora.rac.taf.rac1.srv           OFFLINE    OFFLINE              

ora.rac.taf.rac2.srv           OFFLINE    OFFLINE             

ora.rac1.ASM1.asm              OFFLINE    OFFLINE             

ora.rac1.LISTENER_RAC1.lsnr    ONLINE     ONLINE     rac1     

ora.rac1.gsd                   ONLINE     ONLINE     rac1      

ora.rac1.ons                   ONLINE     ONLINE     rac1     

ora.rac1.vip                   ONLINE     ONLINE     rac1     

ora.rac2.ASM2.asm              OFFLINE    OFFLINE             

ora.rac2.LISTENER_RAC2.lsnr    ONLINE     ONLINE     rac2      

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2    

 

2.7 启动ASM实例

[oracle@rac1 u01]$ srvctl start asm -n rac1

[oracle@rac1 u01]$ srvctl start asm -n rac2

 

[oracle@rac1 u01]$ sh crs_stat.sh

Name                           Target     State      Host     

------------------------------ ---------- ---------  -------  

ora.rac.db                     OFFLINE    OFFLINE             

ora.rac.rac1.inst              OFFLINE    OFFLINE             

ora.rac.rac2.inst              OFFLINE    OFFLINE             

ora.rac.taf.cs                 OFFLINE    OFFLINE              

ora.rac.taf.rac1.srv           OFFLINE    OFFLINE             

ora.rac.taf.rac2.srv           OFFLINE    OFFLINE             

ora.rac1.ASM1.asm              ONLINE     ONLINE     rac1     

ora.rac1.LISTENER_RAC1.lsnr    ONLINE     ONLINE     rac1     

ora.rac1.gsd                   ONLINE     ONLINE     rac1     

ora.rac1.ons                   ONLINE     ONLINE     rac1     

ora.rac1.vip                   ONLINE     ONLINE     rac1     

ora.rac2.ASM2.asm              ONLINE     ONLINE     rac2     

ora.rac2.LISTENER_RAC2.lsnr    ONLINE     ONLINE     rac2     

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2     

 

       有点小兴奋,实例名和节点名总算对上号了。 不过实例名和节点还是反的。 杯具啊。 下次遇到这种问题,我会重新安装CRS来解决。

 

ASM 实例启动日志:

[oracle@rac1 bdump]$ pwd

/u01/app/oracle/admin/+ASM/bdump

[oracle@rac1 bdump]$ cat alert_+ASM1.log

Thu Mar 24 23:51:37 2011

Starting ORACLE instance (normal)

LICENSE_MAX_SESSION = 0

LICENSE_SESSIONS_WARNING = 0

Interface type 1 eth1 192.168.1.0 configured from OCR for use as a cluster interconnect

Interface type 1 eth0 192.168.2.0 configured from OCR for use as  a public interface

Shared memory segment for instance monitoring created

Picked latch-free SCN scheme 2

Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/oracle/product/10.2.0/db_1/dbs/arch

Autotune of undo retention is turned off.

LICENSE_MAX_USERS = 0

SYS auditing is disabled

ksdpec: called for event 13740 prior to event group initialization

Starting up ORACLE RDBMS Version: 10.2.0.1.0.

System parameters with non-default values:

  large_pool_size          = 12582912

  instance_type            = asm

  cluster_database         = TRUE

  instance_number          = 2

  remote_login_passwordfile= EXCLUSIVE

  background_dump_dest     = /u01/app/oracle/admin/+ASM/bdump

  user_dump_dest           = /u01/app/oracle/admin/+ASM/udump

  core_dump_dest           = /u01/app/oracle/admin/+ASM/cdump

  asm_diskstring           = /dev/mapper/datap1, /dev/mapper/frap1

  asm_diskgroups           = DATA, FRA

Cluster communication is configured to use the following interface(s) for this instance

  192.168.1.42

Thu Mar 24 23:51:38 2011

cluster interconnect IPC version:Oracle UDP/IP

IPC Vendor 1 proto 2

PMON started with pid=2, OS id=27438

DIAG started with pid=3, OS id=27441

PSP0 started with pid=4, OS id=27453

LMON started with pid=5, OS id=27455

LMD0 started with pid=6, OS id=27461

LMS0 started with pid=7, OS id=27466

MMAN started with pid=8, OS id=27476

DBW0 started with pid=9, OS id=27478

LGWR started with pid=10, OS id=27480

CKPT started with pid=11, OS id=27482

SMON started with pid=12, OS id=27484

RBAL started with pid=13, OS id=27486

GMON started with pid=14, OS id=27488

Thu Mar 24 23:51:38 2011

lmon registered with NM - instance id 2 (internal mem no 1)

Thu Mar 24 23:51:39 2011

Reconfiguration started (old inc 0, new inc 1)

ASM instance

List of nodes:

 1

 Global Resource Directory frozen

 Communication channels reestablished

 Master broadcasted resource hash value bitmaps

 Non-local Process blocks cleaned out

Thu Mar 24 23:51:39 2011

 LMS 0: 0 GCS shadows cancelled, 0 closed

 Set master node info

 Submitted all remote-enqueue requests

 Dwn-cvts replayed, VALBLKs dubious

 All grantable enqueues granted

 Post SMON to start 1st pass IR

Thu Mar 24 23:51:39 2011

 LMS 0: 0 GCS shadows traversed, 0 replayed

Thu Mar 24 23:51:39 2011

 Submitted all GCS remote-cache requests

 Post SMON to start 1st pass IR

 Fix write in gcs resources

Reconfiguration complete

LCK0 started with pid=15, OS id=27490

Thu Mar 24 23:51:39 2011

SQL> ALTER DISKGROUP ALL MOUNT

Thu Mar 24 23:51:39 2011

NOTE: cache registered group DATA number=1 incarn=0xf5e32eb6

NOTE: cache registered group FRA number=2 incarn=0xf5f32eb7

Thu Mar 24 23:51:39 2011

Loaded ASM Library - Generic Linux, version 2.0.4 (KABI_V2) library for asmlib interface

Thu Mar 24 23:51:39 2011

NOTE: Hbeat: instance first (grp 1)

Thu Mar 24 23:51:40 2011

NOTE: Hbeat: instance first (grp 2)

Thu Mar 24 23:51:44 2011

NOTE: start heartbeating (grp 1)

NOTE: cache opening disk 0 of grp 1: DATA path:/dev/mapper/datap1

Thu Mar 24 23:51:44 2011

NOTE: F1X0 found on disk 0 fcn 0.0

NOTE: cache mounting (first) group 1/0xF5E32EB6 (DATA)

* allocate domain 1, invalid = TRUE

Thu Mar 24 23:51:44 2011

NOTE: attached to recovery domain 1

Thu Mar 24 23:51:44 2011

NOTE: cache recovered group 1 to fcn 0.2777

Thu Mar 24 23:51:44 2011

NOTE: opening chunk 1 at fcn 0.2777 ABA

NOTE: seq=5 blk=139

Thu Mar 24 23:51:44 2011

NOTE: cache mounting group 1/0xF5E32EB6 (DATA) succeeded

SUCCESS: diskgroup DATA was mounted

Thu Mar 24 23:51:45 2011

NOTE: start heartbeating (grp 2)

NOTE: cache opening disk 0 of grp 2: FRA_0000 path:/dev/mapper/frap1

Thu Mar 24 23:51:45 2011

NOTE: F1X0 found on disk 0 fcn 0.0

NOTE: cache mounting (first) group 2/0xF5F32EB7 (FRA)

* allocate domain 2, invalid = TRUE

Thu Mar 24 23:51:45 2011

NOTE: attached to recovery domain 2

Thu Mar 24 23:51:45 2011

NOTE: cache recovered group 2 to fcn 0.1677

Thu Mar 24 23:51:45 2011

NOTE: opening chunk 1 at fcn 0.1605 ABA

NOTE: seq=4 blk=69

Thu Mar 24 23:51:45 2011

NOTE: cache mounting group 2/0xF5F32EB7 (FRA) succeeded

SUCCESS: diskgroup FRA was mounted

Thu Mar 24 23:51:47 2011

NOTE: recovering COD for group 1/0xf5e32eb6 (DATA)

SUCCESS: completed COD recovery for group 1/0xf5e32eb6 (DATA)

NOTE: recovering COD for group 2/0xf5f32eb7 (FRA)

SUCCESS: completed COD recovery for group 2/0xf5f32eb7 (FRA)

Thu Mar 24 23:51:58 2011

Reconfiguration started (old inc 1, new inc 2)

List of nodes:

 0 1

 Global Resource Directory frozen

 Communication channels reestablished

 * domain 1 valid = 1 according to instance 0

 * domain 2 valid = 1 according to instance 0

Thu Mar 24 23:51:59 2011

 Master broadcasted resource hash value bitmaps

 Non-local Process blocks cleaned out

Thu Mar 24 23:51:59 2011

 LMS 0: 0 GCS shadows cancelled, 0 closed

 Set master node info

 Submitted all remote-enqueue requests

 Dwn-cvts replayed, VALBLKs dubious

 All grantable enqueues granted

Thu Mar 24 23:51:59 2011

 LMS 0: 18 GCS shadows traversed, 0 replayed

Thu Mar 24 23:51:59 2011

 Submitted all GCS remote-cache requests

 Fix write in gcs resources

Reconfiguration complete

[oracle@rac1 bdump]$

 

2.8 启动数据库

 

[oracle@rac1 bdump]$ srvctl start db -d rac

[oracle@rac1 bdump]$ cd /u01

[oracle@rac1 u01]$ sh crs_stat.sh

Name                           Target     State      Host     

------------------------------ ---------- ---------  -------  

ora.rac.db                     ONLINE     ONLINE     rac1     

ora.rac.rac1.inst              ONLINE     ONLINE     rac2     

ora.rac.rac2.inst              ONLINE     ONLINE     rac1     

ora.rac.taf.cs                 OFFLINE    OFFLINE             

ora.rac.taf.rac1.srv           OFFLINE    OFFLINE             

ora.rac.taf.rac2.srv           OFFLINE    OFFLINE             

ora.rac1.ASM1.asm              ONLINE     ONLINE     rac1     

ora.rac1.LISTENER_RAC1.lsnr    ONLINE     ONLINE     rac1     

ora.rac1.gsd                   ONLINE     ONLINE     rac1     

ora.rac1.ons                   ONLINE     ONLINE     rac1     

ora.rac1.vip                   ONLINE     ONLINE     rac1     

ora.rac2.ASM2.asm              ONLINE     ONLINE     rac2     

ora.rac2.LISTENER_RAC2.lsnr    ONLINE     ONLINE     rac2     

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2     

[oracle@rac1 u01]$ crs_start ora.rac.taf.cs

Attempting to start `ora.rac.taf.cs` on member `rac2`

Start of `ora.rac.taf.cs` on member `rac2` succeeded.

 

[oracle@rac1 u01]$ sh crs_stat.sh

Name                           Target     State      Host     

------------------------------ ---------- ---------  -------  

ora.rac.db                     ONLINE     ONLINE     rac1     

ora.rac.rac1.inst              ONLINE     ONLINE     rac2     

ora.rac.rac2.inst              ONLINE     ONLINE     rac1     

--还是反过来的

ora.rac.taf.cs                 ONLINE     ONLINE     rac2     

ora.rac.taf.rac1.srv           ONLINE     ONLINE     rac2     

ora.rac.taf.rac2.srv           ONLINE     ONLINE     rac1     

ora.rac1.ASM1.asm              ONLINE     ONLINE     rac1     

ora.rac1.LISTENER_RAC1.lsnr    ONLINE     ONLINE     rac1     

ora.rac1.gsd                   ONLINE     ONLINE     rac1     

ora.rac1.ons                   ONLINE     ONLINE     rac1     

ora.rac1.vip                   ONLINE     ONLINE     rac1     

ora.rac2.ASM2.asm              ONLINE     ONLINE     rac2     

ora.rac2.LISTENER_RAC2.lsnr    ONLINE     ONLINE     rac2     

ora.rac2.gsd                   ONLINE     ONLINE     rac2     

ora.rac2.ons                   ONLINE     ONLINE     rac2     

ora.rac2.vip                   ONLINE     ONLINE     rac2   

 

 

       至此,RACASM实例名,已经修改成功了。 但是RAC 实例名和节点名还是反过来的。 明天在做个测试,把RAC的实例名也修改一下。

 

       也就是为了好奇。 顺便做下测试。不过记住了一点,安装RAC的时候,从第一个节点开始安装。 不然后面会比较麻烦。

       有空还是希望能研究透CRS,看看CRS 是如何控制这个节点顺序的。

 

 

 

 

 

 

---------------------------------------------------------------------------------------------------

QQ: 492913789

Email: ahdba@qq.com

Blog: http://www.cndba.cn/dave



DBA1 群:62697716(); DBA2 群:62697977() DBA3 群:62697850()  

DBA 超级群:63306533(); DBA4 群: 83829929 DBA5群: 142216823

聊天 群:40132017

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值