When setting up a GoldenGate instance its important to remember that you also have to setup a CRS resource for failover.

Here is a list of the scripts created for this purpose


total 112
-rw-r--r-- 1 oracle dba     0 Aug 10 08:51 crsdbfs_lst.txt
-rwxr-xr-x 1 oracle dba   612 Aug  9 12:51 crs_relo_ggtxd001_node_mp.ksh
-rwxr-xr-x 1 oracle dba   520 Aug  9 12:49 crs_relo_ggtxd001_node_np.ksh
-rwxr-xr-x 1 oracle dba   520 Aug  9 11:06 crs_relo.ksh
-rwxr-xr-x 1 oracle dba   522 Aug  9 10:55 crs_stop.ksh
-rwxr-xr-x 1 oracle dba   522 Aug  9 10:52 crs_stop_ggtxd001.ksh
-rwxr-xr-x 1 oracle dba 14713 Aug  9 10:49 mount_dbfs_ggtxd001.bsh
-rw-r--r-- 1 oracle dba    10 Aug  9 10:26 nohup.out
-rw-r--r-- 1 oracle dba  4406 Aug  9 10:18 mount-dbfs_ggtxd001.conf
-rwxr-xr-x 1 oracle dba   516 Aug  9 09:48 crs_start_ggtxd001.ksh
-rwxr-xr-x 1 oracle dba   513 Aug  9 09:45 crs_stat.ksh
-rwxr-xr-x 1 oracle dba   524 Aug  9 09:35 crs_start.ksh
-rwxr-xr-x 1 oracle dba   543 Aug  9 09:27 crs_add_res_dbfs_ggtxd001.ksh
-rwxr-xr-x 1 oracle dba   429 Aug  9 09:00 crs_relo_2_1.ksh
-rwxr-xr-x 1 oracle dba 13695 Aug  7 11:03 mount_dbfs.bsh
-rw-r--r-- 1 oracle dba  3971 Aug  3 16:23 mount-dbfs_test01.conf
-rwxr-xr-x 1 oracle dba 13576 Aug  3 15:44 mount-dbfs_01.bsh
-rw-r--r-- 1 oracle dba  3962 Aug  3 15:34 mount-dbfs.conf
-rw-r--r-- 1 oracle dba  3761 Aug  3 15:22 mount-dbfs.conf.orig



# crsctl delete resource dbfs_ggtxd001

# crsctl add resource dbfs_ggtxd001 -type cluster_resource -attr "ACTION_SCRIPT=/oracle/admin/scripts/clle_dbfscommon/mount_dbfs.bsh, CHECK_INTERVAL=30, RESTART_ATTEMPTS=10"

# crsctl stat resource dbfs_ggtxd001

# /oracle_crs/product/12.1.0.2/crs_1/bin/crsctl relocate resource dbfs_ggtxd001 -node lrdne67np

echo
echo "Relocate ggtxd001 to node mp..."
echo

/oracle_crs/product/12.1.0.2/crs_1/bin/crsctl relocate resource dbfs_ggtxd001 -n lrdne67mp

echo
echo "Status from CRS...."
echo

/oracle_crs/product/12.1.0.2/crs_1/bin/crsctl status resource dbfs_ggtxd001


Ready for Action?

LET'S GO!
Copyright 2024 IT Remote dot com
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram