As root dsmc or, for more complex configurations, specify an optfile: dsmc -optfile=/opt/tivoli/tsm/client/ba/bin/dsm-ora.opt List backup files: tsm> q backup “/oracle/*” -subdir=yes -inactive Restore: tsm> restore “/oracle/mydb/*” /oracle/ -subdir=yes -pick Note how the second mention of directory path ommits the lowest directory. tsm> + # to select all tsm> o # ok, start restore
Read More IBM Tivoli restores using dsmcBIOS build date should correspond to approximate manufacture date for a server, is given with (as root): dmidecode | egrep -i ‘date|product’
Read More Server age with dmidecode|grep Date# Delete files older than 15 minutes find /ORA_DISK/redoarch/ -name ‘arch_*.dbf’ -mmin +15 -delete #Delete files older than 2 days 50 8 * * * find /ORA_DISK/redoarch/ -name ‘arch_*.dbf’ -mtime +2 -delete Old versions of unix find do not have the -delete option, so instead: # Delete files older than 15 minutes find /ORA_DISK/redoarch/ -name […]
Read More Find delete old filesSample restore from command line Tivoli Storage Manager. Run as root. ps -ef | grep dsm #here look to see if ‘optfile’ is set cd /mydir dsmc -optfile=/opt/tivoli/tsm/client/ba/bin/dsm-ora.opt tsm> restore /mydir/*.dbf -inactive -pick tsm> 1 #here choose which file number you want tsm> 2 #choose another file if needed tsm> o #o=’ok’ tsm> quit You […]
Read More Tivoli Storage Manager simple restoreFind out what directories are using up disk space in unix with this command: du -sk * | sort -n I often put it into a function so I can call it quickly: g () { du -sk * | sort -n } df -h (df -k on old machines) shows the filesystem disk utilisation.
Read More du -sk to identify space usage unixcp -pR logs logs`date +$d%m%y%T` Creates a timestamped copy directory named like “logs041015:44:42”.
Read More Keep log files by copying into new directory unixFiles in /etc/cron.d only work if they are not executable files (at least that is the case on newer version of unix/linux).
Read More /etc/cron.d not working failsftp can be used in shell scripts by specifying the ftp password in a .netrc file. On the source server create/edit this file: $ vi $HOME/.netrc Add in a line with the username password details: machine targetservername login targetusername password targetpassword Make that file secure (the ftp actually fails if you don’t): $ chmod 600 […]
Read More Use ftp in shell scripts with password in .netrcIt’s often a pain getting X windows GUIs like the Oracle Installer and DBCA to run on Micrsoft Windows PC clients. Emulators like Reflection-X, KEA-Term, and Exceed work ok, but they cost money to licence and require source media and local admin rights to install. Those things can take an age to organise in large […]
Read More Free X windows emulator for running Oracle Installer9i on Red Hat Linux (with the exception apparently 32-bit on RH3) won’t install unless you revert the c compilers back to old versions. Horrible. But fixed (I am told) with oracle 10g. And its not something you necessarily want to do just for the install – because future patchsets and even some one off […]
Read More Old c compilers needed for 9i on Red Hat Linux