Service not failover on RAC 11.2.0.3 environment
940535May 31 2012 — edited May 31 2012Hi
now i am testing how the 11.2.0.3 RAC will behave with Redhat 5.7.
then, i found the rac service will not failover to other node which added with "-r" available option
i have made service with this command
"srvctl add service -d xxxdb -s srv_p01 -r xxxdb1 -a xxxdb2 -y automatic -f"
xxxdb means database name, xxxdb1 and xxxdb2 are the instance on each nodes.
in my thought it will be that when prefferd xxxdb1 stopped accidentaly, the service "srv_p01" failover to availabled xxxdb2 instance
but when i stop the xxxdb1 instance with "srvctl stop instance" command, this service won't failover...
**following is the Nomal status
ora.xxxdb.db
1 ONLINE ONLINE node01 Open
2 ONLINE ONLINE node02 Open
ora.xxxdb.srv_p01.svc
1 ONLINE ONLINE node01
**here is the status when i stop the instance on node01
ora.xxxdb.db
1 OFFLINE OFFLINE Instance Shutdown
2 ONLINE ONLINE 02 Open
ora.xxxdb.srv_p01.svc
1 ONLINE OFFLINE
now the point of my question;
1. when instance down, the service which running on downed instance will failover to other node which registered as "availbale"?
the incident i met is normal activity?
2. if this activity is normal, why i add service with "available" option?
3. i want to know when the service failover to available node?
**here is the status i think it should be when instance down..
ora.xxxdb.db
1 OFFLINE OFFLINE Instance Shutdown
2 ONLINE ONLINE 02 Open
ora.xxxdb.srv_p01.svc
1 ONLINE ONLINE node02
Anyone pls answer my question! pls..
Thanks,
Edited by: 937532 on 2012/05/30 22:29