初始化参数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 進行變更。
取值说明:
- 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/