Ever since we have installed DataStage we have been using Kim Dukes scripts to backup projects. But this involves the Windows box with client.
I have found the following topics:
viewtopic.php?t=88042&highlight=uvbackup
viewtopic.php?t=84913&highlight=uvbackup
viewtopic.php?t=110182
But I still don't quite understand why is uvbackup not recommended. What are the pros and cons?
uvbackup vs export
Moderators: chulett, rschirm, roy
I think mostly because only Ray actually uses it.
Honestly, I have no idea. For the longest time I didn't even know it existed, only learning of it here. Since then, I've just stuck with the 'traditional' client-based solution I've always done, exports of all projects. Mostly since I would know what to do with them in the event of an emergency, can't really say the same for a 'uvbackup'. And never really bothered to learn it, either.
Curious what other's experience with it has been, especially if they've had to recover something using it.
Honestly, I have no idea. For the longest time I didn't even know it existed, only learning of it here. Since then, I've just stuck with the 'traditional' client-based solution I've always done, exports of all projects. Mostly since I would know what to do with them in the event of an emergency, can't really say the same for a 'uvbackup'. And never really bothered to learn it, either.
Curious what other's experience with it has been, especially if they've had to recover something using it.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I have a script for those.
Code: Select all
#!/usr/bin/ksh
# -----------------------------------------------------------------
# Script Name: KimBackupFiles.ksh
# -----------------------------------------------------------------
# Usage:
# KimBackupFiles.ksh y|n
# -----------------------------------------------------------------
# Change History
# Who When What
# --------------- ---------- ------------------------------------
# Kim Duke 01/01/2005 Original Version
# -----------------------------------------------------------------
if [ $# -gt 0 ]
then
DEBUG_SW=$1
else
DEBUG_SW="n"
fi
if [ "${DEBUG_SW}" = "y" ]
then
set -x
fi
# -----------------------------------------------------------------
cd $HOME
pwd
mkdir $HOME/SavedFiles
# -----------------------------------------------------------------
# dsadm home
# $HOME/bin
# -----------------------------------------------------------------
find bin -print | cpio -padmuv $HOME/SavedFiles
DSHOME=`cat /.dshome`
# -----------------------------------------------------------------
# $DSHOME/dsenv
# -----------------------------------------------------------------
cd $DSHOME
pwd
# -----------------------------------------------------------------
# $DSHOME/.developer.adm
# $DSHOME/.dsadmin
# $DSHOME/.dsbuildinfo
# $DSHOME/.dsrel
# $DSHOME/.odbc.ini
# $DSHOME/.prodmgr.adm
# $DSHOME/.profile
# $DSHOME/.uvconfig
# -----------------------------------------------------------------
cp .[a-z]* $HOME/SavedFiles
# -----------------------------------------------------------------
# $DSHOME/dsenv
# -----------------------------------------------------------------
cp dsenv* $HOME/SavedFiles
# -----------------------------------------------------------------
# $DSHOME/uvodbc.config
# -----------------------------------------------------------------
cp uvodbc* $HOME/SavedFiles
# -----------------------------------------------------------------
# $DSHOME/uvconfig
# -----------------------------------------------------------------
cp uvconfig* $HOME/SavedFiles
if [ "${DEBUG_SW}" = "y" ]
then
echo "Press return \c"
read dummy
fi
# -----------------------------------------------------------------
# $DSHOME/../Configurations
# -----------------------------------------------------------------
cd ..
pwd
find Configurations -print | cpio -padmuv $HOME/SavedFiles
if [ "${DEBUG_SW}" = "y" ]
then
echo "Press return \c"
read dummy
fi
# -----------------------------------------------------------------
# uvodbc.config files
# -----------------------------------------------------------------
cd Projects
pwd
find . -name uvodbc.config -print | cpio -padmuv $HOME/SavedFiles
if [ "${DEBUG_SW}" = "y" ]
then
echo "Press return \c"
read dummy
fi
# -----------------------------------------------------------------
# DSParams
# -----------------------------------------------------------------
find . -name DSParams -print | cpio -padmuv $HOME/SavedFiles
if [ "${DEBUG_SW}" = "y" ]
then
echo "Press return \c"
read dummy
fi
# -----------------------------------------------------------------
# .developer.adm
# .operator.adm
# .prodmgr.adm
# -----------------------------------------------------------------
find . -name '.[a-z]*' -print | cpio -padmuv $HOME/SavedFiles
if [ "${DEBUG_SW}" = "y" ]
then
echo "Press return \c"
read dummy
fi
# -----------------------------------------------------------------
# QualityStage/bin/qsenv
# -----------------------------------------------------------------
cd ../..
cd QualityStage
pwd
cp ./bin/qsenv $HOME/SavedFiles
if [ "${DEBUG_SW}" = "y" ]
then
echo "Press return \c"
read dummy
fi
cd $ORACLE_HOME/network/admin
cp tnsname* $HOME/SavedFiles
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: