Re: Oracle-Managed Files - your views

From: Robert Freeman <>
Date: Tue, 15 Dec 2009 08:45:21 -0800 (PST)
Message-ID: <>

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 conventions... 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! Author:
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: Check out my new blog series on installing Oracle Database 11gR2 on Windows using VMWare!

From: Tony Sequeira <> To: Oracle List <> Sent: Tue, December 15, 2009 9:20:15 AM
Subject: Oracle-Managed Files - your views

Hi group,

I have to move a 10g ( 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 ( 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 names/locations...)

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
-- --
Received on Tue Dec 15 2009 - 10:45:21 CST

Original text of this message