Donald K. Burleson
Oracle Optimal Flexible
In accordance with Cary V. Millsap of the Oracle
National Technical Response Team, the OFA process involves the
following three rules:
1. Establish an orderly operating system directory structure in
which any database file can be stored on any disk resource.
* Name all devices that might contain Oracle data in such a manner
that a wild card or similar mechanism can be used to refer to the
collection of devices as a unit.
* Make a directory explicitly for storage of Oracle data at the same
level on each of these devices.
* Beneath the Oracle data directory on each device, make a directory
for each different Oracle database on the system.
* Put a file X (X is any database file) in the directory
/u??/ORACLE/sid/type_desig (or on W2K or NT: C:\oracle\sid\type_desig)
if and only if X is a control file, redo log file, or datafile of
the Oracle database whose DB_NAME is sid. The type_desig specifies
the type of file to be placed in the directory at that location and
is usually data, index, control or redo.
This is an
excerpt by Mike Ault’s book “Oracle
Administration & Management”. If you want more current Oracle tips
by Mike Ault, check out his new book “Mike
Ault’s Oracle Internals Monitoring & Tuning Scripts” or
Ault’s Oracle Scripts Download.
Copyright © 1996 - 2014 by
Burleson. All rights reserved.
Oracle® is the registered trademark
of Oracle Corporation.