RE: Cloning a database with backup pieces in different location

  • From: "William Wagman" <wjwagman@xxxxxxxxxxx>
  • To: "Jack van Zanen" <jack@xxxxxxxxxxxx>
  • Date: Thu, 3 Jul 2008 09:25:42 -0700

Jack,

 

I had thought of that but at this point I am not sure if that is in fact
the issue. I am able to restore the control file and since I am using a
controlfile rather than a catalog with my RMAN backups all the
information is in the controlfile. I suspect the problem is due to the
fact that I am trying to clone the primary of a DataGuard installation
and that somehow I need to alter the controlfile and remove the
DataGuard configuration information. I'm not sure that makes sense but
that is what I am thinking at this point.

 

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208 

From: jack.van.zanen@xxxxxxxxx [mailto:jack.van.zanen@xxxxxxxxx] On
Behalf Of Jack van Zanen
Sent: Wednesday, July 02, 2008 6:20 PM
To: William Wagman
Cc: oracle-l
Subject: Re: Cloning a database with backup pieces in different location

 

since this is UNIX can't you simply put in a link that mimics the
original location of the backup pieces?

 

Brgds

 

Jack

 

On 03/07/2008, William Wagman <wjwagman@xxxxxxxxxxx> wrote: 

Greetings,

We are running Oracle 10.2.0.4.0 EE on RHEL4, 64-bit. I am using Data
Guard and doing daily RMAN backups on the primary and am not using a
catalog. I am attempting to duplicate the primary database to another
server on which, because of disk layouts the RMAN backup pieces are in a
different location than on the production server I am trying to
duplicate.

I have found instructions on how to do this. On the second box I start
up the database nomount, restore the control file from the backup pieces
on the second box, mount the database and use the catalog command to
indicate the new location of the RMAN backup pieces. That all works
fine. Then I run my script to restore and recover the database and I get
the following errors...

RMAN-03002: failure of configure command at 07/02/2008 17:03:44
RAMN-05021: this configuration cannot be changed for a BACKUP or STANDBY
control file

I don't know if there are additional steps necessary to clone the
primary database in a Data Guard configuration or if it is because I am
not using a catalog. I do realize there are certain things one cannot do
with a Data Guard configuration without a catalog and I don't know if
this is one of them. If that is not the case can anyone help me with the
additional steps I must take to get this to work. Here is the script I
am invoking from RMAN...

run {
configure auxname for datafile 1 to
'/u01/oracle/edrstest/system01.dbf';
configure auxname for datafile 2 to
'/u01/oracle/edrstest/undotbs01.dbf';
.
.
.
configure auxname for datafile 11 to
'/u01/oracle/edrstest/mvlog01.dbf';
set newname for tempfile 1 to
'/u01/oracle/edrstest/temp01.dbf';
restore database;
switch datafile all;
recover database;
alter database open resetlogs;
}

Suggestions graciously accepted. Thanks.

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208

--
//www.freelists.org/webpage/oracle-l






-- 
J.A. van Zanen 

Other related posts: