Oracle 11g Active DataGuard初探(2)

备库中的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 Data Guard 的角色转换

Oracle Data Guard的日志FAL gap问题

Oracle 11g Data Guard Error 16143 Heartbeat failed to connect to standby 处理方法

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/f7c5b81abea681b8ddfb9c0550e50792.html