Hi Folks,
We have made a minor change to the backup.sh script to make it more robust for use with Oracle. In short we have added the consistent flag to the arguments passed to the Oracle dump function. This means that the dump process shall be aware of current transactions and manage them in an appropriate way.
This code snippet is the oci8 section of the backup.sh script and the change is in bold.
Hope this helps…also this change will be passed on to our account manager…
"oci8")
args="";
if [ "${DB_USERNAME}" != "" ]; then
args="${args} ${DB_USERNAME}";
fi
if [ "${DB_PASSWORD}" != "" ]; then
args="${args}/${DB_PASSWORD}";
fi
if [ "${DB_HOSTSPEC}" != "" ]; then
sid=${DB_HOSTSPEC#SID=}
sid=${sid%%)}
args="${args}@${sid}";
fi
if [[ -z $remote ]];then
args="$args file=${dumpfile}"
else
args="$args file=${remotefile}"
fi
## Added read-consistent exports for in-use database. GU 21-Nov-06
args="$args consistent=Y"
##
if [[ -z $remote ]];then
exp ${args}
else
ssh ${remote} "exp ${args}"
scp ${remote}:${remotefile} ${dumpfile}
[[ $? == 0 ]] && ssh ${remote} "rm -f ${remotefile}"
fi
if [ $? -gt 0 ]; then
echo "Unable to create dumpfile ${dumpfile}."
echo "Aborting."
exit 5
fi
;;
Thanks for this. We have made this change and it will be available in the next release.