-
Oracle RAC init.ora parameters
What would you recommend for the following parameters in a 2 node RAC database, should the locations to which they point be on shared storage or not ?
We are using OCFS Version 1 and a 10.1.0.4 database.
I am in the process of creating my first RAC database and I am a little confused.
The parameters in question are:-
background_dump_dest
core_dump_dest
user_dump_dest
Should each instance have its own location for each of the above as I would view them as being instance specific as opposed tied to the database.
Reading notes on Metalink it would appear that they have only a single location that is database wide as opposed to instance specific.
Any advice or help would be much appreciated,
Cheers,
ed
-
if you are using ocfs you cant put alert logs, trace files on them - its not posix compliant (yet)
we keep those directories local to each server, i think it provides a 'cleaner' solution as you can see what instance is producing what easier.
-
What i think I realised last night whilst musing this over in bed last is that the $ORACLE_BASE/admin//bdump directories are infact using the db_name and not the instance_name - therefore as there will only be one locally mounted disk of the same name visible on each node this is where my confusion arose i believe. Hopefully the Unix guys will get my boxes prepared and i can have a go at installing :-)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|