Re: OMF or not OMF?
From: Freek D'Hooge <freek.dhooge_at_gmail.com>
Date: Fri, 21 Mar 2014 18:47:29 +0100
Message-ID: <1395424049.31335.11.camel_at_dhoogfr-lpt1>
Hi,
Date: Fri, 21 Mar 2014 18:47:29 +0100
Message-ID: <1395424049.31335.11.camel_at_dhoogfr-lpt1>
Hi,
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
regards,
-- Freek D'Hooge Exitas NV Senior Oracle DBA email: freek.dhooge_at_exitas.be tel +32(03) 443 12 38 http://www.exitas.be On vr, 2014-03-21 at 05:34 -0700, Jeff C wrote:Received on Fri Mar 21 2014 - 18:47:29 CET
> 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.
-- http://www.freelists.org/webpage/oracle-l