Relocating an RAC database and instances across nodes

Presuming you have an RAC database named RACNVT with an instance RACNVT1 running on raclinux1 node and you wish to relocate the instance permanently or temporally to raclinux2 node due to a prolonged maintenance scheduled on the raclunux1 node, or maybe the node resources are heavily consumed and you want to reduce the usage by relocating the instance. We are going to demonstrate here how to relocate an instance from one node to another.

The following output demonstrates where the RAC database and its instances are running:

[oracle@raclinux1 ~]$ ./crs_stat.sh
HA Resource                                   Target  State             
------------                                  ------  -----             
ora.RACNVT.RACNVT1.inst                       ONLINE  ONLINE on raclinux1
ora.RACNVT.db ONLINE ONLINE on ...

Get Oracle 11g R1/R2 Real Application Clusters Essentials now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.