Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Sometimes you may want CRS resources to run on other nodes in RAC databases. In this case, you must manually move the relevant resources to the other node.
You can use the “crs_relocate” command to transfer.
To query CRS resources:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 | -bash-4.3$ . oraenv ORACLE_SID = [oracle] ? +ASM1 The Oracle base remains unchanged with value /u01/app/oracle -bash-4.3$ crsctl status res NAME=ora.DATA.dg TYPE=ora.diskgroup.type TARGET=ONLINE , ONLINE STATE=ONLINE on oradb1, ONLINE on oradb2 NAME=ora.LISTENER.lsnr TYPE=ora.listener.type TARGET=ONLINE , ONLINE STATE=ONLINE on oradb1, ONLINE on oradb2 NAME=ora.LISTENER_SCAN1.lsnr TYPE=ora.scan_listener.type TARGET=ONLINE STATE=ONLINE on oradb2 NAME=ora.LISTENER_SCAN2.lsnr TYPE=ora.scan_listener.type TARGET=ONLINE STATE=ONLINE on oradb1 NAME=ora.LISTENER_SCAN3.lsnr TYPE=ora.scan_listener.type TARGET=ONLINE STATE=ONLINE on oradb1 NAME=ora.RECO.dg TYPE=ora.diskgroup.type TARGET=ONLINE , ONLINE STATE=ONLINE on oradb1, ONLINE on oradb2 NAME=ora.asm TYPE=ora.asm.type TARGET=ONLINE , ONLINE STATE=ONLINE on oradb1, ONLINE on oradb2 NAME=ora.cvu TYPE=ora.cvu.type TARGET=ONLINE STATE=ONLINE on oradb1 NAME=ora.gsd TYPE=ora.gsd.type TARGET=OFFLINE, OFFLINE STATE=OFFLINE, OFFLINE NAME=ora.net1.network TYPE=ora.network.type TARGET=ONLINE , ONLINE STATE=ONLINE on oradb1, ONLINE on oradb2 NAME=ora.oc4j TYPE=ora.oc4j.type TARGET=ONLINE STATE=ONLINE on oradb1 NAME=ora.ons TYPE=ora.ons.type TARGET=ONLINE , ONLINE STATE=ONLINE on oradb1, ONLINE on oradb2 NAME=ora.oradb1.vip TYPE=ora.cluster_vip_net1.type TARGET=ONLINE STATE=ONLINE on oradb1 NAME=ora.oradb2.vip TYPE=ora.cluster_vip_net1.type TARGET=ONLINE STATE=ONLINE on oradb2 NAME=ora.registry.acfs TYPE=ora.registry.acfs.type TARGET=ONLINE , ONLINE STATE=ONLINE on oradb1, ONLINE on oradb2 NAME=ora.scan1.vip TYPE=ora.scan_vip.type TARGET=ONLINE STATE=ONLINE on oradb2 NAME=ora.scan2.vip TYPE=ora.scan_vip.type TARGET=ONLINE STATE=ONLINE on oradb1 NAME=ora.scan3.vip TYPE=ora.scan_vip.type TARGET=ONLINE STATE=ONLINE on oradb1 NAME=ora.testdb.db TYPE=ora.database.type TARGET=ONLINE , ONLINE STATE=ONLINE on oradb1, ONLINE on oradb2 |
For example, you can use the following command to transfer the resource named “ora.scan2.vip” to the oradb2 server running on the oradb1 server. If you do not give the -f option, it may not be transferred due to dependency.
1 2 3 4 5 6 7 8 9 10 11 12 13 | -bash-4.3$ . oraenv ORACLE_SID = [oracle] ? +ASM1 The Oracle base remains unchanged with value /u01/app/oracle -bash-4.3$ crs_relocate ora.scan2.vip -c oradb2 -f Attempting to stop `ora.LISTENER_SCAN2.lsnr` on member `oradb1` Stop of `ora.LISTENER_SCAN2.lsnr` on member `oradb1` succeeded. Attempting to stop `ora.scan2.vip` on member `oradb1` Stop of `ora.scan2.vip` on member `oradb1` succeeded. Attempting to start `ora.scan2.vip` on member `oradb2` Start of `ora.scan2.vip` on member `oradb2` succeeded. Attempting to start `ora.LISTENER_SCAN2.lsnr` on member `oradb2` Start of `ora.LISTENER_SCAN2.lsnr` on member `oradb2` succeeded. |
