## 1. 問題描述

Oracle DataGuard日誌傳輸失敗，日誌資訊如下所示，

```shell
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

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

```shell
[oracle@sourcedb oracle]$ cd $ORACLE_HOME/dbs
[oracle@sourcedb dbs]$ ls -ltr
total 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 selected

SQL> 
```
---

## 4. 重新開啟adg
```shell
**********oracle active data guard
alter database recover managed standby database cancel;
alter database open;
alter database recover managed standby database using current logfile disconnect;
```

Oracle DataGuard FAL[client, ARC2]: Error 16191 connecting to 問題處理過程記錄

相關文章