前面介绍了Oracle的基本参数,从这节开始讲其他的参数,参数从v$parameter中提取

基本参数请看如下链接:
[http://www.zhaibibei.cn/oralce/oracle-parameter/](http://www.zhaibibei.cn/oralce/oracle-parameter/)

如无特殊说明数据库版本为11.2

-------

**log_archive_config**



[image:387 size:orig]





1. 参数类型:字符串
2. 默认值: 	'SEND, RECEIVE, NODG_CONFIG'
4. 修改:修改不需要重启数据库
5. 基本参数:否





------



**取值意义**

该参数用来决定是否可以发送REDO LOG到远程数据库或者从远程数据库接受REDO LOG

指定DG数据库的unique name

- 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

指定最多30个DG环境中的db unique name

- NODG_CONFIG

Eliminates the list of service provider names previously specified with the DG_CONFIG option.

--------





**实际截图:**


[image:388 size:orig]


















-----

**参考连接**



[https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams123.htm#REFRN10237](https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams123.htm#REFRN10237)




----------

下期参数

**log_archive_local_first**