Re: OMF or not OMF? DBCA or Manual scripts

From: Frits Hoogland <frits.hoogland_at_gmail.com>
Date: Mon, 24 Mar 2014 17:52:03 +0100
Message-Id: <5D1A9E0F-9EFE-4676-AB42-D7C9A74CC5AF_at_gmail.com>



I use dbca -silent with templates.

Frits Hoogland

http://fritshoogland.wordpress.com
frits.hoogland_at_gmail.com
Office phone: +31 20 8946342

(Sent from my iPhone, typo's are expected)

> Op 24 mrt. 2014 om 17:44 heeft Jeff C <backseatdba_at_gmail.com> het volgende geschreven:
> 
> Ok I think you guys have convinced me to use OMF.  Now my next question is do you create your database manually using scripts or use DBCA.  I have alway used DBCA, not really a big shop here.  I like the idea of creating the database manually using scripts but you have to manually install components and features and I afraid I might something that was needed.
> 
> 

>> On Fri, Mar 21, 2014 at 6:40 AM, Tim Gorman <tim_at_evdbt.com> wrote:
>> "What's in a name? That which we call a rose, by any other name would smell as sweet." -W. Shakespeare, "Romeo & Juliet", Act 2, scene 2
>>
>> Why do you prefer manual control of file naming? I recall scripting space management and how much needless hassle was involved in file naming and the irritation when someone on the team deviated from the preferred convention. OMF has made all of that moot, with zero downside.
>>
>> One thing I recall from bucking OMF, at least from the 10g timeframe; if you created a non-OMF file and then later drop the tablespace without the clause "INCLUDING CONTENTS AND DATAFILES", ASM would drop the alias but not the file itself. So, I periodically had to go into ASMCMD and look for "orphaned" files from tablespaces that had been dropped without the "INCLUDING" clause; not sure if that is still an issue?
>>
>> Regardless, it's useful to stop and think about why certain preferences exist; sometimes they go obsolete behind your back...
>>
>>
>>
>>> On 3/21/2014 6:34 AM, 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

>> --
>> http://www.freelists.org/webpage/oracle-l
>
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 24 2014 - 17:52:03 CET

Original text of this message