Hi Bruce,

I believe that is all,
Our DBAs have done this before.

Have you got a problem ?

Regards
 
Stephen Mackereth


-----Original Message-----
From: Bruce Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Monday, 15 January 2001 20:47
To: [EMAIL PROTECTED]
Subject: TDP for ORACLE restores


Sorry, a subject might help...




---------------------- Forwarded by Bruce Mitchell on 15/01/2001 09:47
---------------------------

From: Bruce Mitchell on 15/01/2001 09:39

To:   [EMAIL PROTECTED]
cc:
Subject:

I'm wondering if anyone has successfully  restored using RMAN from a
different 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 on 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  ( using  dsm.optora to
point to server xx in the dsm.sys file)

Location B contain TSM server aa.  Oracle  DB bb and DSMO_NODE cc
aa backs up to server bb , via TSM client cc (  using dsm.optora to point to
server cc in the dsm.sys file)

To restore yy to Node in Location B, my intention for him  (DBA)  is to :-

export DSMO_NODE=zz (as known in location A)
export  DSMI_CONFIG=/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
restores, 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 for BCP
purposes.



LONDON
Tel:       +44(0) 207 547 4917
Fax        +44(0) 207 650 7917
Mobile    +44(0) 468 361-885
email:    [EMAIL PROTECTED]





--

This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorised copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.

This email and any attachments may contain privileged and
confidential information and are intended for the named
addressee only.  If you have received this e-mail in error,
please notify the sender and delete this e-mail immediately.
Any confidentiality, privilege or copyright is not waived or
lost because this e-mail has been sent to you in error.  It
is your responsibility to check this e-mail and any
attachments for viruses.

Reply via email to