Re: IFILE: Which initialization parameters go here?

In article <3516C014.191BC3B7_at_KNOTES.KODAK.COM>, Zdenka Spoljaric <928330N_at_KNOTES.KODAK.COM> wrote:
>IFILE should have only those parameters which are common for database
>regardless of the mode you are running it. This are parameters which you
>apply always ( like db_block, dump_dest_...,)

To say the same a little more clearly:

config<sid> should have parameters that are the same between instances. init<sid> should have parameters that vary between instances.

Joe Greene's Oracle DBA Survival Guide has a pretty good method of organizing a single init.ora, if you want to go that route. It's really up to the dba how to organize it. Having had to figure out all sorts of strange situations, I would advise not to stray too far from Oracle's default structure, and document what you do change, even simple file linking.

>
>
>Rob Forster wrote:
>
>> What parameters should go in an IFILE and which should stay in
>> INIT<SID>.ORA ?
>> I'm trying to figure out which archivelog parameters should go into the
>> IFILE and which ones shouldn't. (ie. LOG_ARCHIVE_START, LOG_ARCHIVE_DEST
>> and LOG_ARCHIVE_FORMAT.
>>
>> TIA,
>> Rob.
>
>
>

-- 
These opinions are my own and not necessarily those of Information Quest
jgarry@eiq.com                           http://www.informationquest.com
http://ourworld.compuserve.com/homepages/joel_garry
"See your DBA?"  I AM the @#%*& DBA!