hi Bruce,
Your setup for TDPO seems to be fine. Just want to add something to do for
RMAN.
On location B:
% rman
RMAN> connect target
RMAN> connect rcvcat <catalog info>
RMAN> restore controlfile
RMAN> sql 'alter database mount'
RMAN> restore database
RMAN> recover database
Of course you will have to allocate the channels and set the correct env
vars.
reagards,
Thiha
>I'm wondering if anyone has successfully restored using RMAN from a di=
>fferent TSM server. One of our DBA's is attempting to do this.
>Environment :-
>Oracle 8.1.6.
>TDP for Oracle V.2.1.9 (no we wont use V2.1.10 because it core dumps o=
>n any TSM client with cloptsets).
>TSM server version 4.1.2.0
>Solaris 2.07
>The scenario is as follows : -
>Location A contains TSM server xx . Oracle DB yy and DMSO_NODE zz
>So yy backs up to server xx , via TSM client zz=A0 ( using dsm.optora =
>to point to server xx in the dsm.sys file)
>Location B contain TSM server aa.=A0 Oracle DB bb and DSMO_NODE cc
>aa backs up to server bb , via TSM client cc ( using dsm.optora to poi=
>nt to server cc in the dsm.sys file)
>To restore yy to Node in Location B, my intention for him (DBA)=A0 is =
>to :-
>export DSMO_NODE=3Dzz (as known in location A)
>export DSMI_CONFIG=3D/home/oracle/dsm.optorarest
>This opt file points to server xx (location A) in dsm.sys stanza.
>We've set up TDPO.zz password file.....
>Will this work or, is there anything else required?????
>We want to get a handle on this to perform cross server/cross client r=
>estores, as we have a local TSM server per tech suite (of which there =
>are several), and DBA's want to restore Oracle DB's between locations f=
>or BCP purposes.
