1、删除RAC中其他实例,保证RAC中只有一个实例
$ su - oracle
$ srvctl config database -d jzh
Database unique name: jzh
Database name: jzh
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/jzh/spfilejzh.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: jzh
Database instances: jzh_1,jzh_2
Disk Groups: DATA,ARCH
Mount point paths:
Services: jzhdb
Type: RAC
Database is administrator managed
$ srvctl stop instance -d jzh -i jzh_2
$ srvctl remove instance -d jzh -i jzh_2
Remove instance from the database jzh? (y/[n]) y
$ srvctl config database -d jzh
Database unique name: jzh
Database name: jzh
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/jzh/spfilejzh.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: jzh
Database instances: jzh_1
Disk Groups: DATA,ARCH
Mount point paths:
Services: jzhdb
Type: RAC
Database is administrator managed
2、RAC转换至RAC One Node
$ srvctl convert database -d jzh -c RACONENODE -w 30 -i jzh1
$ srvctl config database -d jzh
Database unique name: jzh
Database name: jzh
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/jzh/spfilejzh.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: jzh
Database instances:
Disk Groups: DATA,ARCH
Mount point paths:
Services: jzhdb
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: jzh1
Candidate servers: jzh1
Database is administrator managed
3、重新配置服务
$ srvctl remove service -d jzh -s jzhdb
$ srvctl add service -d jzh -s jzhdb -P BASIC
$ srvctl start service -d jzh -s jzhdb
$ srvctl config service -d jzh -s jzhdb
Service name: jzhdb
Service is enabled
Server pool: jzh
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: jzh1_1
Available instances:
4、RAC One Node failover测试
检查状态
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE jzh1
ora.DATA.dg
ONLINE ONLINE jzh1
ora.LISTENER.lsnr
ONLINE ONLINE jzh1
ora.VOTE.dg
ONLINE ONLINE jzh1
ora.asm
ONLINE ONLINE jzh1 Started
ora.gsd
OFFLINE OFFLINE jzh1
ora.net1.network
ONLINE ONLINE jzh1
ora.ons
ONLINE ONLINE jzh1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jzh1
ora.cvu
1 OFFLINE OFFLINE
ora.jzh.db
2 ONLINE ONLINE jzh1 Open ====================》已经切换至节点jzh1上了。
ora.jzh.jzhdb.svc
1 ONLINE ONLINE jzh1
ora.jzh1.vip
1 ONLINE ONLINE jzh1
ora.jzh2.vip
1 ONLINE INTERMEDIATE jzh1 FAILED OVER
ora.oc4j
1 ONLINE ONLINE jzh1
ora.scan1.vip
1 ONLINE ONLINE jzh1
至此,RAC转换至RAC One Node完成!
$ su - oracle
$ srvctl config database -d jzh
Database unique name: jzh
Database name: jzh
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/jzh/spfilejzh.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: jzh
Database instances: jzh_1,jzh_2
Disk Groups: DATA,ARCH
Mount point paths:
Services: jzhdb
Type: RAC
Database is administrator managed
$ srvctl stop instance -d jzh -i jzh_2
$ srvctl remove instance -d jzh -i jzh_2
Remove instance from the database jzh? (y/[n]) y
$ srvctl config database -d jzh
Database unique name: jzh
Database name: jzh
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/jzh/spfilejzh.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: jzh
Database instances: jzh_1
Disk Groups: DATA,ARCH
Mount point paths:
Services: jzhdb
Type: RAC
Database is administrator managed
2、RAC转换至RAC One Node
$ srvctl convert database -d jzh -c RACONENODE -w 30 -i jzh1
$ srvctl config database -d jzh
Database unique name: jzh
Database name: jzh
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/jzh/spfilejzh.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: jzh
Database instances:
Disk Groups: DATA,ARCH
Mount point paths:
Services: jzhdb
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: jzh1
Candidate servers: jzh1
Database is administrator managed
3、重新配置服务
$ srvctl remove service -d jzh -s jzhdb
$ srvctl add service -d jzh -s jzhdb -P BASIC
$ srvctl start service -d jzh -s jzhdb
$ srvctl config service -d jzh -s jzhdb
Service name: jzhdb
Service is enabled
Server pool: jzh
Cardinality: 1
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: NONE
Failover method: NONE
TAF failover retries: 0
TAF failover delay: 0
Connection Load Balancing Goal: LONG
Runtime Load Balancing Goal: NONE
TAF policy specification: BASIC
Edition:
Preferred instances: jzh1_1
Available instances:
4、RAC One Node failover测试
检查状态
$ olsnodes -n
jzh1 1
jzh2 2
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.DATA.dg
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.LISTENER.lsnr
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.VOTE.dg
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.asm
ONLINE ONLINE jzh1 Started
ONLINE ONLINE jzh2 Started
ora.gsd
OFFLINE OFFLINE jzh1
OFFLINE OFFLINE jzh2
ora.net1.network
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.ons
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jzh1
ora.cvu
1 OFFLINE OFFLINE
ora.jzh.db
2 ONLINE ONLINE jzh2 Open
ora.jzh.jzhdb.svc
1 ONLINE ONLINE jzh2
ora.jzh1.vip
1 ONLINE ONLINE jzh1
ora.jzh2.vip
1 ONLINE ONLINE jzh2
ora.oc4j
1 ONLINE ONLINE jzh1
ora.scan1.vip
1 ONLINE ONLINE jzh1
此时,DB与SERVICE运行在jzh2上,也就是第二节点,接下来模拟第二节点private网络中断,第二节点被驱逐(eviction)
# ifconfig eth1 down
查询crs状态
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE jzh1
ora.DATA.dg
ONLINE ONLINE jzh1
ora.LISTENER.lsnr
ONLINE ONLINE jzh1
ora.VOTE.dg
ONLINE ONLINE jzh1
ora.asm
ONLINE ONLINE jzh1 Started
ora.gsd
OFFLINE OFFLINE jzh1
ora.net1.network
ONLINE ONLINE jzh1
ora.ons
ONLINE ONLINE jzh1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jzh1
ora.cvu
1 OFFLINE OFFLINE
ora.jzh.db
2 ONLINE OFFLINE STARTING
ora.jzh.jzhdb.svc
1 ONLINE OFFLINE
ora.jzh1.vip
1 ONLINE ONLINE jzh1
ora.jzh2.vip
1 ONLINE INTERMEDIATE jzh1 FAILED OVER
ora.oc4j
1 ONLINE ONLINE jzh1
ora.scan1.vip
1 ONLINE ONLINE jzh1
再次查询
jzh1 1
jzh2 2
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.DATA.dg
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.LISTENER.lsnr
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.VOTE.dg
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.asm
ONLINE ONLINE jzh1 Started
ONLINE ONLINE jzh2 Started
ora.gsd
OFFLINE OFFLINE jzh1
OFFLINE OFFLINE jzh2
ora.net1.network
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
ora.ons
ONLINE ONLINE jzh1
ONLINE ONLINE jzh2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jzh1
ora.cvu
1 OFFLINE OFFLINE
ora.jzh.db
2 ONLINE ONLINE jzh2 Open
ora.jzh.jzhdb.svc
1 ONLINE ONLINE jzh2
ora.jzh1.vip
1 ONLINE ONLINE jzh1
ora.jzh2.vip
1 ONLINE ONLINE jzh2
ora.oc4j
1 ONLINE ONLINE jzh1
ora.scan1.vip
1 ONLINE ONLINE jzh1
此时,DB与SERVICE运行在jzh2上,也就是第二节点,接下来模拟第二节点private网络中断,第二节点被驱逐(eviction)
# ifconfig eth1 down
查询crs状态
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE jzh1
ora.DATA.dg
ONLINE ONLINE jzh1
ora.LISTENER.lsnr
ONLINE ONLINE jzh1
ora.VOTE.dg
ONLINE ONLINE jzh1
ora.asm
ONLINE ONLINE jzh1 Started
ora.gsd
OFFLINE OFFLINE jzh1
ora.net1.network
ONLINE ONLINE jzh1
ora.ons
ONLINE ONLINE jzh1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jzh1
ora.cvu
1 OFFLINE OFFLINE
ora.jzh.db
2 ONLINE OFFLINE STARTING
ora.jzh.jzhdb.svc
1 ONLINE OFFLINE
ora.jzh1.vip
1 ONLINE ONLINE jzh1
ora.jzh2.vip
1 ONLINE INTERMEDIATE jzh1 FAILED OVER
ora.oc4j
1 ONLINE ONLINE jzh1
ora.scan1.vip
1 ONLINE ONLINE jzh1
$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE jzh1
ora.DATA.dg
ONLINE ONLINE jzh1
ora.LISTENER.lsnr
ONLINE ONLINE jzh1
ora.VOTE.dg
ONLINE ONLINE jzh1
ora.asm
ONLINE ONLINE jzh1 Started
ora.gsd
OFFLINE OFFLINE jzh1
ora.net1.network
ONLINE ONLINE jzh1
ora.ons
ONLINE ONLINE jzh1
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE jzh1
ora.cvu
1 OFFLINE OFFLINE
ora.jzh.db
2 ONLINE ONLINE jzh1 Open ====================》已经切换至节点jzh1上了。
ora.jzh.jzhdb.svc
1 ONLINE ONLINE jzh1
ora.jzh1.vip
1 ONLINE ONLINE jzh1
ora.jzh2.vip
1 ONLINE INTERMEDIATE jzh1 FAILED OVER
ora.oc4j
1 ONLINE ONLINE jzh1
ora.scan1.vip
1 ONLINE ONLINE jzh1
至此,RAC转换至RAC One Node完成!
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10271187/viewspace-1464466/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10271187/viewspace-1464466/