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@xxxxxxxxxxxx> 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 > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l