题目:
290.What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? (Choose all that apply.)
A. ORACLE_BASE should be set explicitly.
B. An Oracle base should have only one Oracle home created in it.
C. Flash recovery area and data file location should be on separate disks.
D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.
参考答案 ACD
解析
为了使Oracle Database 11g安装成为最佳的灵活架构,有哪些建议。
参考文档:
https://docs.oracle.com/cd/E11882_01/install.112/e47689/appendix_ofa.htm#LADBI1374
D Optimal Flexible Architecture
This appendix describes the Optimal Flexible Architecture (OFA) standard. This standard is a set of configuration guidelines created to ensure well organized Oracle installations that are easier to maintain. It includes information about the following topics:
D.1 Overview of the Optimal Flexible Architecture Standard
The Optimal Flexible Architecture standard helps you to organize database software and configure databases to allow multiple databases, of different versions, owned by different users to coexist. Optimal Flexible Architecture assists in identification of ORACLE_BASE
with its Automatic Diagnostic Repository (ADR) diagnostic data to properly collect incidents.
All Oracle components on the installation media are compliant with Optimal Flexible Architecture. Oracle Universal Installer places Oracle Database components in directory locations, assigning the default permissions that follow Optimal Flexible Architecture guidelines.
Oracle recommends that you use Optimal Flexible Architecture, especially if the database is huge, or if you plan to have multiple databases.
D.1.1 Advantages of Multiple Oracle Homes and OFA
When you install Oracle database, you are installing a large application that your computer can support. Using multiple Oracle homes and Optimal Flexible Architecture provides many advantages when administering large databases. The following advantages are important:
-
Structured organization of directories and files, and consistent naming for database files simplify database administration.
-
Distribution of I/O across multiple disks prevents performance bottlenecks caused by multiple read or write commands issued simultaneously to a single drive.
-
Distribution of applications across multiple disks safeguards against database failures.
-
Login home directories are not at risk when database administrators add, move, or delete Oracle home directories.
-
Multiple databases, of different versions, owned by different users can coexist concurrently.
-
Software upgrades can be tested in an Oracle home in a separate directory from the Oracle home where your production database is located.
END