Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 
 

Optimal Flexible Architecture OFA for Windows tips

Oracle Database Tips by Donald BurlesonMay 13,  2015

Question:  What is the Oracle OFA architecture standard for Windows?

Answer:  The Oracle OFA standard is very important, even for small Windows servers, and it's critical to use OFA to keep all data files in a standard location.

See this link for a full copy of Oracle's Optimal Flexible Architecture (OFA) standard.

As of Oracle 11g, this is the OFA standard for Windows, as issued by Oracle Corporation:

C:\oracle             --First logical drive

    \ora10            --Oracle home

      \bin            --Subtree for Oracle binaries

      \network        --Subtree for Oracle Net

      \...

    \admin            --Subtree for database administration files

      \prod           --Subtree for prod database administration files

        \adhoc        --Ad hoc SQL scripts

        \adump        --Audit files

        \bdump        --Background process trace files

        \cdump        --Core dump files

        \create       --Database creation files

        \exp          --Database export files

        \pfile        --Initialization parameter file

        \udump        --User SQL trace files

F:\oracle             --Second logical drive (two physical drives, striped)

    \oradata          --Subtree for Oracle Database files

      \prod           --Subtree for prod database files

        redo01.log    --Redo log file group one, member one

        redo02.log    --Redo log file group two, member one

        redo03.log    --Redo log file group three, member one

G:\oracle             --Third logical drive (RAID level 5 configuration)

    \oradata          --Subtree for Oracle Database files

      \prod           --Subtree for prod database files

        control01.ctl --Control file 1

        indx01.dbf    --Index tablespace datafile

        rbs01.dbf     --Rollback tablespace datafile

        system01.dbf  --System tablespace datafile

        temp01.dbf    --Temporary tablespace datafile

        users01.dbf   --Users tablespace datafile

H:\oracle             --Fourth logical drive

    \oradata          --Subtree for Oracle Database files

      \prod           --Subtree for prod database files

        control02.ctl --Control file 2


This very brief chapter assumes you are using the native Windows file system and not Oracle ASM.  OFA stands for Optimal Flexible Architecture, and can be used on any Operating System, including Windows.  The only thing to really consider is the resources available to you.
 
In general, one would want to place items that are written sequentially, such as Archivelogs (Flashback Recovery Area), Redo Logs, RMAN Backups, and Exports onto a RAID1 (Mirror Set) device.
 
For data files, ideally we would use RAID 10 (striped and mirrored).
However, many places do not wish to spend so much on spindles, so they use RAID5 or RAID6.  There is a write penalty for using those, but it does protect the data.
 
Example of OFA on Windows - Source: Oracle Database Platform Guide 11g Release 1 for Windows
 
C:\oracle\product     --First logical drive - Oracle Base
    \10.2.0                    --Oracle home
      \bin                      --Subtree for Oracle binaries
      \network              --Subtree for Oracle Net
      \...
    \admin                   --Subtree for database administration files
      \prod                    --Subtree 'prod' database administration files
        \adhoc                --Ad hoc SQL scripts
        \adump              --Audit files
        \bdump              --Background process trace files
        \cdump              --Core dump files
        \create                --Database creation files
        \exp                    --Database export files
        \pfile                  --Initialization parameter file
        \udump              --User SQL trace files
 
F:\oracle                    --Second logical drive (RAID1)
    \oradata                 --Subtree for Oracle Database files
      \prod                    --Subtree for 'prod' database files
        redo01.log          --Redo log file group one, member one
        redo02.log          --Redo log file group two, member one
        redo03.log          --Redo log file group three, member one
 
G:\oracle                    --Third logical drive (RAID 10,5, or 6)
    \oradata                 --Subtree for Oracle Database files
      \prod                    --Subtree for 'prod' database files
        control01.ctl       --Control file 1
        indx01.dbf          --Index tablespace datafile
        rbs01.dbf            --Rollback tablespace datafile
        system01.dbf      --System tablespace datafile
        temp01.dbf         --Temporary tablespace datafile
        users01.dbf         --Users tablespace datafile
 
H:\oracle                    --Fourth logical drive
    \oradata                 --Subtree for Oracle Database files
      \prod                    --Subtree for prod database files
        control02.ctl       --Control file 2
 
 
In the above example, prod is the SID of the database.  Therefore, you can support multiple databases on the same devices. You could have prod, prod1, etc.
 
Please note the multiple Oracle Control Files.  These can be very useful when one gets locked and/or corrupted.
 
Also please note the RAID level recommendations are just that - suggestions.  Your mileage may vary depending on the hardware you have available and what you are using the database for. 
 
Perhaps all the Server Admin will give you is one RAID5 drive for all of your Oracle Database files.  Perhaps you want to mirror and stripe everything, or maybe the boss has sprung for a Solid State Disk Array. 
 
The four Windows OFA drives in the example are just an example.  If you have multiple terabytes and multiple devices, it would make sense to spread things out; heavily hit tablespace datafiles and indexes could be placed on separate devices.  The idea is more keeping to the naming conventions than anything.

OFA is Oracle's way of standardizing directory structures so that you know where to find things in a consistent manner.  The mechanics of how you place files and architecture used is completely up to you.

 
   
Windows for the Oracle DBA

The landmark book Windows for the Oracle DBA is a comprehensive overview of everything an Oracle DBA needs to know to manage Oracle on Windows.  Order directly from Rampant and save 30%. 
 

Also, see these related OFA notes:

  1. Oracle Concepts - OFA Guidelines

  2. Oracle 11g changes to OFA structure

  3. Oracle 10g Optimal Flexible Architecture OFA rules

  4. Oracle Optimal Flexible Architecture (OFA)

  5. Oracle installation OFA tablespaces - installing DBA datafiles

  6. Oracle Disk Usage - OFA


 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.