Oracle instanse restore to another AIX-server (node)

[b1gg1e]

Hello dear all!


I'd like to find an example how to restore TDPO RMAN backup to different server (other ORA node).


Oracle instance from Server-A RMAN backed up to TSM system.
Now, I need to restore the RMAN image of Oracle instance A from TSM into Oracle system on Server-B.


Both servers are semi-production. So I don't want to mix any password files or opt. files.. like on thread http://adsm.org/forum/showthread.ph...-TDP-RMAN-backup-to-different-server-location

So, I see scenario like this (my node names for ora is DB-A_ORA and DB-B_ORA):
1. grant proxynode target=DB-A_ORA agent=DB-B_ORA (to share backup sets of Server-A to Server-B)
2. run the restore on Server-B using RMAN.

But it seems to me that I have to use such option as "asnodename", but where I have to put it?

Thank's all in advance.

 

[cilesiz]

Hi,

1. copy the server stanza entries ( with cut and paste ) for the source db from dsm.sys to the target db

e.g. :

* Stanza for the local DB
Servername DB-B_ORA
NODename DB-B_ORA
TCPServeraddress xxxx.xxx.xxxx
TCPPort xxxx
USERS orauseirdb

* Stanza for the source DB
Servername DB-A_ORA
NODename DB-A_ORA
TCPServeraddress xxxx.xxx.xxxx
TCPPort xxxx
USERS orauseirda

2. copy the tdpo_DB-A_ORA.opt and dsm_DB-B_ORA.opt from source to the target system.

3. switch user to target oracle userid
e.g. su - orauseirdb

4. set password for the source system with tdpoconf

e.g. cd /usr/tivoli/tsm/client/oracle/bin64 ( on AIX !)
cd /opt/tivoli/tsm/client/oracle/bin64 ( on Linux or Solaris ! )
tdpoconf passw -tdpo_opt=tdpo_DB-A_ORA.opt