备库中的alert日志显示如下:
### standby log
Mon Jun 01 22:59:57 2015
RFS[2]: Selected log 8 for thread 1 sequence 79 dbid 1028247664 branch 880742847
Mon Jun 01 22:59:57 2015
Archived Log entry 111 added for thread 1 sequence 79 ID 0x3d942dcb dest 1:
Archived Log entry 112 added for thread 1 sequence 79 ID 0x3d942dcb dest 3:
Mon Jun 01 22:59:57 2015
Media Recovery Log /u02/dg11g/switchover/DG11G/archivelog/1_79_880742847.dbf
Media Recovery Waiting for thread 1 sequence 80
这个时候再次在备库查看,就发现数据变更都同步过来了。
n1@TEST11G> select count(*) from aaa;
COUNT(*)
----------
19
1 row selected.
n1@TEST11G> show user
USER is "N1"
相关参考:
Oracle Data Guard 重要配置参数
基于同一主机配置 Oracle 11g Data Guard
探索Oracle之11g DataGuard
Oracle Data Guard (RAC+DG) 归档删除策略及脚本
Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 处理方法