文档解释
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;