Oracle® Database Administrator's Guide 11g Release 2 (11.2) Part Number E10595-04 |
|
|
View PDF |
The following table lists the initialization parameters that enable the use of Oracle-managed files.
The file system directories specified by these parameters must already exist; the database does not create them. 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.
See Also:
Oracle Database Reference for additional information about initialization parameters
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
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. The following example sets /u01/app/oracle/oradata
as the default directory to use when creating Oracle-managed files:
DB_CREATE_FILE_DEST = '/u01/app/oracle/oradata'
Include the DB_RECOVERY_FILE_DEST
and DB_RECOVERY_FILE_DEST_SIZE
parameters in your initialization parameter file to identify the default location for the Fast Recovery Area. The Fast Recovery Area contains:
Redo log files or multiplexed copies of redo log files
Control files or multiplexed copies of 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 = '/u0 1/app/oracle/flash_recovery_area' DB_RECOVERY_FILE_DEST_SIZE = 20G
Include the DB_CREATE_ONLINE_LOG_DEST_
n
initialization parameters in your initialization parameter file to identify the default locations for the database server to create:
Redo log files
Control files
You specify the name of a file system directory or Oracle ASM disk group that becomes the default location for the creation of the 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_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' DB_CREATE_ONLINE_LOG_DEST_2 = '/u03/oradata'
This allows multiplexing, which provides greater fault-tolerance for the redo log and control file if one of the destinations fails.