LOG_ARCHIVE_START

Parameter type	Boolean
Default value	false
Parameter class	Static
Range of values	true | false
Real Application Clusters	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.

Values:

• true

  Indicates that archiving is automatic

• false

  Indicates that the database administrator will archive filled redo log files manually

The SQL*Plus statements ARCHIVE LOG START or ARCHIVE LOG STOP override 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: Oracle9i Database Administrator's Guide and Oracle9i Real Application Clusters Administration