Error 1017 received logging on to the standby

1. 问题描述

Oracle DataGuard日志传输失败，日志信息如下所示，

Error 1017 received logging on to the standby
------------------------------------------------------------
Check that the primary and standby are using a password file
and remote_login_passwordfile is set to SHARED or EXCLUSIVE,
and that the SYS password is same in the password files.
returning error ORA-16191
------------------------------------------------------------
FAL[client, ARC2]: Error 16191 connecting to epmsn for fetching gap sequence
SQL> select * from v$archive_gap; --日志存在gap

2. 问题分析

日志中显示的非常清晰，该问题主要由以下原因造成，

检查数据库参数remote_login_passwordfile，值为SHARED or EXCLUSIVE(默认);
SYS密码是否与password file一致，即是否最近改过sys密码,没有同步password file;
dg 源和目标端password file是否同步;
11g默认密码大小写敏感，生成密码文件时是否添加参数ignorecase。
目标端password file格式： orapw+sid。
3. 恢复过程
3.1 修改源端sys密码
SQL> alter user sys identified by Star_1234;

User altered.

SQL>

3.2 生成源端password file
mv orapwepmsn bak_orapwepmsn ---备份源密码文件

orapwd file=orapwepmsn password=Star_1234 ignorecase=y ---重新生成密码文件

scp orapwepmsn oracle@hsql:$ORACLE_HOME/dbs/ --传输密码文件到dg目标端
4. 重新开启adg
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect;