LOG_ARCHIVE_MIN_SUCCEED_DEST
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 you are using the LOG_ARCHIVE_DEST_
n
parameters and automatic archiving is enabled, the value of this parameter cannot exceed either of the following:
- The total number of destinations
- The number of enabled, valid destinations specified as MANDATORY
plus the number of enabled, valid non-standby destinations specified as OPTIONAL
-
If you are using LOG_ARCHIVE_DEST
and LOG_ARCHIVE_DUPLEX_DEST
and automatic archiving is enabled, a value of 1
specifies that the destination specified in LOG_ARCHIVE_DEST
must succeed. A value of 2
specifies that the destinations specified in both parameters must succeed.
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:
-
Set LOG_ARCHIVE_MIN_SUCCEED_DEST
to 1
.
-
Set the value of LOG_ARCHIVE_DEST
and LOG_ARCHIVE_DUPLEX_DEST
to the null string.
-
Set the desired number of destinations for the LOG_ARCHIVE_DEST_
n
parameters.
-
Reset LOG_ARCHIVE_MIN_SUCCEED_DEST
to the desired value.
boson总在http://www.itpub.net/thread-912877-1-1.html上说:
如归档路径参数设置为:
log_archive_dest_1="LOCATION=/archive MANDATORY REOPEN"
log_archive_dest_2="SERVICE=standby_db1 OPTIONAL"
log_archive_dest_3="LOCATION=/archive2 OPTIONAL"
则log_archive_dest_1必须归档成功(MANDATORY),log_archive_dest_2、 log_archive_dest_3中必须有一个归档成功(log_archive_min_succeed_dest=2)后才能覆写联机日志文件。 同样,如果log_archive_dest_n中的MANDATORY关键字个数大于log_archive_min_succeed_dest,则 log_archive_min_succeed_dest的设置不起作用。
[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/161195/viewspace-1058808/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/161195/viewspace-1058808/
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)