InstallationOracle11gR2RACOneNode---测试一

第六章、测试

成都创新互联是一家专业提供滨海新区企业网站建设,专注与成都网站设计、网站建设、外贸网站建设、H5开发、小程序制作等业务。10年已为滨海新区众多企业、政府机构等服务。创新互联专业网站建设公司优惠进行中。

6.1查看rac one node信息

节点1

grid@node1:~> srvctl config database -d ORACLE

Database unique name: ORACLE

Database name: ORACLE

Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/ORACLE/spfileORACLE.ora

Domain:

Start options: open

Stop options: immediate

Database role:PRIMARY

Management policy: AUTOMATIC

Server pools: ORACLE

Database instances:

Disk Groups: DATA,FRA

Mount point paths:

Services: ORACLESER

Type: RACOneNode

Online relocation timeout: 30

Instance name prefix: ORACLE

Candidate servers:node1,node2

Database is administrator managed

grid@node1:~> crsctl stat res -t

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

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

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

Local Resources

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

ora.DATA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.FRA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.LISTENER.lsnr

               ONLINE  ONLINE      node1                                        

               ONLINE  ONLINE      node2                                       

ora.OCR_VOTE.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                        

ora.asm

               ONLINE  ONLINE      node1                   Started            

               ONLINE  ONLINE      node2                   Started            

ora.gsd

               OFFLINEOFFLINE      node1                                        

               OFFLINEOFFLINE      node2                                       

ora.net1.network

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.ons

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.registry.acfs

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE ONLINE       node2                                       

ora.cvu

      1        ONLINE ONLINE       node2                                        

ora.node1.vip

      1        ONLINE ONLINE       node1                                       

ora.node2.vip

      1        ONLINE ONLINE       node2                                       

ora.oc4j

      1        ONLINE ONLINE       node2                                        

ora.oracle.db

      1        ONLINE ONLINE       node1                    Open               

ora.oracle.oracleser.svc

      1        ONLINE ONLINE       node1                                       

ora.scan1.vip

      1        ONLINE ONLINE       node2                                       

grid@node1:~> srvctl status database -d ORACLE

Instance ORACLE_1 is running on node node1

Online relocation: INACTIVE

grid@node1:~>

oracle@node1:~> sqlplus /nolog

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 25 18:01:492015

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

SQL> conn /as sysdba

Connected.

SQL> show parameter cluster_database;

NAME                                 TYPE        VALUE

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

cluster_database                     boolean     TRUE

cluster_database_instances           integer     2

SQL> show parameter name

NAME                                 TYPE        VALUE

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

cell_offloadgroup_name               string

db_file_name_convert                 string

db_name                              string      ORACLE

db_unique_name                      string      ORACLE

global_names                         boolean     FALSE

instance_name                        string      ORACLE_1

lock_name_space                      string

log_file_name_convert                string

processor_group_name                 string

service_names                        string      ORACLESER

SQL>

节点2

grid@node2:~> srvctl config database -d ORACLE

Database unique name: ORACLE

Database name: ORACLE

Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1

Oracle user: oracle

Spfile: +DATA/ORACLE/spfileORACLE.ora

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Server pools: ORACLE

Database instances:

Disk Groups: DATA,FRA

Mount point paths:

Services: ORACLESER

Type: RACOneNode

Online relocation timeout: 30

Instance name prefix: ORACLE

Candidate servers:node1,node2

Database is administrator managed

grid@node2:~> crsctl stat res -t

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

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

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

Local Resources

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

ora.DATA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.FRA.dg

               ONLINE  ONLINE      node1                                        

               ONLINE  ONLINE      node2                                       

ora.LISTENER.lsnr

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                        

ora.OCR_VOTE.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.asm

               ONLINE  ONLINE      node1                    Started            

               ONLINE  ONLINE      node2                   Started            

ora.gsd

               OFFLINEOFFLINE      node1                                       

               OFFLINEOFFLINE      node2                                        

ora.net1.network

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.ons

               ONLINE  ONLINE       node1                                       

               ONLINE  ONLINE      node2                                       

ora.registry.acfs

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE ONLINE       node2                                       

ora.cvu

      1        ONLINE ONLINE       node2                                       

ora.node1.vip

      1        ONLINE ONLINE       node1                                        

ora.node2.vip

      1        ONLINE ONLINE       node2                                       

ora.oc4j

      1        ONLINE ONLINE       node2                                       

ora.oracle.db

      1       ONLINE  ONLINE       node1                    Open               

ora.oracle.oracleser.svc

      1        ONLINE ONLINE       node1                                       

