Create standby DB non-ASM, non_OMF from Primary ASM and OMF
- From: neil campbell <campbell.neil@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 14 Feb 2008 13:57:06 +1030
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--
//www.freelists.org/webpage/oracle-l
Other related posts:
