欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

如何注册diskgroup到集群

程序员文章站 2022-06-11 16:54:52
...

之前使用 renamedg 对 ora.CRS.dg 进行重命名ora.DUPCRS.dg 但是 renamedg 有个缺点就是无法将修改的信息同步到整个集群层面,而且修改前的dg 会依然保留在集群层面: 如下所示:因此需要手动去清除,和重新注册修改后的dg 信息。 rename 需求: ora.CRS.dg

之前使用 renamedg 对 ora.CRS.dg 进行重命名ora.DUPCRS.dg
但是 renamedg 有个缺点就是无法将修改的信息同步到整个集群层面,而且修改前的dg 会依然保留在集群层面:
如下所示:因此需要手动去清除,和重新注册修改后的dg 信息。

rename
需求: ora.CRS.dg --------------》 ora.DUPCRS.dg
register ora.DUPCRS.dg into cluster

grid :11203

db: 11202
[grid@vmrac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2
ora.CRS.dg
ONLINE UNKNOWN vmrac1
ONLINE OFFLINE vmrac2
ora.DATANEW.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2
ora.DUPCRS.dg
ONLINE OFFLINE vmrac1
ONLINE UNKNOWN vmrac2

【测试一】
--------这是通过 crsctl add res ora.DUPCRS.dg -type ora.diskgroup.type 来注册后 ora.DUPCRS.dg 的配置信息:
--------集群资源状态信息如下:

[grid@vmrac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2
ora.CRS.dg
ONLINE UNKNOWN vmrac1
ONLINE OFFLINE vmrac2
ora.DATANEW.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2
ora.DUPCRS.dg
ONLINE OFFLINE vmrac1
ONLINE UNKNOWN vmrac2
ora.FLASH.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2


-----配置结果显然是不对的。

[grid@vmrac1 ~]$ crsctl stat res ora.DUPCRS.dg -p
NAME=ora.DUPCRS.dg
TYPE=ora.diskgroup.type
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=never ---------------这里有问题
CHECK_INTERVAL=300
CHECK_TIMEOUT=30
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=CRS resource type definition for ASM disk group resource
ENABLED=1
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm)
START_TIMEOUT=900
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm)
STOP_TIMEOUT=180
TYPE_VERSION=1.2
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
USR_ORA_STOP_MODE=
VERSION= -------------这里也有问题,但是我觉得这个参数不是很要紧

【测试二】

------删除 DUPCRS dg:
[grid@vmrac1 ~]$ crsctl delete res ora.DUPCRS.dg

------注册资源ora.DUPCRS.dg
[grid@vmrac1 ~]$ crsctl add res ora.DUPCRS.dg -type ora.diskgroup.type -attr

"ACL='owner:grid:rwx,pgrp:oinstall:rwx,other::r--',AUTO_START=always,VERSION=11.2.0.2.0" -i

-----查看ora.DUPCRS.dg 配置信息:
[grid@vmrac1 ~]$ crsctl stat res ora.DUPCRS.dg -p
NAME=ora.DUPCRS.dg
TYPE=ora.diskgroup.type
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r--
ACTION_FAILURE_TEMPLATE=
ACTION_SCRIPT=
AGENT_FILENAME=%CRS_HOME%/bin/oraagent%CRS_EXE_SUFFIX%
ALIAS_NAME=
AUTO_START=always
CHECK_INTERVAL=300
CHECK_TIMEOUT=30
DEFAULT_TEMPLATE=
DEGREE=1
DESCRIPTION=CRS resource type definition for ASM disk group resource
ENABLED=1
LOAD=1
LOGGING_LEVEL=1
NLS_LANG=
NOT_RESTARTING_TEMPLATE=
OFFLINE_CHECK_INTERVAL=0
PROFILE_CHANGE_TEMPLATE=
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=60
START_DEPENDENCIES=hard(ora.asm) pullup(ora.asm)
START_TIMEOUT=900
STATE_CHANGE_TEMPLATE=
STOP_DEPENDENCIES=hard(intermediate:ora.asm)
STOP_TIMEOUT=180
TYPE_VERSION=1.2
UPTIME_THRESHOLD=1d
USR_ORA_ENV=
USR_ORA_OPI=false
USR_ORA_STOP_MODE=
VERSION=11.2.0.2.0

----------再次查看集群中ora.DUPCRS.dg 状态信息:
[grid@vmrac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2
ora.CRS.dg
ONLINE UNKNOWN vmrac1
ONLINE OFFLINE vmrac2
ora.DATANEW.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2
ora.DUPCRS.dg
OFFLINE OFFLINE vmrac1
OFFLINE OFFLINE vmrac2
ora.FLASH.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2

------------需要重新启动一下ora.DUPCRS.dg 资源:
[grid@vmrac1 ~]$ crsctl start res ora.DUPCRS.dg
CRS-2672: Attempting to start 'ora.DUPCRS.dg' on 'vmrac2'
CRS-2672: Attempting to start 'ora.DUPCRS.dg' on 'vmrac1'
CRS-2676: Start of 'ora.DUPCRS.dg' on 'vmrac1' succeeded
CRS-2676: Start of 'ora.DUPCRS.dg' on 'vmrac2' succeeded


-----------再次确认dg 状态信息:
[grid@vmrac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCH.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2
ora.CRS.dg
ONLINE UNKNOWN vmrac1
ONLINE OFFLINE vmrac2
ora.DATANEW.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2
ora.DUPCRS.dg
ONLINE ONLINE vmrac1 ---------状态正确了
ONLINE ONLINE vmrac2
ora.FLASH.dg
ONLINE ONLINE vmrac1
ONLINE ONLINE vmrac2

[grid@vmrac1 ~]$