Relocate service in RAC environment
(Temporarily/Permanently)
In this document, i have explained how to move the service from
one node of the cluster to the other node of the
cluster. you can move it through Temporarily &
Permanently. i have tried this example in 11gR2 RAC
environment having 2 node primary &
2 node standby database.
ABOUT SERVICE IN RAC
Service name is used by clients to connect to one
or more instances. The service name should be unique
throughout your system.
If multiple databases in the cluster offer the same service name
, then RAC balances connections to that service
across all such databases. If you want
client connections to a service to be directed
to a particular database,
then the service name must be unique
within the cluster
TEMPORARILY RELOCATE SERVICE
FROM ONE NODE
TO ANOTHER NODE IN CLUSTER
$srvctl relocate service -h
Temporarily relocates service from one node
of the cluster to another.
Usage: srvctl relocate service -d
-s
{-i -t
| -c -n }
[-f]
Specify instances for an
administrator-managed database, or
nodes for a policy managed database
-d Unique name
for the database
-s Service
name
-i Old
instance name
-t New
instance name
-c Node
name to relocate service from
-n Node
name to relocate service to
-f Disconnect
all sessions during stop or relocate
service operations
-h Print
usage
BEFORE CHANGING SERVICE STATUS
ora.BHU_a.db ONLINE on bhuora01,
ONLINE on bhuora02
ora.BHU_a.bhurac.com.svc ONLINE on bhuora01
Using Relocate service option to
move from one node to another node
% srvctl relocate service -d BHU_A -s
bhurac.com -i BHU_2 -t BHU_1 –f
AFTER CHANGING SERVICE STATUS
ora.BHU_a.db ONLINE on bhuora01,
ONLINE on bhuora02
ora.BHU_a.bhurac.com.svc ONLINE on bhuora01
In the above example, we have moved
our service from one node to another node of
the cluster. this doesnt change
in the configuration
$ srvctl config service -d BHU_a
Service name: bhurac.com
Service is enabled
Server pool: BHU_A_RAC.com
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: BHU_2
Available instances: BHU_1
PERMANENT RELOCATE SERVICE FROM ONE
NODE OF THE CLUSTER TO ANOTHER
To view the service configuration of
the environment. i am planning to move
my service from BHU_1 to BHU_2 permanently
$ srvctl config service -d BHU_b -s bhurac.com
Service name: bhurac.com
Service is enabled
Server pool: BHU_B_rac.com
Cardinality: 1
Disconnect: true
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: BHU_1
Available instances: BHU_2
$ srvctl modify service -h
Modifies the configuration for the service.
Usage: srvctl modify service -d
-i ""
[-a ""] [-f]
-d Unique name
for the database
-s Service name
-n Modify
service configuration
-i "" Comma
separated list of preferred instances
-a "" Comma
separated list of available instances
-f Disconnect all sessions
during stop or relocate service operations
To modify service from
one to another node
$ srvctl modify service -d BHU_b
-s bhurac.com -n -i BHU_2 -a BHU_1 –f
To verify whether the service has
moved from one node to another permanently
$srvctl config service -d BHU_b
-s bhurac.com
Service name: bhurac.com
Service is enabled
Server pool: BHU_B_rac.com
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: BHU_2
Available instances: BHU_1
No comments:
Post a Comment