|
|
This is only a preview of the paper
Click here to register and get the full text.
Existing members click here to login
|
|
|
Database Layout Best Practices
Oracle Corporation recommends that you implement the OFA standard when you install and configure Oracle9i. Its a set of rules which helps to keep database/application maintenance operations at the minimal level plus prevent possible performance bottlenecks in the future. ...
• Adequately manage and administer database growth. ...
GUIDELINES
The first step in defining an OFA implementation is defining how the database will interface with the Operating System. ... It is important to define a consistent set of standards that can be followed by systems administrators, when laying out and setting up the system, and by database administrators when configuring and setting up new databases. ...
Current Status:
The server currently has the following mount points:
/u01: ORACLE_BASE : /u01
ORACLE_HOME : /u01/OraHome2
RMAN BACKUP FILES : /u01/backup
ARCHIVE DESTINATION : /u01/OraHome2/oradata/grover2/archive
/u02: ORACLE FILES : /u02/oradata/grover2
/u03: RMAN BACKUP FILES : /u03/backup
EXPORT BACKUP FILES : /u03/exports
INDEX FILES : /u03/oradata/grover2
/u05: RMAN BACKUP FILES : /u05/backup
EXPORT BACKUP FILES : /u05/exports
Recommendations:
• Since the Oracle software files as well as database files are not optimally laid out across the mount points, it is recommended to keep all oracle software files and executables on /u01 partition or create an /opt partition with at least 5GB of free space for fresh installation of oracle software as well as future upgrades and patches.
• Create ORADATA on /u02 and /u03 for database files
• Create ORAINDEX on /u04 for index files
• Create ORAARC on /u05 for archive log files
Oracle Files
The OFA standard classifies files associated with Oracle into one of two categories: software and administrative data; and database files. ... It also allows the DBA to deploy separate database instances, running on separate version of Oracle software, that are independent of one another. ... This is not to indicate that these files are not necessary for the operation of the database. However, the distinguishing point between these types of files and database files is that none of the files discussed in this section actually contain any of the data that is stored in the database. ...
• Administrative information about one database must be separated from that of others; there must be a reasonable structure for organization and storage of administrative data.
Current Status:
• There is no ORACLE_BASE
• There is no ORACLE_BASE/admin to store different database instances
• There is no ORACLE_BASE/admin/SID to store instance specific files such as:
o Trace files
o Alert Log Files
o Init.
Approximate Word count = 1892
Approximate Pages = 7.6
(250 words per page double spaced)
|
|
|
|
|
|