=========================
General
=========================
Restart GG processes from crontab
=========================
Code
=========================
crontab entry
1 06 1 * * /software/oracle/oracle/scripts/gg_restart/gg_restart_all_groups.sh
Code
=========================
crontab entry
1 06 1 * * /software/oracle/oracle/scripts/gg_restart/gg_restart_all_groups.sh
gg_restart_all_groups.sh
#!/bin/bash
#!/bin/bash
WORK_HOME=/software/oracle/oracle/scripts/gg_restart
LOG_FILE=gg_restart.log
cd $WORK_HOME
./gg_restart_log.sh "${WORK_HOME}" "${LOG_FILE}" "START"
./gg_restart_group.sh EXT_S "ext ext_s*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_group.sh EXT_P "ext ext_p*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_group.sh EXT_I "ext ext_i*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_group.sh DPM_S "ext dpm_s*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_group.sh DPM_P "ext dpm_p*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_group.sh DPM_I "ext dpm_i*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_group.sh REP_S "rep rep_s*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_group.sh REP_P "rep rep_p*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_group.sh REP_I "rep rep_i*" "${WORK_HOME}" "${LOG_FILE}"
./gg_restart_log.sh "${WORK_HOME}" "${LOG_FILE}" "FINISH"
gg_restart_log.sh
#!/bin/bash
WORK_HOME=$1
LOG_FILE_NAME=$2
VERB=$3
cd $WORK_HOME
LOG_FILE=${WORK_HOME}/${LOG_FILE_NAME}
RUN_DATE=`date "+%Y%m%d"_"%H%M%S"`
touch $LOG_FILE
if [[ $VERB == "START" ]]; then
echo "" >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo Start at $RUN_DATE >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo "" >>$LOG_FILE
echo "Before Restart: " >>$LOG_FILE
echo "" >>$LOG_FILE
free -m >> $LOG_FILE
echo "" >> $LOG_FILE
sar -r >> $LOG_FILE
echo "" >>$LOG_FILE
fi
if [[ $VERB == "FINISH" ]]; then
echo "" >>$LOG_FILE
echo "---------------------------" >>$LOG_FILE
echo "After Restart: " >>$LOG_FILE
echo "---------------------------" >>$LOG_FILE
echo "" >>$LOG_FILE
free -m >> $LOG_FILE
echo "" >> $LOG_FILE
sar -r >> $LOG_FILE
echo "" >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo Finished at $RUN_DATE >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo "" >>$LOG_FILE
fi
exit 0
gg_restart_group.sh
#!/bin/bash
GROUP_NAME=$1
RESTART_GROUP=$2
WORK_DIR=$3
LOG_FILE_NAME=$4
#GROUP_NAME=EXT_S
#RESTART_GROUP="ext ext_s*"
LOG_FILE=${WORK_DIR}/${LOG_FILE_NAME}
clear
echo "Restarting ${GROUP_NAME} ${RESTART_GROUP}" >> ${LOG_FILE}
echo "Log File is: ${LOG_FILE}"
exit 0
. /etc/profile > /dev/null 2> /dev/null
TEMP_LOG_FILE="/tmp/restart_temp.tmp"
RUN_DATE=`date "+%Y%m%d"_"%H%M%S"`
# Setting Oracle GoldenGate environments
if [ "$OGGSH" = "" ]; then
OGGSH=$INFRA_ROOT/oggsh
fi
if [ "$ORACLE_SID" = "" ]; then
INSTANCE=igt
else
INSTANCE=$ORACLE_SID
fi
. $OGGSH/gg_login.sh $INSTANCE
touch $LOG_FILE
touch $TEMP_LOG_FILE
echo "" >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo Start Restart for ${GROUP_NAME} group ${RESTART_GROUP} at $RUN_DATE >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo "" >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo Initial State >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo "" >>$LOG_FILE
$GG_HOME/ggsci >$TEMP_LOG_FILE <<EOD
info all
exit
EOD
cat $TEMP_LOG_FILE | grep ${GROUP_NAME} >>$LOG_FILE
echo about to do "stop ext $RESTART_GROUP" >>$LOG_FILE
$GG_HOME/ggsci >$TEMP_LOG_FILE <<EOF
stop ${RESTART_GROUP}
exit
EOF
cat $TEMP_LOG_FILE >>$LOG_FILE
echo "" >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo After Stop >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo "" >>$LOG_FILE
sleep 10
$GG_HOME/ggsci >$TEMP_LOG_FILE <<EOD
info all
exit
EOD
cat $TEMP_LOG_FILE | grep ${GROUP_NAME} >>$LOG_FILE
echo "Starting ${RESTART_GROUP}" >> $LOG_FILE
$GG_HOME/ggsci >$TEMP_LOG_FILE <<EOF
start ${RESTART_GROUP}
exit
EOF
cat $TEMP_LOG_FILE >>$LOG_FILE
echo "" >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo After Start >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo "" >>$LOG_FILE
sleep 10
$GG_HOME/ggsci >$TEMP_LOG_FILE <<EOD
info all
exit
EOD
cat $TEMP_LOG_FILE | grep ${GROUP_NAME} >>$LOG_FILE
NOT_RUNNING=`grep STOPPED $TEMP_LOG_FILE |grep ${GROUP_NAME} | wc -l`
if [ $NOT_RUNNING -gt 0 ]; then
echo "Some Processes were not started. Attempting restart" >>$LOG_FILE
$GG_HOME/ggsci >$TEMP_LOG_FILE <<EOF
start ${RESTART_GROUP}
exit
EOF
cat $TEMP_LOG_FILE >>$LOG_FILE
fi
#============================================================
# Second restart
#============================================================
sleep 10
$GG_HOME/ggsci >$TEMP_LOG_FILE <<EOD
info all
exit
EOD
cat $TEMP_LOG_FILE | grep ${GROUP_NAME} >>$LOG_FILE
NOT_RUNNING=`grep STOPPED $TEMP_LOG_FILE | wc -l`
if [ $NOT_RUNNING -gt 0 ]; then
echo "Some Processes were not started. Attempting restart" >>$LOG_FILE
$GG_HOME/ggsci > $TEMP_LOG_FILE <<EOF
start ${RESTART_GROUP}
exit
EOF
cat $TEMP_LOG_FILE >>$LOG_FILE
sleep 10
$GG_HOME/ggsci >$TEMP_LOG_FILE <<EOD
info all
exit
EOD
cat $TEMP_LOG_FILE | grep ${GROUP_NAME} >>$LOG_FILE
fi
echo "" >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo Finished Restart for $GROUP_NAME $RESTART_GROUP at $RUN_DATE >>$LOG_FILE
echo ========================================== >>$LOG_FILE
echo "" >>$LOG_FILE
