Re: Oracle-Managed Files - your views
Date: Tue, 15 Dec 2009 16:56:20 +0000
That's good enough for me. I guess you meant to use OMF rather than OFA though.
Robert Freeman wrote:
> When one considers that ASM pretty much uses OFA, I'm hard pressed to
> be to dead set against it.
> I grant that lots of DBA's (me included) prefer our own file naming
> conventions... However, OFA files do have their own file naming
> OFA offers consistency and avoids the fat finger problem with file
> naming... :-)
> In the end, in your case would I use OFA? Probably not, but that's
> mostly personal bias. I think you'd be fine using OFA if you like.
> Robert G. Freeman
> Oracle ACE
> Ask me about on-site Oracle Training! RMAN, DBA, Tuning, you name it!
> Oracle Database 11g RMAN Backup and Recovery (Oracle Press) - ON ITS
> WAY SOON!
> OCP: Oracle Database 11g Administrator Certified Professional Study
> Guide (Sybex)
> Oracle Database 11g New Features (Oracle Press)
> Oracle Database 10g New Features (Oracle Press)
> Other various titles
> Blog: http://robertgfreeman.blogspot.com
> Check out my new blog series on installing Oracle Database 11gR2 on
> Windows using VMWare!
> *From:* Tony Sequeira <tony_at_sequeira.org.uk>
> *To:* Oracle List <oracle-l_at_freelists.org>
> *Sent:* Tue, December 15, 2009 9:20:15 AM
> *Subject:* Oracle-Managed Files - your views
> Hi group,
> I have to move a 10g (10.2.0.3) application off a Solaris 10 machine
> (using ASM) to a Windows 2003 server (don't ask).
> The required application is only one smallish schema, so I'm going to
> pre-create a database (10.2.0.4) and use export/import.
> I'm thinking of using OMF. Does anyone here have any views on OMF. My
> research has come up with the following:
> Primary advantage seems to be management (no need to specify file
> The list of disadvantages I have found are all dismissable for this
> particular application.
> File System only - I'm OK with that
> Naming Standards - No issue for this database
> Tuning - Again no issue for this database.
> S. Anthony Sequeira
> It is bad luck to be superstitious.
> -- Andrew W. Mathis
-- S. Anthony Sequeira ++ "What happened to the crewman?" "The M-5 computer needed a new power source, the crewman merely got in the way." -- Kirk and Dr. Richard Daystrom, "The Ultimate Computer", stardate 4731.3. ++ -- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 15 2009 - 10:56:20 CST