Oracle 参数 LOG_ARCHIVE_MIN_SUCCEED_DEST 官方解释,作用,如何配置最优化建议

本站中文解释

LOG_ARCHIVE_MIN_SUCCEED_DEST是用来保证归档日志存储介质的可用性,也就是用来确认归档文件被正确备份到特定的介质(可以是本地盘、远程磁带库、网络服务器、其它数据库等)后,才被释放。该参数只有当多个归档归档目录、网络服务器、磁带库作为归档介质的情况下才需要设置。

设置LOG_ARCHIVE_MIN_SUCCEED_DEST的步骤如下:
1. 确定归档介质:确定归档文件要存储的介质,可以是本地盘、远程磁带库、网络服务器或其他数据库;
2. 检查归档配置:在归档文件存储的所有介质上按照实际需要检查并创建所有必须的目录、网络或数据库对象;
3. 设置LOG_ARCHIVE_MIN_SUCCEED_DEST参数:为了保证归档文件被正确备份,需要将LOG_ARCHIVE_MIN_SUCCEED_DEST参数设置为所有归档介质的数量;
4. 设置应用程序:将程序设置为在所有介质上Monitor Archive Log和Log File Status,及时完成备份;
5. 测试归档:在归档介质上测试归档过程,确认归档文件都被备份;
6. 完成设置:用shutdown/startup命令重新启动数据库,以验证所有设置。

官方英文解释

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.

Property Description

Parameter type

Integer

Default value

1

Modifiable

ALTER SESSION, ALTER SYSTEM

Modifiable in a PDB

Yes

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

If you are using the LOG_ARCHIVE_DEST_n parameters and automatic archiving is enabled, then the value of this parameter cannot exceed the number of enabled, valid destinations specified as MANDATORY plus the number of enabled, valid destinations that are configured with the OPTIONAL and LOCATION attributes.

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, then some of the enabled, valid destinations configured with the OPTIONAL and LOCATION attributes 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:

  • Oracle Database
    Administrator’s Guide
    for more information on setting this parameter

  • “LOG_ARCHIVE_DEST_n”, “LOG_ARCHIVE_DUPLEX_DEST”, and “V$ARCHIVE_DEST” for information on related parameters


数据运维技术 » Oracle 参数 LOG_ARCHIVE_MIN_SUCCEED_DEST 官方解释,作用,如何配置最优化建议