| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Seeking opinions
This is hogwash. OFA perfectly helps to separate the datafiles from
different
database instances. We run well over 300+ Oracle databases here and the ONLY
extension we have to OFA is that I add a /data /control and /redo directory
to the file systems for just a little extra protection from possible inode
corruption.
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him.
-----Original Message-----
Sent: Tuesday, April 02, 2002 7:38 AM
To: Multiple recipients of list ORACLE-L
Paul,
I live under similiar standards. They make sense here becuase, when one looks at the big picture, they need these types of standards to help the DBA's (there are three of them) to cope with the many many Oracle instances across multiple platforms (NT, Sun Unix, Dec Unix).
I look at it this way - at least it's a standard - better than no standards at all.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Monday, April 01, 2002 5:48 PM
To: Multiple recipients of list ORACLE-L
Hi everyone.
I'm currently working at a client where the OFA standard has been (as they put it) "taken to the next level". I disagree with their approach, and I'd be interested to see what list members think.
The client believes that any DBA (there are about 16 on staff) should be able to locate data files in any database without querying the data. To this end, mount points are named both /unnn (e.g., /u001) and /annn (e.g., /a001). "System" datafiles (system, temp, rollback tablespaces) go only on the /unnn mount points, and in particular, datafiles for certain tablespaces must go on certain mount points--for instance rollback tablespace files always go on /u004.
"User" datafiles are allowed on /a001 and /a002, tables and indexes, respectively.
To my mind, this standard changes the Optimal Flexible Architecture to the Sub-optimal Inflexible Architecture, and all just to avoid a data dictionary query. What do you think?
Thanks,
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 02 2002 - 09:58:26 CST
 |
 |