Re: Disk level cloning and ASM

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Mon, 2 Mar 2009 01:05:19 -0200
Message-ID: <172762180903011905s6cb7f536ldbb9234046fe4a0c_at_mail.gmail.com>

I'm not entirely certain. But I would try with ASMCMD (alias) and with rename file to options in alter database from pl/sql (you'd need a controlfile from prod)

I will perform some tests, but perhaps this can get you started.

Kind regards.

Alan Bort
Oracle Certified Professional

On Sun, Mar 1, 2009 at 11:57 PM, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:
> Hi All,
>
> I've got two 10gR2 databases running on ASM.  One is pqprd (production), and one is pqpep (preprod).
>
> I've recently cloned pqpep from pqprd.  This was done at the storage level, by copying all of the raw devices
> and presenting them to the preprod hosts.  (Should have mentioned, both prod and preprod are 3-node RAC.)
>
> My problem is, now the filename paths are of the form:
> +PQ_DATA_DG/pqprd/*
>
> because they were copied from prod.
>
> They should be:
> +PQ_DATA_DG/pqpep/*
>
> So, is there a way to deal with this?
>
> Do I use 'nid'?  Will that take care of it?  Some other method?
>
> Any help is appreciated....
>
>
> Thanks!
>
> -Mark
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Sun Mar 01 2009 - 21:05:19 CST