Name

DB_CREATE_ONLINE_LOG_DEST_n

Synopsis

Value: string containing directory name

Dynamic: ALTER SYSTEM, ALTER SESSION

Specifies the default location where online log files and control files will be created. To provide fault tolerance, you should specify this parameter at least twice. The directory specified must already exist and must have sufficient permissions to allow Oracle to create files in it. New with Oracle9i.

Syntax

DB_CREATE_ONLINE_LOG_DEST_n = directory

Keywords

n

Integer between 1 and 5 specifying the multiplexed file instance

directory

Specifies the name of a directory that will contain one member of each online redo log group and one control file

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.