DB_CREATE_ONLINE_LOG_DEST_n

Property	Description
Parameter type	String
Syntax	DB_CREATE_ONLINE_LOG_DEST_[1 | 2 | 3 | 4 | 5] = directory | disk group
Default value	There is no default value.
Modifiable	ALTER SESSION, ALTER SYSTEM
Basic	Yes

DB_CREATE_ONLINE_LOG_DEST_n (where n = 1, 2, 3, ... 5) specifies the default location for Oracle-managed control files and online redo logs. If more than one DB_CREATE_ONLINE_LOG_DEST_n parameter is specified, then the control file or online redo log is multiplexed across the locations of the other DB_CREATE_ONLINE_LOG_DEST_n parameters. One member of each online redo log is created in each location, and one control file is created in each location.

Specifying at least two parameters provides greater fault tolerance for the control files and online redo logs if one of the locations should fail.

If a file system directory is specified as the default location, then 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, and a file thus created is an Oracle-managed file.

Note:

1. This parameter was introduced in Oracle9i.

2. Query for the current value of the parameter

select name, value, isdefault, isses_modifiable, issys_modifiable,

isinstance_modifiable, isdeprecated, description

from v$parameter

where upper(name) like ('DB_CREATE_ONLINE_LOG_DEST_%');

NAME	VALUE	IS DEFAULT	ISSES_ MODIFIABLE	ISSYS_ MODIFIABLE	ISINSTANCE_ MODIFIABLE	IS DEPRECATED	DESCRIPTION
db_create_online_log_dest_1		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	online log/controlfile destination #1
db_create_online_log_dest_2		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	online log/controlfile destination #2
db_create_online_log_dest_3		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	online log/controlfile destination #3
db_create_online_log_dest_4		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	online log/controlfile destination #4
db_create_online_log_dest_5		TRUE	TRUE	IMMEDIATE	TRUE	FALSE	online log/controlfile destination #5

Oracle initializatoin parameters