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

From: neil campbell <campbell.neil_at_hotmail.com>
Date: Thu, 14 Feb 2008 13:57:06 +1030
Message-ID: <BLU104-W35F6CDDFDDF6156DDC730BF7250@phx.gbl>

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%2Eimrworldwide%2Ecom%2Fcgi%2Dbin%2Fa%2Fci%5F450304%2Fet%5F2%2Fcg%5F801459%2Fpi%5F1004813%2Fai%5F859641&_t=762955845&_r=tig_OCT07&_m=EXT-- http://www.freelists.org/webpage/oracle-l Received on Wed Feb 13 2008 - 21:27:06 CST

Original text of this message