RAC veritabanlarında CRS kaynaklarının diğer sunucuya aktarılması

RAC olarak çalışan veritabanların CRS kaynaklarının bazen çalıştığı node dışında başka node’larda çalışması istenebilmektedir. Bu durumda ilgili kaynakları manuel diğer node taşımanız gerekmektedir.

Aktarım için “crs_relocate” komutunu kullanabilirsiniz.

CRS kaynaklarının sorgulanması :

-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

Örneğin oradb1 sunucusunda çalışan ora.scan2.vip isimli kaynağı oradb2 sunucusuna aktarmak için aşağıdaki komutu kullanabilirsiniz. -f opsiyonu vermediğiniz takdirde dependency yüzünden taşımayabilir.

-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.