Enabling the Creation and Use of Oracle-Managed Files - Oracle 10g

The following initialization parameters allow the database server to use the Oracle-managed files feature:

The file system directory specified by either of these parameters must already exist: the database does not create it. The directory must also have permissions to allow the database to create the files in it.

The default location is used whenever a location is not explicitly specified for the operation creating the file. The database creates the filename, and a file thus created is an Oracle-managed file.

Both of these initialization parameters are dynamic, and can be set using the ALTER SYSTEM or ALTER SESSION statement.

Setting the DB_CREATE_FILE_DEST Initialization Parameter

Include the DB_CREATE_FILE_DEST initialization parameter in your initialization parameter file to identify the default location for the database server to create:

• Datafiles
• Tempfiles
• Redo log files
• Control files
• Block change tracking files

Youspecify the name of a file system directory that becomes the default location for the creation of the operating system files for these entities. The following example sets /u01/oradata as the default directory to use when creating Oracle-managed files:

Setting the DB_RECOVERY_FILE_DEST Parameter

Include the DB_RECOVERY_FILE_DEST and DB_RECOVERY_FILE_DEST_SIZE parameters in your initialization parameter file to identify the default location in which Oracle Database should create:

• Redo log files
• Control files
• RMAN backups (datafile copies, control file copies, backup pieces, control file autobackups)
• Archived logs
• Flashback logs

You specify the name of file system directory that becomes the default location for creation of the operating system files for these entities. For example:

DB_RECOVERY_FILE_DEST = '/u01/oradata' DB_RECOVERY_FILE_DEST_SIZE = 20G

Setting the DB_CREATE_ONLINE_LOG_DEST_n Initialization Parameter

Include the DB_CREATE_ONLINE_LOG_DEST_n initialization parameter in your initialization parameter file to identify the default location for the database server to create:

• Redo log files
• Control files

You specify the name of a file system directory that becomes the default location for the creation of the operating system files for these entities. You can specify up to five multiplexed locations.

For the creation of redo log files and control files only, this parameter overrides any default location specified in the DB _CREATE _FILE _DEST and DB _RECOVERY _Creating Oracle-Managed Files FILE_DEST initialization parameters. If you do not specify a DB _CREATE _FILE _ DEST parameter, but you do specify the DB _CREATE _ONLINE _LOG _DEST_n parameter, then only redo log files and control files can be created as Oracle-managed files.

It is recommended that you specify at least two parameters. For example: DB _CREATE _ONLINE _LOG _DEST _1 = '/u02/oradata'

This allows multiplexing, which provides greater fault-tolerance for the redo log and control file if one of the destinations fails.