Oracle Tips by Burleson

Oracle10g Grid Computing with RAC
Chapter 8 - RAC Administration

Oracle Managed Files

DB_CREATE_ONLINE_LOG_DEST_1 = '/u03/oracle/redo/applic'
DB_CREATE_ONLINE_LOG_DEST_2 = '/u04/oracle/redo/applic'

Also, you will able to change the DB_CREATE location with the ALTER SYSTEM command.

For example, the following commands change the OMF directory location to '/u05/oracle/data/applic', and creates a new tablespace.

ALTER SYSTEM SET
DB_CREATE_FILE_DEST = '/u05/oracle/data/applic' ;

CREATE TABLESPACE tbs_1; # creates def.size of 100MB
CREATE TABLESPACE tbs_3
DATAFILE AUTOEXTEND ON MAXSIZE 800M;

For more details, refer to the chapter on ‘Using Oracle Managed Files’ in the Oracle 10g Database Administrator’s Guide.

With RAC systems, the OMF facility can only be used if the cluster system is using the cluster file system. The availability of the cluster file system with a set of mounted file systems, allows you to set up a directory for OMF files. The DBCA also supports Oracle Managed Files for operating systems that support a cluster file system.