- Installation Guide
- Configuring Storage for Oracle Grid Infrastructure for a Standalone Server
- Creating Directories for Oracle Database Files
9.5 Creating Directories for Oracle Database Files
Perform this procedure to place the Oracle Database or recovery files on a separate file system from the Oracle base directory.
- Use the following command to determine the free disk space on each mounted file system:
# df -h - Identify the file systems to use, from the display:
Option Description Database Files
Select one of the following:
-
A single file system with at least 1.5 GB of free disk space
-
Two or more file systems with at least 3.5 GB of free disk space in total
Recovery Files
Choose a file system with at least 2 GB of free disk space
If you are using the same file system for multiple file types, then add the disk space requirements for each type to determine the total disk space requirement.
-
- Note the names of the mount point directories for the file systems that you identified.
- If the user performing installation has permissions to create directories on the disks where you plan to install Oracle Database, then DBCA creates the Oracle Database file directory, and the Recovery file directory. If the user performing installation does not have write access, then you must create these directories manually.
For example, given the user
oracleand Oracle Inventory Groupoinstall, and using the paths/u03/oradata/wrk_areafor Oracle Database files, and/u01/oradata/rcv_areafor the recovery area, these commands create the recommended subdirectories in each of the mount point directories and set the appropriate owner, group, and permissions on them:-
Database file directory:
# mkdir /u01/oradata/ # chown oracle:oinstall /u01/oradata/ # chmod 775 /mount_point/oradataThe default location for the database file directory is
$ORACLE_BASE/oradata. -
Recovery file directory (fast recovery area):
# mkdir /u01/oradata/rcv_area # chown oracle:oinstall /u01/app/oracle/fast_recovery_area # chmod 775 /u01/oradata/rcv_areaThe default fast recovery area is
$ORACLE_BASE/fast_recovery_area.Oracle recommends that you keep the fast recovery area on a separate physical disk than that of the database file directory. This method enables you to use the fast recovery area to retrieve data if the disk containing oradata is unusable for any reason.
-