|Oracle9i Database Reference
Release 1 (9.0.1)
Part Number A90190-02
Initialization Parameters, 39 of 220
There is no default value.
n sets the default locations for online log and control file creation.
You should specify at least two parameters:
DB_CREATE_ONLINE_LOG_DEST_2. This provides greater fault tolerance for the logs if one of the destinations should fail.
If more than one directory is specified, the control file or online log is multiplexed across the directories. One member of each online log is created on each directory. One control file is also created in each directory.
The directory must already exist; Oracle does not create it. The directory must have appropriate permissions that allow Oracle to create files in it. Oracle generates unique names for the files.