ADSM-L

TDP for ORACLE restores

2001-01-16 11:46:54
Subject: TDP for ORACLE restores
From: Thiha Than <Thiha_Than AT TIVOLI DOT COM>
Date: Tue, 16 Jan 2001 08:46:52 -0800
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.
<Prev in Thread] Current Thread [Next in Thread>