ADSM-L

Oracle8/rman/bare-ish metal recover?

1999-11-08 11:29:31
Subject: Oracle8/rman/bare-ish metal recover?
From: Thiha Than <thiha AT US.IBM DOT COM>
Date: Mon, 8 Nov 1999 09:29:31 -0700
hi Andrew,

>I have the following situation.  An Oracle8 database on node1 backed up to
ADSM
>server using rman.  I can recover the files on node1 without any problem.
I
>would like to be able to recover the database onto node2.  (Just as a
>precaution in case node1 were to suffer severe failure.)  Node2 is also
>currently a server that is being used, and so cannot be configured as
node1
>(IP, hostname, etc.)  Using dsmc on node2 I can query backups from node1,
>however, I have not managed to find a way to convince rman that it should
be
>looking for backups from node1.  When I try to do the restore I get the
>following:

Try the following

Assume the db name on node1 is test1.

On node2:

startup nomount database test1 on node2

% rman
RMAN> connect target
RMAN> connect rcvcat <catalog info>
## before restoring the control file
## make sure you have generated password file on node2 using
DSMO_NODE=node1 env var.
## after generating the password, you should have the password file
ADSMO.noe1 on node2

RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(DSMO_NODE=node1);
3> restore controlfile to '/tmp/controlfile';}

RMAN> sql 'alter database mount'
RMAN> run {
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(DSMO_NODE=node1);
3> restore database;}
RMAN> recover database


you should able to restore and recover the test1 database from node1 to
node2 in this way.

regards,
Thiha
<Prev in Thread] Current Thread [Next in Thread>