ORA-16571: Data Guard configuration file creation failure ORACLE 报错 故障修复 远程处理

文档解释

ORA-16571: Data Guard configuration file creation failure

Cause: The Data Guard broker was unable to create the configuration file on permanent storage.

Action: Verify space, permissions and file name as indicated by the DG_BROKER_CONFIG_FILE[1|2] initialization parameters and retry the operation.

ORA-16571 Data Guard configuration file creation failure

官方解释

ORA-16571 Data Guard 典型该参数的值应为「Yes」，但检测到数据库的该参数的值已被修改。

当创建Data Guard配置文件时，DB_ROLE_CHANGE参数必须设置为YES，但是实际检测到该参数的值为NO，导致Data Guard配置文件无法创建。

常见案例

用户可能在将Data Guard部署之前不小心将DB_ROLE_CHANGE参数值从YES修改为NO。

一般处理方法及步骤

1、将DB_ROLE_CHANGE参数值临时设置为Yes，

alter system set db_role_change=yes scope=spfile;

2、重新启动数据库，

shutdown immediate;startup;

3、创建Data Guard配置文件，

create configuration;

4、将DB_ROLE_CHANGE参数返回其原有值，

alter system set db_role_change=no scope=spfile;

5、重新启动数据库，

shutdown immediate;startup;