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 |
|
Default value |
There is no default value. |
Modifiable |
|
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