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 |
|
Modifiable |
|
Modifiable in a PDB |
Yes |
Range of values |
1 to 10 if you are using 1 or 2 if you are using |
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:
-
Set
LOG_ARCHIVE_MIN_SUCCEED_DEST
to1
. -
Set the value of
LOG_ARCHIVE_DEST
andLOG_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.
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