How do I move a service from both nodes to only one node, and then back to both nodes again?
Let's say I have a service defined on nodes ORCL1 and ORCL2.
It looks like this
srvctl status service -db ORCL
Service myservice is running on instance(s) ORCL1,ORCL2
Move service to the second node
srvctl modify service -db ORCL -service myservice -modifyconfig -preferred ORCL2
Now it looks like this
srvctl status service -db ORCL
Service myservice is running on instance(s) ORCL2
I can take down ORCL1 and do my maintenance.
Now how do I get it back to the state it was in the beginning where it was running on both nodes? Relocate and modify only allow me to move it to one node it seems.
Thanks in advance