在搭建完DG后,才能配置Broker。 本例中主备都是单实例,如果是RAC,需要确认Broker配置文件(参数dg_broker_config_file1和2)在共享存储上
主备两端都启用Broker
ALTER SYSTEM SET DG_BROKER_START=TRUE scope=both;
2. 主库连接dgmgrl,在主库创建主库配置
create configuration 'o19' as primary database is 'o19' connect identifier is o19;
3. 依然是在主库dgmgrl中,添加备库配置
Add database 'o19dg' as connect identifier is o19dg maintained as physical;
4. 启用配置
ENABLE CONFIGURATION;
5. 观察结果
show configuration; show database verbose <库名>;
