uvbackup vs export

[ivannavi]

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?

[chulett]

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.

[kduke]

Export. I do know how uvbackup works but prefer exports.

[ray.wurlod]

I prefer uvbackup because it gets all those files, like DSParams, that export misses.

[kduke]

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

[ray.wurlod]

I don't need one!

[ivannavi]

Well, I guess I'll have to answer this myself:
-I know how to use export, so I will keep using it.
-I don't know how to use uvbackup, so I will not use it.