Initialization Parameters, 86 of 188

LOG_ARCHIVE_START

Parameter type:	Boolean
Parameter class:	Static
Default value:	`FALSE`
Range of values:	`TRUE \| FALSE`
Oracle Parallel Server:	Multiple instances can have different values.
`LOG_ARCHIVE_START` is applicable only when you use the redo log in `ARCHIVELOG` mode. It indicates whether archiving should be automatic or manual when the instance starts up. `TRUE` indicates that archiving is automatic. `FALSE` indicates that the database administrator will archive filled redo log files manually. The SQLPlus command `ARCHIVE` `LOG` `START` or `STOP` overrides this parameter. In `ARCHIVELOG` mode, if all online redo log files fill without being archived, Oracle issues an error and suspends instance operations until the necessary archiving is performed. This delay is more likely if you use manual archiving. You can reduce its likelihood by increasing the number of online redo log files. To use `ARCHIVELOG` mode while creating a database, set this parameter to `TRUE`. Normally, a database is created in `NOARCHIVELOG` mode and then altered to `ARCHIVELOG` mode after creation. See Also:* Oracle8i Administrator's Guide and Oracle8i Parallel Server Administration, Deployment, and Performance.