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 SQL*Plus command
STOP overrides this parameter.
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.
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.