Oracle参数解析(log_archive_config)

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

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

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

log_archive_config

1.png

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

取值意义

该参数用来决定是否可以发送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.

实际截图：

2.png

参考连接

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

下期参数

log_archive_local_first