ora.scan1.vip

      1        ONLINE ONLINE       node2                                       

grid@node2:~> srvctl status database -d ORACLE

Instance ORACLE_1 is running on node node1

Online relocation: INACTIVE

grid@node2:~>

此时，实例ORACLE_1运行于节点1上。

6.2 Kill Pmon

在节点1杀死pmon进程，查看数据库状态。

node1:~ # ps -ef|grep pmon

grid       4452      1 0 17:56 ?        00:00:00asm_pmon_+ASM1

oracle     5282      1 0 17:57 ?        00:00:00ora_pmon_ORACLE_1

root       6741   4259 0 18:03 pts/0    00:00:00 greppmon

node1:~ # kill -9 5282

node1:~ # su - grid

grid@node1:~> crsctl stat res -t

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

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

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

Local Resources

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

ora.DATA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                        

ora.FRA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.LISTENER.lsnr

               ONLINE  ONLINE      node1                                        

               ONLINE  ONLINE      node2                                       

ora.OCR_VOTE.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                        

ora.asm

               ONLINE  ONLINE      node1                   Started            

               ONLINE  ONLINE      node2                   Started            

ora.gsd

               OFFLINEOFFLINE      node1                                       

               OFFLINEOFFLINE      node2                                       

ora.net1.network

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.ons

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.registry.acfs

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE ONLINE       node2                                       

ora.cvu

      1        ONLINE ONLINE       node2                                       

ora.node1.vip

      1        ONLINE ONLINE       node1                                       

ora.node2.vip

      1        ONLINE ONLINE       node2                                       

ora.oc4j

      1       ONLINE  ONLINE       node2                                       

ora.oracle.db

      1        ONLINE OFFLINE                              Abnormal Terminatio

                                                            n,CLEANING         

ora.oracle.oracleser.svc

      1        ONLINE OFFLINE                                                  

ora.scan1.vip

      1        ONLINE ONLINE       node2                                       

grid@node1:~>

等待一分钟再次查看

grid@node1:~> crsctl stat res -t

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

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

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

Local Resources

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

ora.DATA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.FRA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.LISTENER.lsnr

               ONLINE  ONLINE      node1                                        

               ONLINE  ONLINE      node2                                       

ora.OCR_VOTE.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                        

ora.asm

               ONLINE  ONLINE      node1                   Started            

               ONLINE  ONLINE      node2                   Started            

ora.gsd

               OFFLINEOFFLINE      node1                                       

               OFFLINEOFFLINE      node2                                       

ora.net1.network

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.ons

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.registry.acfs

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE ONLINE       node2                                       

ora.cvu

      1        ONLINE ONLINE       node2                                       

ora.node1.vip

      1        ONLINE ONLINE       node1                                       

ora.node2.vip

      1        ONLINE ONLINE       node2                                       

ora.oc4j

      1       ONLINE  ONLINE       node2                                       

ora.oracle.db

      1        ONLINE ONLINE       node1                    Open               

ora.oracle.oracleser.svc

      1        ONLINE ONLINE       node1                                       

ora.scan1.vip

      1        ONLINE ONLINE       node2                                       

grid@node1:~>

杀死PMON进程后，不发生切换，将会在本机重启进程。

6.3 Relocate数据库

node1:/u01/app/11.2.0/grid/bin # ./srvctl relocate database -dORACLE -n node2

grid@node1:~> srvctl status database -d oracle

Instance ORACLE_1is running on node node1

Online relocation:ACTIVE

Source instance:ORACLE_1 on node1

Destinationinstance: ORACLE_2 on node2

grid@node1:~> crsctl stat res -t

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

NAME           TARGET  STATE       SERVER                  STATE_DETAILS      

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

Local Resources

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

ora.DATA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.FRA.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.LISTENER.lsnr

               ONLINE  ONLINE      node1                                        

               ONLINE  ONLINE      node2                                       

ora.OCR_VOTE.dg

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.asm

               ONLINE  ONLINE      node1                   Started            

               ONLINE  ONLINE      node2                   Started            

ora.gsd

               OFFLINE OFFLINE      node1                                       

               OFFLINEOFFLINE      node2                                       

ora.net1.network

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.ons

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

ora.registry.acfs

               ONLINE  ONLINE      node1                                       

               ONLINE  ONLINE      node2                                       

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

Cluster Resources

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

ora.LISTENER_SCAN1.lsnr

      1        ONLINE ONLINE       node2                                       

ora.cvu

      1        ONLINE ONLINE       node2                                        

ora.node1.vip

      1        ONLINE ONLINE       node1                                       

ora.node2.vip