Oracle: OFA Part 6

Dear Readers,

My name is Franz Devantier, creator of this blog.  I am an Oracle Certified Professional (OCP DBA 11g) Security DBA.  I will be sharing with you the basic duties of an Oracle DBA, and also some of the undocumented, and not so well known tasks. 

OFA – Optimal Flexible Architecture

(Part 6, Oracle Files)

One of the problems before OFA, was that some DBA’s were placing database files in $ORACLE_HOME/dbs.

Having data files, control files, and redo log files, in a sub-tree of the directory holding the Oracle software, caused a bottleneck on the server.  Essentially they were putting everything on a single disk.  Also imagine the difficulties that you could expect if you wanted to upgrade the Oracle data base software, and your data files were in a sub-tree, of the software directory structure.

So you can understand how the goals of OFA, was to separate software and data, and the distribution of files across multiple disk drives.   Files that fell into different categories were separated, to minimize the impact by operations on a specific file category on other file categories.

• Product files:  Oracle database software and tools supplied by Oracle.
• Administrative files: Metadata files, archived redo log files, database creation scripts, alert logs, trace files, export dump files, and parameter files.
• Local Software: Custom applications.
• Database Files: Control files, redo log files, and data files.

Standard   7:  The ability to consistently refer to objects, regardless of the infrastructure changes that have taken place.

Under this standard, we must classify Oracle files, according to different life-spans, maintenance schedules, and security requirements.

Product files, Administrative files, Local software, and database files must be located in different directory structures, and preferably different file systems or disk drives.

Franz Devantier,

Need a database health check?

devantierf@gmail.com

Income stabilizer (win-win opportunity)

Join the carefully selected and tested cash-flow generating program below to potentially create a long-term residual or annuity type income enhancer for yourself.

Traffic Wave - Free Report:  The report will give you all the information you need to start making a nice long-term residual income stream for yourself.