Thursday, March 10, 2016

DR required knowledge.

#!/bin/ksh -x

. $HOME/.profile

# Remember trailing / for directories!

/usr/bin/dsmc incremental -subdir=yes -compression=yes /apps2/product/12.1.0.2/  /home/apps/

Assume you schedule your tsm back 

05 06 * * * /apps2/oracle/local/bin/tsm_incremental.sh > /home/apps/log/tsm_incremental_`date +\%Y\%m\%d\%H\%M\%S`.log 2>&1

dmsc -servername=apps(username)

tsm>  query backup -ina -subdir=yes /apps2/ebs/product/*.tar

TSM> restore -inactive /apps/product/ebs/* -subdir=yes


example db side.(Latest database backup set)

  1. du -sh check the space on the target server.
  2. make sure your ip address, hostname and /ect/hosts setup
  3. restore oracle db binary
  4. restore TNS_ADMIN
  5. restore/orafra/SID/(required directory)
  6. restore /apps/oracle/local/certificates


$ram target=/
startup nomount
restore controlfile from autobackup;
shutdown immediate;
startup mount;
restore database;
#recover database
sql "alter database open resetlogs";

No comments: