Home » RDBMS Server » Server Administration » OFA confuse me - why 3 mount points for datafiles? (10.2.0.1.0)
OFA confuse me - why 3 mount points for datafiles? [message #576321] Sun, 03 February 2013 05:08 Go to next message
piotrtal
Messages: 152
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 #576323 is a reply to message #576321] Sun, 03 February 2013 05:12 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OFA is really old stuff.
Just keep the principles, forget the examples.

Regards
Michel
Re: OFA confuse me - why 3 mount points for datafiles? [message #576324 is a reply to message #576323] Sun, 03 February 2013 05:34 Go to previous messageGo to next message
piotrtal
Messages: 152
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 Go to previous messageGo to next message
Michel Cadot
Messages: 58861
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: OFA confuse me - why 3 mount points for datafiles? [message #576327 is a reply to message #576326] Sun, 03 February 2013 06:36 Go to previous message
piotrtal
Messages: 152
Registered: June 2011
Location: Poland/Czestochowa
Senior Member

understood.
for redundancy at filesystem level it makes sense i agree - three mount points with three different separated hard drivrs.

thx Michel.
Previous Topic: find Database Size
Next Topic: Tablespace
Goto Forum:
  


Current Time: Fri Aug 22 20:46:01 CDT 2014

Total time taken to generate the page: 0.05798 seconds