Re: Cloning a database with backup pieces in different location

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Thu, 3 Jul 2008 11:19:52 +1000
Message-ID: <77a615a70807021819o7764c74fx2a83c23bddb89bb5@mail.gmail.com>


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_at_ucdavis.edu> 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_at_ucdavis.edu
> (530) 754-6208
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
J.A. van Zanen

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jul 02 2008 - 20:19:52 CDT

Original text of this message