初始化参数LOG_ARCHIVE_CONFIG用于控制发送归档日志到远程位置、接收远程归档日志，并指定Data Guard配置的惟一数据库名，默认值为SEND，RECEIVE，NODG_CONFIG。

当设置该参数为SEND时，会激活发送归档日志到远程位置；当设置该能数为NOSEND时，会禁止发送归档日志到远程位置；当设置该参数为RECEIVE时，会激活接收远程归档日志；当设置该参数为NORECEIVE时，会禁止接收远程归档日志；当设置该参数为DG_CONFIG时，可以最多指定9个惟一数据库名；当设置该参数为NODG_CONFIG时，会禁止指定惟一数据库名。

该初始化参数是动态参数，可以使用ALTER SYSTEM命令进行修改。示例如下：

SQL>ALTER SYSTEM SET log_archive_config='SEND';

附甲骨文官方说明：

LOG_ARCHIVE_CONFIG =

{
[ SEND | NOSEND ]
[ RECEIVE | NORECEIVE ]
[ DG_CONFIG=(remote_db_unique_name1 [, ... remote_db_unique_name9) | NODG_CONFIG ]
}

可通過alter system set 進行變更。

LOG_ARCHIVE_CONFIG enables or disables the sending of redo logs to remote destinations and the receipt of remote redo logs, and specifies the unique database names (DB_UNIQUE_NAME) for each database in the Data Guard configuration.

取值说明:

SEND Enables the sending of redo logs to remote destinations
NOSEND Disables the sending of redo logs to remote destinations
RECEIVE Enables the receipt of remotely archived redo logs
NORECEIVE Disables the receipt of remotely archived redo logs
DG_CONFIG Specifies a list of up to 9 unique database names (defined with the DB_UNIQUE_NAME initialization parameter) for all of the databases in the Data Guard configuration.
NODG_CONFIG Eliminates the list of service provider names previously specified with the DG_CONFIG option

ITPub博客

ORACLE初始化参数：LOG_ARCHIVE_CONFIG

最新文章