ITPub博客
首页 博客 专栏 学院 社区 IT新媒体评选
发博

首页 > 数据库 > Oracle > Real-Time apply异常，求解

Real-Time apply异常，求解

原创 Oracle 作者：shiable 时间：2016-10-25 11:51:29 0 删除 编辑

点击(此处)折叠或打开

  1. 备库在启动实时恢复后，进行测试，结果是仍然是redo apply
  2. --standby database
  3. alter database recover managed standby database using current logfile disconnect from session;
  4. SQL> select open_mode,database_role,db_unique_name from v$database;
  5. OPEN_MODE            DATABASE_ROLE    DB_UNIQUE_NAME
    -------------------- ---------------- ------------------------------
    READ ONLY WITH APPLY PHYSICAL STANDBY phydb

  6. MRP0: Background Managed Standby Recovery process started (phydb)
    Serial Media Recovery started
    Managed Standby Recovery starting Real Time Apply
    Waiting for all non-current ORLs to be archived...
    All non-current ORLs have been archived.
    Media Recovery Log +FLASHDG/phydb/archivelog/arch_925752176_1_150.arc
    Media Recovery Log +FLASHDG/phydb/archivelog/arch_925752176_1_151.arc
    Media Recovery Log +FLASHDG/phydb/archivelog/arch_925752176_1_152.arc
    Media Recovery Waiting for thread 1 sequence 153 (in transit)
    Completed: alter database recover managed standby database using current logfile disconnect from session
  7. 备库正常开启日志实时恢复，接下来，主库删除部分数据 ，进行验证

点击(此处)折叠或打开

  1. --primary database 做删除数据的动作
  2. SQL> delete from xjmon.b where rownum <=1;

  4. 1 row deleted.

  6. SQL> commit;

  8. Commit complete.

  10. SQL> select count(*) from xjmon.b;

  12.   COUNT(*)
  13. ----------
  14.         41

  16. SQL> archive log list;
  17. Database log mode Archive Mode
  18. Automatic archival Enabled
  19. Archive destination +FLASH/racdb/archivelog/
  20. Oldest online log sequence 157
  21. Next log sequence to archive 158
  22. Current log sequence 158
  23. SQL>

点击(此处)折叠或打开

  1. --standby database 检查，表数据未与主库保持一致
  2. SQL> archive log list;
  3. Database log mode Archive Mode
  4. Automatic archival Enabled
  5. Archive destination +FLASHDG/phydb/archivelog/
  6. Oldest online log sequence 157
  7. Next log sequence to archive 0
  8. Current log sequence 158
  9. SQL> select count(*) from xjmon.b;

  11.   COUNT(*)
  12. ----------
  13.         42
  14. SQL> archive log list;
  15. Database log mode Archive Mode
  16. Automatic archival Enabled
  17. Archive destination +FLASHDG/phydb/archivelog/
  18. Oldest online log sequence 158
  19. Next log sequence to archive 0
  20. Current log sequence 159

  22. ---在primary database上进行切换日志文件操作后，standby database查询才进行了同步
  23. alter system switch lofile

  25. SQL> select count(*) from xjmon.b;

  27.   COUNT(*)
  28. ----------
  29.         41
我的环境是11.2.0.3 RAC+ 单实例DG，以上操作是在主库节点1和备库上操作，出现实时恢复异常的情况。

但同样的操作，在节点2上执行，实时恢复正常，备库上的数据随着主库节点2的commit后，保持与主库一致。

点击(此处)折叠或打开

  1. 节点1环境如下
  2. SQL> show parameter log_archive_dest

  4. NAME TYPE VALUE
  5. ------------------------------------ ----------- ------------------------------
  6. log_archive_dest string
  7. log_archive_dest_1 string LOCATION=+FLASH/RACDB/ARCHIVELOG/ valid_for=(all_logfiles,al
  8.                                                  l_roles) db_unique_name=racdb

  10. log_archive_dest_2 string SERVICE=phydb lgwr async valid_for=(online_logfiles,primary_
  11.                                                  role) db_unique_name=phydb
  12. log_archive_dest_20 string


点击(此处)折叠或打开

  1. --备库环境如下
  2. SQL> show parameter log_archive_dest_1

  4. NAME TYPE VALUE
  5. ------------------------------------ ----------- ------------------------------
  6. log_archive_dest_1 string LOCATION=+FLASHDG/phydb/ARCHIV
  7.                                                  ELOG/ valid_for=(all_logfiles,
  8.                                                  all_roles) db_unique_name=phyd
  9.                                                  b
  10. SQL> show parameter log_archive_dest_2

  12. NAME TYPE VALUE
  13. ------------------------------------ ----------- ------------------------------
  14. log_archive_dest_2 string SERVICE=racdb lgwr async valid
  15.                                                  _for=(online_logfiles,primary_
  16.                                                  role) db_unique_name=racdb
  17. ---备库是real-time apply
  18. SQL> select open_mode,database_role,db_unique_name from v$database;


    OPEN_MODE            DATABASE_ROLE    DB_UNIQUE_NAME
    -------------------- ---------------- ------------------------------
    READ ONLY WITH APPLY PHYSICAL STANDBY phydb







来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/28551528/viewspace-2127056/ ，如需转载，请注明出处，否则将追究法律责任。

0
0
上一篇： 查看表中某列的low_value和high_value
下一篇： Oracle11g DataGuard Broker配置
请登录后发表评论 登录
全部评论
shiable

注册时间：2014-04-16

  • 博文量
    15
  • 访问量
    19035

最新文章

支持我们 作者招募 用户协议 FAQ Contact Us

北京盛拓优讯信息技术有限公司. 版权所有  京ICP备16024965号-8 北京市公安局海淀分局网监中心备案编号：11010802021510 niuxiaotong@pcpop.com 17352615567 未成年人举报专区

广播电视节目制作经营许可证(京) 字第1234号 中国互联网协会会员

违法和不良信息举报电话:18101376593