环境:
OS:Centos 7
DB:11.2.0.4
1.删除dgbroker
步骤可以参考
https://www.cnblogs.com/hxlasky/p/15174981.html
这个时候主库可以业务写入数据,自己可以手工写入数据,同时切换日志
2.修改主库添加dataguard相关的参数
alter system set log_archive_config='dg_config=(slnngk,slavea,slaveb)' scope=both; ##填写主备库的db_unique_name
##重新修改归档路径,若不想修改也可以
alter system set log_archive_dest_2= 'service=tnsslavea async valid_for=(online_logfiles,primary_role) db_unique_name=slavea' scope=both; ##这里service填写配置的备库1的tns,db_unique_name填写备库1的db_unique_name.
alter system set log_archive_dest_state_2=enable scope=both; ##启用归档路径2
alter system set log_archive_dest_3= 'service=tnsslaveb async valid_for=(online_logfiles,primary_role) db_unique_name=slaveb' scope=both; ##这里service填写配置的备库2的tns,db_unique_name填写备库2的db_unique_name.
alter system set log_archive_dest_state_3=enable scope=both; ##启用归档路径2
执行到这里的时候发现报错误日志:
ARC0: Archivelog destination LOG_ARCHIVE_DEST_2 disabled: Data Guard configuration identifier mismatch
ARC0: Archivelog destination LOG_ARCHIVE_DEST_3 disabled: Data Guard configuration identifier mismatch
这是因为从库没有配置log_archive_config导致的,这个时候不管它,等执行完下面的步骤后重新执行如下两句:
好像从库配置了log_archive_config也是报这个错误Data Guard configuration identifier mismatch，后来我将主库重启后就可以正常同步了.
alter system set log_archive_dest_state_2=enable scope=both;
alter system set log_archive_dest_state_3=enable scope=both;
然后查看standby的归档状态
set linesize 1000;
column dest_id format 99999999;
column destination format a16;
column dest_id format a16
SQL> select dest_id, destination, status from v$archive_dest where target = 'STANDBY';
DEST_ID DESTINATION STATUS
------- ---------------- ---------
2 tnsslavea VALID
3 tnsslaveb VALID
看到这里是VALID 说明就可以了
3.修改从库的相关参数
从库1:salvea
alter system set log_archive_config='dg_config=(slnngk,slavea,slaveb)' scope=both;
alter system set log_archive_dest_2='service=tnsslnngk async valid_for=(online_logfiles,primary_role) db_unique_name=slnngk' scope=both; ##这里service填写配置的备库1的tns,db_unique_name填写备库1的db_unique_name.
alter system set log_archive_dest_state_2=enable scope=both; ##启用归档路径2
从库1:salveb
alter system set log_archive_config='dg_config=(slnngk,slavea,slaveb)' scope=both;
alter system set log_archive_dest_2='service=tnsslnngk async valid_for=(online_logfiles,primary_role) db_unique_name=slnngk' scope=both; ##这里service填写配置的备库1的tns,db_unique_name填写备库1的db_unique_name.
alter system set log_archive_dest_state_2=enable scope=both; ##启用归档路径2
4.从库应用日志
查看当前的日志应用情况
从库slavea:
SQL> select process,status from v$managed_standby;
PROCESS STATUS
--------- ------------
ARCH CLOSING
ARCH CONNECTED
ARCH CONNECTED
ARCH CLOSING
MRP0 APPLYING_LOG
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
9 rows selected.
从库slaveb:
SQL> select process,status from v$managed_standby;
PROCESS STATUS
--------- ------------
ARCH CLOSING
ARCH CONNECTED
ARCH CONNECTED
ARCH CLOSING
MRP0 APPLYING_LOG
RFS IDLE
RFS IDLE
RFS IDLE
RFS IDLE
9 rows selected.