Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-04
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

LOG_ARCHIVE_MIN_SUCCEED_DEST

Property Description
Parameter type Integer
Default value 1
Modifiable ALTER SESSION, ALTER SYSTEM
Range of values 1 to 10 if you are using LOG_ARCHIVE_DEST_n

1 or 2 if you are using LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST

Basic No

LOG_ARCHIVE_MIN_SUCCEED_DEST defines the minimum number of destinations that must succeed in order for the online logfile to be available for reuse.

If the value of this parameter is less than the number of enabled, valid MANDATORY destinations, this parameter is ignored in favor of the MANDATORY destination count. If the value is more than the number of enabled, valid MANDATORY destinations, some of the enabled, valid OPTIONAL non-standby destinations are treated as MANDATORY.

You can switch dynamically from using the older parameters to the LOG_ARCHIVE_DEST_n parameter using ALTER SYSTEM, as follows:

  1. Set LOG_ARCHIVE_MIN_SUCCEED_DEST to 1.

  2. Set the value of LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST to the null string.

  3. Set the desired number of destinations for the LOG_ARCHIVE_DEST_n parameters.

  4. Reset LOG_ARCHIVE_MIN_SUCCEED_DEST to the desired value.

    See Also: