| OFA confuse me - why 3 mount points for datafiles? [message #576321] |
Sun, 03 February 2013 05:08  |
 |
piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa
|
Senior Member |
|
|
Hi,
i encoutered lately on such statement:
Table D-7 shows a hierarchical file mapping of a sample OFA-compliant installation with two Oracle home directories and two databases. The database files are distributed across three mount points, /u02, /u03, and /u04.
from http://docs.oracle.com/html/B10811_05/app_ofa.htm
my question is:
why three mount points (/u02, /u03, and /u04) for datafiles? don' understant this.
isn't it better to store all datafiles in one mountpoint?
|
|
|
|
|
|
| Re: OFA confuse me - why 3 mount points for datafiles? [message #576324 is a reply to message #576323] |
Sun, 03 February 2013 05:34  |
|
piotrtal
Messages: 168
Registered: June 2011
Location: Poland/Czestochowa
|
Senior Member |
|
|
thx Michel.
i didn't know that. every book / tutorial / internet page which i read, they say that the best option is to be compliant and close to OFA. even for 11g. i am doing RAC stuff now and every paragraph they recommend using this naming convention.
http://docs.oracle.com/cd/E11882_01/install.112/e24321/appendix_ofa.htm#BGBIDIEC
... it is uncommont for me because i am rather oldschool type of man so if there is any way to avoid OFA i am doing this. this solution is strange for me and i don't feel this is the best option.
but i am trying to understand by what they (oracle guys) were driven to find out something like that:
/u02/app/oracle/oradata
/u03/app/oracle/oradata
/u04/app/oracle/oradata
three different mount points for dbfiles - it is recommended even for 11g (as in link which i shared above)
[Updated on: Sun, 03 February 2013 05:35] Report message to a moderator |
|
|
|
| Re: OFA confuse me - why 3 mount points for datafiles? [message #576326 is a reply to message #576324] |
Sun, 03 February 2013 06:21 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
In the old days, 3 mount points meant 3 different disks.
Now, most enterprises use disk arrays, "disks" at OS level are no more physical disks.
To use OFA in RAC in 11.2 in a non sense, the most efficient architecture is ASM.
Note that the link does not say it is recommended for the database files.
It is, of course, recommended for the other files (binaries, traces, logs...) as Oracle tools assumes this is the architecture.
Regards
Michel
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
