RE: Create standby DB non-ASM, non_OMF from Primary ASM and OMF
Date: Fri, 15 Feb 2008 08:21:59 +1030
Thanks to everyone who has responded.
Pete, you are absolutely right. this isn't something I would propose in any environment that was in anyway important or business critical. It was more of a technical question on whether it was possible to achieve it without ongoing maintenance in the event a datafile etc was added.
Many thanks for the pointers to DBMS_FILE_TRANSFER, i hadn;t thought of that as an option, tending to always use RMAN. For my understanding, I will give that option a try !
> From: peter.sharman_at_oracle.com
> To: campbell.neil_at_hotmail.com; oracle-l_at_freelists.org
> Subject: RE: Create standby DB non-ASM, non_OMF from Primary ASM and OMF
> Date: Fri, 15 Feb 2008 02:17:39 +1100
> 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.
> "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
New music from the Rogue Traders - listen now! http://ninemsn.com.au/share/redir/adTrack.asp?mode=click&clientID=832&referral=hotmailtaglineOct07&URL=http://music.ninemsn.com.au/roguetraders Received on Thu Feb 14 2008 - 15:51:59 CST