RE: Create standby DB non-ASM, non_OMF from Primary ASM and OMF

Others have mentioned the DBMS_FILE_TRANSFER package, but I would answer with a different question - why would you even want to do this?

Think about it from a different perspective. What do you gain from having the two environments dissimilar? If you have a standardized configuration (be that one way or the other - ASM/OMF or non-ASM/non-OMF), then you don't need to remember two different configurations.

I'd need to see a valid reason for doing so is what I'd guess I'd be saying. Now a valid reason might exist - I just can't think of what it would be.

Pete
 
"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
 
"Oh no, it's not, it's much harder than that!" Bruce Pihlamae, long term Oracle DBA

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-
> bounce_at_freelists.org] On Behalf Of neil campbell
> Sent: Thursday, 14 February 2008 2:27 PM
> To: oracle-l_at_freelists.org
> Subject: Create standby DB non-ASM, non_OMF from Primary ASM and OMF
>
>
> Hi
>
> I am having a bit of a mental block !
>
> Primary is 10.2.0.3 on ASM and using OMF, i want to create a standby
> that does not use ASM and OMF, and i'm (trying to) use RMAN DUPLICATE
>
> When creating the standby, I dont think I can use DB_FILE_NAME_CONVERT
> as in :- DB_FILE_NAME_CONVERT = '+DATADG', '/u02'
>
> The result would be a filename being converted from something like
> +DATADG/datafile/system.259.639693489 to
> /u02/ora/datafile/system.259.639693489
>
> When I really want the datafile to be something like
> /u02/oradata/stdby/system01.dbf'
>
> I could during the RMAN duplicate, use a run block to run SET NEWNAME,
> which would rename each of the datafiles to the format I want,
> but then, what would happen when a new file is added to the primary,
> how would that be propagated to the standby ?
>
> Is there a way around this, or do i have to go from OMF to OMF ?
>
> Cheers
>
> Neil
>
>
>
>
> _________________________________________________________________
> It's simple! Sell your car for just $30 at CarPoint.com.au
> http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fsecure%2Dau%2Eimrworldw
> ide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1
> 004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT--
> http://www.freelists.org/webpage/oracle-l
>

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