Re: OMF or not OMF?
- From: Freek D'Hooge <freek.dhooge@xxxxxxxxx>
- To: backseatdba@xxxxxxxxx
- Date: Fri, 21 Mar 2014 18:47:29 +0100
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@xxxxxxxxx
tel +32(03) 443 12 38
http://www.exitas.be
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.
Other related posts:
