11gR2 RAC convert ONENODE

https://www.woningontruimingcentrale.nl/515-ph65089-plaquenil-retinopathy-guidelines.html browse around these guys 文章标题:11gR2 RAC convert ONENODE
文章URL: dtgv partnervermittlung http://www.prudentwoo.com/archives/2869
作者:PrudentWoo©版权所有
[文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.]

11gR2 RAC convert ONENODE

一、添加services

http://ammafricaworld.org/291-ph43855-precio-de-plaquenil-200-mg.html [oracle@ora11grac1 ~]$ srvctl add service -d woo -s onenode -r "woo1,woo2" [oracle@ora11grac1 ~]$ srvctl config service -d woo Service name: onenode Service is enabled Server pool: woo_onenode Cardinality: 2 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: NONE Edition: Preferred instances: woo1,woo2 Available instances: [oracle@ora11grac1 ~]$ srvctl start service -d woo -s onenode

二、查看当前数据库状态:

[oracle@ora11grac1 ~]$ srvctl config database -d woo
Database unique name: woo
Database name: woo
Oracle home: /DBSoft/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA001/woo/spfilewoo.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: woo
Database instances: woo1,woo2
Disk Groups: DATA001,ARC_001
Mount point paths:
Services: onenode
Type: RAC
Database is administrator managed
[oracle@ora11grac1 ~]$ srvctl status database -d woo
Instance woo1 is running on node ora11grac1
Instance woo2 is running on node ora11grac2

Learn More 三、停掉并移除一个实例:

[grid@ora11grac1 ~]$ srvctl stop instance -d woo -i woo2
[grid@ora11grac1 ~]$ srvctl remove instance -d woo -i woo2
Remove instance from the database woo? (y/[n]) y

四、开始转换为ONENODE:

[oracle@ora11grac1 ~]$ srvctl convert database -d woo -c raconenode -w 30 -i woo

五、检查数据库角色:

[oracle@ora11grac1 ~]$ srvctl config database -d woo
Database unique name: woo
Database name: woo
Oracle home: /DBSoft/oracle/product/11.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA001/woo/spfilewoo.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: woo
Database instances:
Disk Groups: DATA001,ARC_001
Mount point paths:
Services: onenode
Type: RACOneNode
Online relocation timeout: 30
Instance name prefix: woo
Candidate servers: ora11grac1
Database is administrator managed

http://josiart.at/rete/12100 原创文章,转载请注明: 转载自PrudentWoo website here 本文链接地址: 11gR2 RAC convert ONENODE

此条目发表在Oracle, Oracle探索系列, RAC, 数据库分类目录。将固定链接加入收藏夹。

发表评论

电子邮件地址不会被公开。 必填项已用*标注