测试RAC1、2切换(1)

最新推荐文章于 2024-05-23 18:28:57 发布

crfb86846

最新推荐文章于 2024-05-23 18:28:57 发布

阅读量197

点赞数

文章标签：数据库网络

前提条件：
1.服务器、客户端通讯是否正常
rac2-> crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   application    ONLINE    ONLINE    rac1
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2
ora.snowdb.db application    ONLINE    ONLINE    rac2
ora....rtdb.cs application    ONLINE    ONLINE    rac1
ora....db1.srv application    ONLINE    ONLINE    rac2
ora....b1.inst application    ONLINE    ONLINE    rac1
ora....b2.inst application    ONLINE    ONLINE    rac2
2.客户端配置tnsname.ora能正确连接到服务器上
例: 配置（摘抄服务器上的服务）如下：
TESTRAC =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.99.205)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.99.206)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SNOWDB)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
)

连接如下：
D:\>sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Mon Oct 5 13:53:32 2009
(c) Copyright 2000 Oracle Corporation. All rights reserved.
SQL> conn ctms/ctms@testrac
Connected.
SQL> show parameter service
NAME                                 TYPE    VALUE
------------------------------------ ------- ------------------------------
service_names                        string snowdb, portdb
SQL> select instance_name from v$instance;
INSTANCE_NAME
----------------
snowdb2
说明此时正在提供服务是在snowdb2上

   2.切换实施（RAC技术的话，就是两个或多个实例来支持一个服务器。）
   此时连到RAC2上去查看产关闭这个实例，看是否能自动在切换过去
rac2-> sqlplus / as sysdba@snowdb2
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Oct 5 13:56:07 2009
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> show parameter service ;
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      snowdb, portdb
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options
rac2-> crs_stat -t
Name           Type           Target    State     Host
------------------------------------------------------------
ora....SM1.asm application    ONLINE    ONLINE    rac1
ora....C1.lsnr application    ONLINE    ONLINE    rac1
ora.rac1.gsd   application    ONLINE    ONLINE    rac1
ora.rac1.ons   application    ONLINE    ONLINE    rac1
ora.rac1.vip   application    ONLINE    ONLINE    rac1
ora....SM2.asm application    ONLINE    ONLINE    rac2
ora....C2.lsnr application    ONLINE    ONLINE    rac2
ora.rac2.gsd   application    ONLINE    ONLINE    rac2
ora.rac2.ons   application    ONLINE    ONLINE    rac2
ora.rac2.vip   application    ONLINE    ONLINE    rac2
ora.snowdb.db application    ONLINE    ONLINE    rac2
ora....rtdb.cs application    ONLINE    ONLINE    rac1
ora....db1.srv application    ONLINE    ONLINE    rac1
ora....b1.inst application    ONLINE    ONLINE    rac1
ora....b2.inst application    OFFLINE   OFFLINE

再到客户端去查看下提供服务的实例