Shulou(Shulou.com)06/01 Report--

1. problem description

Oracle DataGuard log transfer failed with log information as follows:

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; THREAD# LOW_SEQUENCE# HIGH_SEQUENCE#---------- ------------- -------------- 1 38 402. problem analysis

Log shows very clearly, this problem is mainly caused by the following reasons,

Check the database parameter remote_login_passwordfile, the value is SHARED or EXCLUSIVE(default);SYS password is consistent with password file, that is, whether sys password has been changed recently, and password file is not synchronized;dg source and destination password files are synchronized; 11g default password is case-sensitive, and whether parameter ignorecase is added when generating password file. Target password file format: orapw+sid. 3. Recovery Procedure 3.1 Modifying the Source Sys Password

SQL> alter user sys identified by Star_1234;

User altered.

SQL>

3.2 Generate source-side 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 ---Backup source password file [oracle@sourcedb dbs]$ orapwd file=orapwepmsn password=Star_1234 ignorecovery =y ---Regenerate password file [oracle@sourcedb dbs]$ scp orapwepmsn oracle@hsql:$ORACLE_HOME/dbs/ --Transfer password file to DG destination orapwepmsn 100% 1536 1.5KB/s 00:00 [oracle@sourcedb dbs]$SQL> select * from v$archive_gap; --log transfer returns to normal, gap eliminates no rows selectedSQL>4. restart adg********oracle active data guardian database recover managed standby database cancel;alter database open;alter database recover managed standby database using current logfile disconnect;

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.