本文详细介绍了在Azure云环境中，Oracle 11.2.0.4 Data Guard配置完成后，遇到归档日志传输失败问题的解决过程，包括检查tnsping、service_name，以及在master和standby库中排查和修改listener.ora和tnsnames.ora文件，最终成功传输归档日志。
分享一下我老师大神的人工智能教程！零基础，通俗易懂！http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识，造福人民，实现我们中华民族伟大复兴！
1，dataguard搭建好后，归档日志传输不过去
去查看master库上面的日志
tail –f /data/oracle/diag/rdbms/test_m1/powerdes/trace/alert_powerdes.log，显示信息如下：
Sun May 08 00:34:17 2016
Error 1034 received logging on to the standby
PING[ARC2]: Heartbeat failed to connect to standby 'test_m2'. Error is1034.
2，tnsping earch_m2是通的
[oracle@azure_test_dbm1_3_111 admin]$ tnsping test_m3
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 08-MAY-2016 09:13:42
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.3.112)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = test_m2))) OK (0 msec) [oracle@azure_test_dbm1_3_111 admin]$ |
3，去standby备库上，Check检查下service_name，看到service_names确实是test_m2
看起来service_name也没用错，如下所示：
[oracle@azure_test_dbm1_3_112 admin]$ rlwrap sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun May 8 09:15:27 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter name;
NAME &nbs |
扫一扫
1275
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
