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;

ADCGNJAR

Ref Notes:  Note 1609939.1

Oracle has introduced adcgnjar utililty for the deployments which helps to create customall.jar file in $JAVA_TOP. This jar file will picked and executed by the application server.

• Place required OAF CO/VO/EO files in $JAVA_TOP respective folder.

• Run adcgnjar utile package which is available in $AD_TOP.

• Add the entry for customall.jar in the ebsProduct Manifest.xml file

• Bounce the mid-tier server

   { sleep 1s; echo apps; sleep 1s; echo appspassword;} | adcgnjar