#!/bin/bash
# rac_failover.sh
# from:www.itpux.com.qq113257174.wx:itpux-com
# web: http://www.fgedu.net.cn

OGG_HOME=/GoldenGate/app
LOG_FILE=$OGG_HOME/logs/rac_failover.log

failover_to_node() {
local node=$1
echo “========== 故障转移到节点 $node: $(date) ==========” >> $LOG_FILE

# 停止当前节点OGG进程
echo “停止当前节点OGG进程” >> $LOG_FILE
$OGG_HOME/ggsci << EOF >> $LOG_FILE 2>&1
STOP *
EXIT
EOF

# 启动目标节点OGG进程
echo “启动节点 $node OGG进程” >> $LOG_FILE
ssh $node “$OGG_HOME/ggsci << 'EOF' START * EXIT EOF" >> $LOG_FILE 2>&1

echo “故障转移完成” >> $LOG_FILE
}

# 检测节点状态
check_node_status() {
local node=$1
local status=$(ssh $node “crsctl status resource ora.cssd” | grep STATE | awk ‘{print $2}’)
echo “节点 $node 状态: $status” >> $LOG_FILE
echo $status
}

echo “========== RAC故障转移: $(date) ==========” >> $LOG_FILE

# 检查节点状态
status_node1=$(check_node_status fgedu01)
status_node2=$(check_node_status fgedu02)

# 故障转移逻辑
if [ “$status_node1” != “ONLINE” ]; then
failover_to_node fgedu02
elif [ “$status_node2” != “ONLINE” ]; then
failover_to_node fgedu01
else
echo “所有节点正常，无需故障转移” >> $LOG_FILE
fi