Boolean 

Static 

FALSE 

TRUE | FALSE 

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 SQL*Plus 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.