RE: Cloning a database with backup pieces in different location

From: William Wagman <wjwagman_at_ucdavis.edu>
Date: Thu, 3 Jul 2008 09:26:53 -0700
Message-ID: <FE043305B38A0F448F3924429D650C2A082A27CD@VEXBE2.ex.ad3.ucdavis.edu>

Andrey,  

I am not connecting to the target at all, only the auxiliary.  

Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman_at_ucdavis.edu
(530) 754-6208

From: Andrey Goryunov [mailto:goryunov.oracle.l_at_gmail.com] Sent: Wednesday, July 02, 2008 8:46 PM
To: William Wagman
Cc: oracle-l
Subject: Re: Cloning a database with backup pieces in different location  

Hi William,

did you connect to the target and to the auxiliary instance at the same time?
(rman target sys_at_prim auxiliary /)

or you connected to standby instance only as rman target /

Looks like the error reports about attempts to change backup or standby controlfile

Cheers
Andrey

2008/7/3 William Wagman <wjwagman_at_ucdavis.edu>:

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_at_ucdavis.edu
(530) 754-6208

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






-- 
Regards,
Andrey Goryunov 


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

Received on Thu Jul 03 2008 - 11:26:53 CDT