Monday, May 20, 2013

Relocate service in RAC environment

TEMPORARILY RELOCATE SERVICE FROM ONE NODE TO ANOTHER NODE IN CLUSTER

$ srvctl status service -d RAC                                       
Service RAC_S is running on instance(s) RAC1

$ srvctl relocate service -d RAC -s RAC_S -i RAC1 -t RAC2

$ srvctl status service -d RAC                                       
Service RAC_S is running on instance(s) RAC2


PERMANENT RELOCATE SERVICE FROM ONE NODE OF THE CLUSTER TO ANOTHER

$ srvctl config service -d RAC
Service name: RAC_S
Service is enabled
Server pool: RAC_RAC_S
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: NONE
Edition: 
servPreferred instances: RAC1
Available instances: RAC2

$ srvctl modify service -d RAC -s RAC_S -n -i RAC2 -a RAC1

$ srvctl config service -d RAC
Service name: RAC_S
Service is enabled
Server pool: RAC_RAC_S
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: NONE
Edition: 
Preferred instances: RAC2
Available instances: RAC1

No comments:

Post a Comment