环境:
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!