Name

LOG_ARCHIVE_MIN_SUCCEED_DEST

Synopsis

Value: 1-10

Default: 1

Dynamic: ALTER SYSTEM, ALTER SESSION

Specifies the minimum number of archive log destinations that must succeed. When automatic archiving is enabled and LOG_ARCHIVE_DEST is used, the allowable values are 1 and 2. If this parameter is 1, LOG_ARCHIVE_DEST is a must-succeed destination, and LOG_ARCHIVE_DUPLEX_DEST is a best-effort destination. If this parameter is 2, both LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST are must-succeed destinations.

If LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST is used, then you may not dynamically modify this parameter.

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.