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

本站中文解释

LOG_ARCHIVE_DUPLEX_DEST参数是控制日志的复制的参数,它的作用是在备份一次日志后,将日志复制备份到另外一个位置,以防别的位置损坏或发生其他意外。

设置方式:

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DUPLEX_DEST = ‘location1′,’location2’;

其中的location1和location2表示备份的位置,也可以使用更多的位置,比如location3、location4等,它们中的任一个都可以作为备份的位置。

官方英文解释

LOG_ARCHIVE_DUPLEX_DEST is similar to the initialization parameter LOG_ARCHIVE_DEST. This parameter specifies a second archive destination: the duplex archive destination. This duplex archive destination can be either a must-succeed or a best-effort archive destination, depending on how many archive destinations must succeed (as specified in the LOG_ARCHIVE_MIN_SUCCEED_DEST parameter).
Property Description

Parameter type

String

Syntax

LOG_ARCHIVE_DUPLEX_DEST = filespec

Default value

There is no default value.

Modifiable

ALTER SYSTEM

Modifiable in a PDB

No

Range of values

Either a null string or any valid path or device name, except raw partitions

Basic

No

Note:

If you are using Oracle Enterprise Edition, this parameter is deprecated in favor of the LOG_ARCHIVE_DEST_n parameters. If Oracle Enterprise Edition is not installed or it is installed but you have not specified any LOG_ARCHIVE_DEST_n parameters, this parameter is valid.

The default setting of a null string (“”) or (‘ ‘) indicates that a duplex archive destination does not exist.

See Also:

  • “LOG_ARCHIVE_DEST_n”

  • “LOG_ARCHIVE_MIN_SUCCEED_DEST”

  • “V$ARCHIVE_DEST”

  • Oracle Database
    Administrator’s Guide
    for an example of using this parameter to specify an optional secondary archive destination


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