Re: OMF or not OMF? DBCA or Manual scripts

From: Tim Gorman <tim_at_evdbt.com>
Date: Mon, 24 Mar 2014 12:12:41 -0600
Message-ID: <53307599.5070809_at_evdbt.com>

++1 to "DBCA -silent with templates" and +1 to "DBCA to generate scripts".

Script any process that will be repeated.

On 3/24/2014 10:52 AM, Frits Hoogland wrote:
> I use dbca -silent with templates.
>
> Frits Hoogland
>
> http://fritshoogland.wordpress.com
> frits.hoogland_at_gmail.com <mailto: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
> <mailto: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
>> <mailto: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 - 19:12:41 CET