DB_CREATE_ONLINE_LOG_DEST_n

Parameter type	String
Syntax	DB_CREATE_ONLINE_LOG_DEST_n = directory (n>=1, n<=5)
Default value	There is no default value.
Parameter class	Dynamic: ALTER SESSION, ALTER SYSTEM

DB_CREATE_ONLINE_LOG_DEST_n sets the default locations for online log and control file creation.

You should specify at least two parameters: DB_CREATE_ONLINE_LOG_DEST_1 and 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.