Oracle DataGuard FAL[client, ARC2]: Error 16191 connecting to 问题处理过程记录

1. 问题描述

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

Error 1017 received logging on to the standby------------------------------------------------------------Check that the primary and standby are using a password fileand 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 sequenceSQL> select * from v$archive_gap; --日志存在gap   THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#---------- ------------- --------------     1          38         40

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

[oracle@sourcedb oracle]$ cd $ORACLE_HOME/dbs[oracle@sourcedb dbs]$ ls -ltrtotal 9568-rw-r--r--. 1 oracle oinstall    2851 May 15  2009 init.ora-rw-r-----. 1 oracle oinstall      24 Aug 13  2018 lkHSQL-rw-r-----  1 oracle oinstall      24 Jun 21  2019 lkEPMBAK-rw-r-----  1 oracle oinstall    3584 Jun 21  2019 spfileepmbak.ora-rw-rw----  1 oracle oinstall    1544 Jun 21  2019 hc_epmbak.dat-rw-rw----. 1 oracle oinstall    1544 Jun 21  2019 hc_hsql.dat-rw-r-----  1 oracle oinstall    1536 Jan 26 21:22 bak_orapwepmsn-rw-r--r--  1 oracle oinstall      50 Feb 15 00:18 initepmbak.ora-rw-r-----  1 oracle oinstall      24 Feb 15 02:34 lkEPMSN-rw-rw----  1 oracle oinstall    1544 Feb 15 02:36 hc_epmsn.dat-rw-r-----  1 oracle oinstall 9748480 Feb 15 21:24 snapcf_epmsn.f-rw-r-----  1 oracle oinstall    3584 Mar 22 06:00 spfileepmsn.ora-rw-r-----  1 oracle oinstall    1536 Mar 22 06:38 orapwepmsn[oracle@sourcedb dbs]$ mv orapwepmsn bak_orapwepmsn   ---备份源密码文件[oracle@sourcedb dbs]$ orapwd file=orapwepmsn password=Star_1234  ignorecase=y   ---重新生成密码文件[oracle@sourcedb dbs]$ scp orapwepmsn oracle@hsql:$ORACLE_HOME/dbs/              --传输密码文件到dg目标端orapwepmsn                                             100% 1536     1.5KB/s   00:00    [oracle@sourcedb dbs]$SQL> select * from v$archive_gap; --日志传输恢复正常，gap消除no rows selectedSQL>

4. 重新开启adg

**********oracle active data guardalter database recover managed standby database cancel;alter database open;alter database recover managed standby database using current logfile disconnect;