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

[code language=”sql”]

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

[/code]

[code language=”sql”]

# 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

[/code]