Re: OMF or not OMF?

From: Freek D'Hooge <>
Date: Fri, 21 Mar 2014 18:47:29 +0100
Message-ID: <1395424049.31335.11.camel_at_dhoogfr-lpt1>


I use OMF for all databases I create, independent of they are using ASM or not and for all files.
The only thing I notices was that on non ASM, the "per day" directories for the archived redo logs seem to be not removed after the archived redo logs where removed from them (by the rman backup). So you would have a list of empty directories in the fast recovery area. (possibly version dependent)

Also read the documentation about how the different omf parameters affect each other.

For the rest, it makes life easier


Freek D'Hooge
Exitas NV
Senior Oracle DBA
tel +32(03) 443 12 38 

On vr, 2014-03-21 at 05:34 -0700, Jeff C wrote:

> I have never used OMF for my database file structure and I was
> wondering is this what everybody is doing now? I realize that if you
> are using ASM you have to go with OMF so I am really only talking no
> ASM users. I guess I have always like control my file names and
> locations. But my next database I am about to create I was thinking of
> trying OMF.
> If I do go with it I will probably still manually control the location
> of the control files and archive files. Can you also create a non OMF
> temp tablespace?
> Thanks for any input.
Received on Fri Mar 21 2014 - 18:47:29 CET

Original text of this message