前面介绍了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