How restore database from TSM back for DR Test.

 Assume your oracle database rman backup files are stored in TSM.

Make sure the mount point is comes up.

dsmc

tsm > restore -inactive /apps/* sudir=yes

All the files will be restore from tsm for your environment. like oracle home, TNS_ADMIN/ ... etc.

tsm > restore - inactive /orafra/$SID subdir=yes

Sames as above all the files will be restored from /orafra/$SID/ Ctl, dbf, redo .. etc..

Restore function invoked.

Assume all the neccessary files are restored from TSM for your environment.

$rman target=/

STARTUP NOMOUNT

RESTORE CONTROL FILE FROM AUTOBACKUP;

SHUTDOWN IMMEDIATE;

STARTUP MOUNT;

RESTORE DATABASE;

RECOVER DATABASE;

SQL "ALTER DATBABASE OPEN RESETLOGS";

ALTER DATBASE OPEN RESETLOGS;