ORACLE初始化参数：LOG_ARCHIVE_CONFIG

初始化参数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博客 ” ，链接：http://blog.itpub.net/27348/viewspace-760651/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27348/viewspace-760651/