eygle.com   eygle.com
eygle.com eygle
eygle.com  
 

« 2007 年终总结-Eygle.Com的发展历程 | Blog首页 | DBA警世录:年关临近 谨防数据库事故 »

Oracle10.2.0.3 RAC的VIP及实例依赖关系

Oracle10g在Oracle 10.2.0.3之前,CRS中实例资源是依赖于VIP资源的。
这会导致的一个普遍问题是,当仅仅是VIP出现故障需要切换时,实例和监听也同时Down了。
往往这是我们不希望看到的情形,如果实例正常,VIP切换时,完全没有必要关闭实例。

在Oracle 10.2.0.3中,这个依赖关系被取消。我们看一下这个版本中的现有情况。
以下是VIP资源的配置情况:
[oracle@smsdbrac1 oracle]$ crs_stat -p ora.smsdbrac1.vip
NAME=ora.smsdbrac1.vip
TYPE=application
ACTION_SCRIPT=/opt/oracle/product/10.2.0/crs10g/bin/racgwrap
ACTIVE_PLACEMENT=1
AUTO_START=1
CHECK_INTERVAL=60
DESCRIPTION=CRS application for VIP on a node
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=smsdbrac1
OPTIONAL_RESOURCES=
PLACEMENT=favored
REQUIRED_RESOURCES=
RESTART_ATTEMPTS=0
SCRIPT_TIMEOUT=60
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=eth0|eth1
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=255.255.255.0
USR_ORA_OPEN_MODE=
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=192.168.200.13

再来看看实例:
[oracle@smsdbrac1 oracle]$ crs_stat -p ora.smsdb.smsdb1.inst
NAME=ora.smsdb.smsdb1.inst
TYPE=application
ACTION_SCRIPT=/opt/oracle/product/10.2.0/db/bin/racgwrap
ACTIVE_PLACEMENT=0
AUTO_START=1
CHECK_INTERVAL=600
DESCRIPTION=CRS application for Instance
FAILOVER_DELAY=0
FAILURE_INTERVAL=0
FAILURE_THRESHOLD=0
HOSTING_MEMBERS=smsdbrac1
OPTIONAL_RESOURCES=
PLACEMENT=restricted
REQUIRED_RESOURCES=ora.smsdbrac1.ASM1.asm
RESTART_ATTEMPTS=5
SCRIPT_TIMEOUT=600
START_TIMEOUT=0
STOP_TIMEOUT=0
UPTIME_THRESHOLD=7d
USR_ORA_ALERT_NAME=
USR_ORA_CHECK_TIMEOUT=0
USR_ORA_CONNECT_STR=/ as sysdba
USR_ORA_DEBUG=0
USR_ORA_DISCONNECT=false
USR_ORA_FLAGS=
USR_ORA_IF=
USR_ORA_INST_NOT_SHUTDOWN=
USR_ORA_LANG=
USR_ORA_NETMASK=
USR_ORA_OPEN_MODE=
USR_ORA_OPI=false
USR_ORA_PFILE=
USR_ORA_PRECONNECT=none
USR_ORA_SRV=
USR_ORA_START_TIMEOUT=0
USR_ORA_STOP_MODE=immediate
USR_ORA_STOP_TIMEOUT=0
USR_ORA_VIP=

现在instance仅仅依赖于asm而存在,这里的ASM资源是ora.smsdbrac1.ASM1.asm。

-The End-

历史上的今天...
    >> 2014-01-10文章:
    >> 2012-01-10文章:
    >> 2011-01-10文章:
    >> 2007-01-10文章:
    >> 2006-01-10文章:
           EMC 错了么 之 C = 13 ?
           EMC 错了么?
    >> 2005-01-10文章:

无觅

By eygle on 2008-01-10 10:35 | Comments (1) | Advanced | Oracle12c/11g | 1738 |

1 Comment

哦?还没注意到,rac也是逐步走向成熟了


CopyRight © 2004~2020 云和恩墨,成就未来!, All rights reserved.
数据恢复·紧急救援·性能优化 云和恩墨 24x7 热线电话:400-600-8755 业务咨询:010-59007017-7040 or 7037 业务合作: marketing@enmotech.com