Re: Cloning a database with backup pieces in different location
- From: "Jack van Zanen" <jack@xxxxxxxxxxxx>
- To: wjwagman@xxxxxxxxxxx
- Date: Thu, 3 Jul 2008 11:19:52 +1000
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: