RAC+dataguard

[复制链接]
查看11 | 回复2 | 2013-8-26 10:32:46 | 显示全部楼层 |阅读模式
环境:
RAC:
sid:wmdb1 wmdb2
db_unique_name:wmdb wmdb
dataguard
sid:wmdb
db_unique_name:wmdbdg
在创建11GR2rac+dataguard的时候,通过
$ rman target sys/lenovo-cw@wmdb1 auxiliary sys/lenovo-cw@wmdbdg nocatalog
RMAN> duplicate target database for standby nofilenamecheck from active database;
创建了备库,但是wmdb1的归档可以正常传到wmdbdg,而wmdb2的归档不能传送,查看日志。
wmdb2主库alert.log文件
Wed Oct 23 14:09:59 2013
Error 1031 received logging on to the standby
FAL[server, ARC3]: FAL archive failed, see trace file.
ARCH: FAL archive failed. Archiver continuing
ORACLE Instance wmdb2 - Archival Error. Archiver continuing.
Wed Oct 23 14:15:48 2013
Error 1031 received logging on to the standby

主库alert.log
Error 12514 received logging on to the standby
FAL[client, USER]: Error 12514 connecting to wmdb for fetching gap sequence
RFS[6]: Opened log for thread 2 sequence 420 dbid -655694696 branch 829079578

备库arc进程日志
*** TRACE FILE RECREATED AFTER BEING REMOVED ***
Redo shipping client performing standby login
OCISessionBegin failed -1
.. Detailed OCI error val is 1017 and errmsg is 'ORA-01017: invalid username/password; logon denied
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
OCISessionBegin failed. Error -1
.. Detailed OCI error val is 1031 and errmsg is 'ORA-01031: insufficient privileges
'
*** 2013-10-23 14:09:59.848 4320 krsh.c
Error 1031 received logging on to the standby
*** 2013-10-23 14:09:59.848 915 krsu.c
Error 1031 connecting to destination LOG_ARCHIVE_DEST_3 standby host 'wmdbdg'
Error 1031 attaching to destination LOG_ARCHIVE_DEST_3 standby host 'wmdbdg'
*** 2013-10-23 14:09:59.848 2932 krsi.c
krsi_dst_fail: dest:3 err:1031 force:0 blast:1
kcrrwkx: unknown error:1031
*** 2013-10-23 14:20:44.809
Redo shipping client performing standby login
*** 2013-10-23 14:20:44.860 4645 krsu.c
Logged on to standby successfully
Client logon and security negotiation successful!

解决方法,拷贝wmdb2的密码文件到wmdbdg,并修改文件名为orapwwmdb问题解决。
一开始使用orapwd命令给wmdb1 wmdb2 wmdbdg创建密码一致的密码文件,但是问题还是没有解决。

以前在网上看到很多只要密码一致就可以了,但是这个来看,貌似不是这样的。
个人对于dataguard密码文件的,根据经验来看并不是密码一样就可以,拷贝还是最可靠地方法。


回复

使用道具 举报

千问 | 2013-8-26 10:32:46 | 显示全部楼层
你这样复制了节点2的密码文件 ,那节点1是不是就不能正常通信了?
回复

使用道具 举报

千问 | 2013-8-26 10:32:46 | 显示全部楼层
密码文件一般都是直接拷贝,这样比较保险
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行