You will need to do the following on the server where you will be doing the 
restore:

1) Copy the password file TDPO.XXXXXX from the 
/usr/tivoli/tsm/client/oracle/bin of the source server to the target
2) Modify the /usr/tivoli/tsm/client/oracle/bin/tdpo.opt TDPO_NODE variable to 
point to the source server
3) Modify the  /usr/tivoli/tsm/client/ba/bin/dsm.sys RMAN stanza's Servername 
to point to the source.

Realize that making these changes affect's the current RMAN backup scheme on 
the destination server. Remember when done to put these entries back or else 
your backup associations will be messed up. Better yet, create a parallel RMAN 
virtual restore environment so that you do not affect the current backup 
environment ( ie create a RMANTSM_RESTORE stanza in the dsm.sys, create another 
tdpo.opt and call it tdpo_restore.opt etc ... )

Rich


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
Abayomi Oni
Sent: Friday, August 24, 2007 9:44 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] TSM - Oracle RMAN restore


I did an Oracle TSM-RMAN backup on node1, how can I restore and recover
the backup onto an oracle DB on node2. The two nodes are registered in
the same TSM server.
This e-mail and its attachments transmitted with it are confidential and 
intended solely for the use of the addressee. If you have received this e-mail 
in error, kindly notify the sender. If you are not the addressee, you should 
not disseminate, distribute or copy this e-mail.

Any views or opinions expressed in this e-mail or attachments are solely those 
of the sender and may not necessarily represent the views and opinions of First 
City Monument Bank Plc. This e-mail may however contain information which is 
protected by legal, professional or other privilege. The contents of this 
e-mail and its attachments have been scanned for all viruses and all reasonable 
precaution have been taken to ensure that no viruses are present. You should 
however carry out your own virus checks before opening this e-mail or its 
attachments as First City Monument Bank Plc cannot accept responsibility for 
any loss or damage arising from the use of this e-mail or its attachments.