Real-Time apply异常，求解

点击(此处)折叠或打开

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;
   
3. 
   
4. 1 row deleted.
   
5. 
   
6. SQL> commit;
   
7. 
   
8. Commit complete.
   
9. 
   
10. SQL> select count(*) from xjmon.b;
    
11. 
    
12.   COUNT(*)
    
13. ----------
    
14.         41
    
15. 
    
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;
   
10. 
    
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
    
21. 
    
22. ---在primary database上进行切换日志文件操作后，standby database查询才进行了同步
    
23. alter system switch lofile
    
24. 
    
25. SQL> select count(*) from xjmon.b;
    
26. 
    
27.   COUNT(*)
    
28. ----------
    
29.         41

我的环境是11.2.0.3 RAC+ 单实例DG，以上操作是在主库节点1和备库上操作，出现实时恢复异常的情况。

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

点击(此处)折叠或打开

1. 节点1环境如下
   
2. SQL> show parameter log_archive_dest
   
3. 
   
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
   
9. 
   
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
   
3. 
   
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
    
11. 
    
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博客 ” ，链接：http://blog.itpub.net/28551528/viewspace-2127056/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28551528/viewspace-2127056/