RAC的浅显使用

一、测试透明故障切换

 

1.创建CRM服务

 通过DBCA创建CRM服务

 

2.连接devdb1，查看服务

 

 conn system/oracle@devdb1

 show parameter service

 

QL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      devdb, CRM

 

3.连接devdb2,查看服务 

 

 conn system/oracle@devdb2

 show parameter service

 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      devdb

 

4.连接CRM服务

conn system/oracle@CRM

执行：

SQL> select instance_number instance#,
  2  instance_name,
  3  host_name,
  4  status
  5  from v$instance; 

 INSTANCE# INSTANCE_NAME    HOST_NAME                                                        STATUS
---------- ---------------- ---------------------------------------------------------------- ------------
         1 devdb1           rac1                                                             OPEN

 

SQL> select failover_type,failover_method,failed_over from v$session where username='SYSTEM';

FAILOVER_TYPE FAILOVER_M FAI
------------- ---------- ---
SELECT        BASIC      NO

 

5.关闭数据库devdb1

conn / as sysdba

shutdown abort

 

6.再次查询

SQL> select instance_number instance#,
  2  instance_name,
  3  host_name,
  4  status
  5  from v$instance; 

 INSTANCE# INSTANCE_NAME    HOST_NAME                                                        STATUS
---------- ---------------- ---------------------------------------------------------------- ------------
         1 devdb1           rac2                                                             OPEN

 

SQL> select failover_type,failover_method,failed_over from v$session where username='SYSTEM';

FAILOVER_TYPE FAILOVER_M FAI
------------- ---------- ---
SELECT        BASIC      NO
NONE          NONE       NO

 

7.手动转到devdb1

 启动数据库 startup

在rac1上查看

SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      devdb

 

在rac2上查看

 

SQL> show parameter service       

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      devdb, CRM

 

8.恢复CRM到devdb1上

rac1-> srvctl relocate service -d devdb -s crm -i devdb2 -t devdb1

 

9.查看服务

 RAC1上查看

SQL> show parameter service

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      devdb, CRM

 

RAC2查看

SQL> show parameter service                   

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      devdb

 

二、OEM管理RAC

 1.开启和关闭OEM

 

  emctl stop dbconsole

  emctl start dbconsole

 

 2.其它命令

 emctl status dbconsole

 emctl status agent

 

 三、RAC的基本操作

 crs_stat -t  ----查看后台进程

srv ctl status nodeapps -n rac1

srvctl status nodeapps -n rac2 -----节点状态

srvctl status asm -n rac1

srvctl status asm -b rac2   ----------asm状态

srvctl status database -d oracle_sid -------数据库状态

srvctl status service -d oracle_sid   ----------服务状态

crsctl check crs ----查看crs状态

select instance_name,host_name,archiver,thread#,status from gv$instance;