A-A+

Data Guard常见故障2则ORA-16191 ORA-1017 ORA-00604 ORA-06544 ORA-06553

2013年04月05日 DG&RAC&OGG, TroubleShooting 暂无评论 阅读 2,531 次

问题(一)
在主备库(rac+single standby)搭建完成后,发现主库一个节点和备库的错误信息如下:
主库问题

ERROR_CODE SEVERITY      MESSAGE                                                                          TIMESTAMP
---------- ------------- -------------------------------------------------------------------------------- --------------------
     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 20:54:28
      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:55:59
     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 20:55:59
      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:57:30
     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 20:57:30
      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:59:01
     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 20:59:01
      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 21:00:31
     16191 Error         PING[ARC1]: Heartbeat failed to connect to standby 'racdb_st'. Error is 16191.   04-APR-13 21:00:31

备库问题

ERROR_CODE SEVERITY      MESSAGE                                                                          TIMESTAMP
---------- ------------- -------------------------------------------------------------------------------- --------------------
      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:48:46
     16191 Error         FAL[client, MRP0]: Error 16191 connecting to racdb_1 for fetching gap sequence   04-APR-13 20:48:46
      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:48:57
     16191 Error         FAL[client, MRP0]: Error 16191 connecting to racdb_1 for fetching gap sequence   04-APR-13 20:48:57
      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:49:09
     16191 Error         FAL[client, MRP0]: Error 16191 connecting to racdb_1 for fetching gap sequence   04-APR-13 20:49:09
      1017 Error         Error 1017 received logging on to the standby                                    04-APR-13 20:49:20
     16191 Error         FAL[client, MRP0]: Error 16191 connecting to racdb_1 for fetching gap sequence   04-APR-13 20:49:20

问题原因:
1、密码文件不一致,需要将密码文件进行复制(11g)
2、db_unique_name设置的问题

问题(二)
主备可以正常同步,但是主备库切换后,新主库问题的alert日志中报错如下:

<msg time='2013-04-05T00:32:42.693+08:00' org_id='oracle' comp_id='rdbms'
 client_id='' type='UNKNOWN' level='16'
 host_id='OELx64' host_addr='192.168.137.146' module=''
 pid='3226'>
 <txt>Errors in file /u01/app/oracle/diag/rdbms/racdb_st/racdb_st/trace/racdb_st_cjq0_3226.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-06544: PL/SQL: internal error, arguments: [56327], [], [], [], [], [], [], []
ORA-06553: PLS-801: internal error [56327]
 </txt>
</msg>

问题原因:
查看MOS:ID 1436552.1后,说是版本位数不一致导致的。
经查,这个rac+single standby的DG确实是在不同的版本位数下实施的。
主库:

[oracle@11grac1 ~]$ getconf LONG_BIT
32

备库:

[root@OELx64 ~]# getconf LONG_BIT
64

给我留言

Copyright © YallonKing 保留所有权利.   Theme  Ality

用户登录

分享到: