I too prefer a hot backup, if possible, for a number of reasons.
Another alternative (better than setting Enabled to 0, in my opinion) is
to use VCS to take the Oracle resource offline, and to freeze the
service group so that even if a FAULT occurs, it won't fail over while
you are trying to backup:
-----------------------------8<---------------------------------
SG=Aprd
ORA_RES=${SG}-oracle
LSNR_RES=${SG}-listener
SG_SYS=`hares -state ${ORA_RES} | grep ONLINE | awk '{print $3}'`
if [ -n "${SG_SYS}" ]
then
# May need to take the Netlsnr resource offline too?
hares -offline -ignoreparent ${LSNR_RES} -sys ${SG_SYS}
# Wait for Oracle to go offline - this is very simple, a better
# check may be required.
LSNR_RES_STATE=""
# If the resource never goes OFFLINE, this will wait indefinitely!
while [ "${LSNR_RES_STATE}" != "OFFLINE" ]
do
sleep 10
LSNR_RES_STATE=`hares -display ${LSNR_RES} -attribute State -sys
${SG_SYS} |\
tail -1 | awk '{print $4}'`
done
# Take the Oracle resource offline
hares -offline -ignoreparent ${ORA_RES} -sys ${SG_SYS}
# Wait for Oracle to go offline - this is very simple, a better
# check may be required.
ORA_RES_STATE=""
# If the resource never goes OFFLINE, this will wait indefinitely!
while [ "${ORA_RES_STATE}" != "OFFLINE" ]
do
sleep 10
ORA_RES_STATE=`hares -display ${ORA_RES} -attribute State -sys
${SG_SYS} |\
tail -1 | awk '{print $4}'`
done
hagrp -freeze ${SG}
fi
#[ Do backup here ]
hagrp -unfreeze ${SG}
# Just in case something FAULTED!
hagrp -clear ${SG}
hares -online ${ORA_RES} -sys ${SG_SYS}
hares -online ${LSNR_RES} -sys ${SG_SYS}
-----------------------------8<---------------------------------
WARNING: This is just untested sample code: don't use it without
thorough testing, no warranty is expressed or implied.
--
John S. Cronin
Cell phone: 678-480-6266
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Doug
Hughes
Sent: Thursday, March 01, 2007 10:43 AM
To: Rongsheng Fang
Cc: veritas-ha@mailman.eng.auburn.edu
Subject: Re: [Veritas-ha] stopping monitoring a resource for a certain
period
Rongsheng Fang wrote:
> Hi,
>
> We need to disable VCS monitoring on two oracle resources during a
> certain period of the day. We are doing this because we have two
> oracle databases (in the same service group) that are brought down
> (with oracle
> command) for cold backup every night. When VCS notices the database is
> down, it sends out an alert to our page phone saying the oracle
> resource is faulted vis the notifier. As a short term solution, we
> want to disable the agent monitoring on the oracle resource while the
> database is shut down for backup.
>
>
Instead of going through all of that, have you thought about just
backing up the databases using the oracle tools (or veritas tools) that
can do it live?
_______________________________________________
Veritas-ha maillist - Veritas-ha@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-ha
*****
The information transmitted is intended only for the person or entity to which
it is addressed and may contain confidential, proprietary, and/or privileged
material. Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon this information by persons or entities other
than the intended recipient is prohibited. If you received this in error,
please contact the sender and delete the material from all computers. GA625
_______________________________________________
Veritas-ha maillist - Veritas-ha@mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-ha
