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
|