Alert 日志发现如下错误
Fri Sep 03 09:18:59 2021
Media Recovery Log /arch/1_436911_1005783801.dbf
Media Recovery Waiting for thread 2 sequence 503832
Fetching gap sequence in thread 2, gap sequence 503832-503832
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, USER]: Error 16191 connecting to JDEDB for fetching gap sequence
Fri Sep 03 09:19:04 2021
Errors in file /u01/app/oracle/diag/rdbms/jdedbdg/JDEDB/trace/JDEDB_pr00_34873.trc:
ORA-16191: Primary log shipping client not logged on standby
RFS[3]: Opened log for thread 2 sequence 503832 dbid 3892519434 branch 1005783801
Fri Sep 03 09:19:18 2021
Archived Log entry 299931 added for thread 2 sequence 503832 rlc 1005783801 ID 0xe8ce7e1f dest 2:
Fri Sep 03 09:19:18 2021
Media Recovery Log /arch/2_503832_1005783801.dbf
说明：1 . 我并没有修改oracle任何账户的密码
2. 我把主库的密码复制到了adg库后还是同样报错，不过我发现adg在应用gap的归档了。我担心还是出现adg不能同步的症状
oracle的adg非常成熟和稳定，和mysql不同，mysql不同步你可以跳过。oracle不行。你只要追平了就是一致的。中间一定是连续的，数据没有丢失。如果中间断了，那么他就卡在中断的那一个时刻，一直停在那里。
评论
有用 0我在备库上执行
select SEQUENCE#,FIRST_TIME,NEXT_TIME ,APPLIED from v$archived_log order by 1 desc; 发现日志又不应用了。
在主库上执行select * from V$ARCHIVE_GAP; 并没有发现gap。
在主库的第二个节点的alert日志里面还能看见下面的错误
Errors in file /u01/app/oracle/diag/rdbms/jdedb/JDEDB2/trace/JDEDB2_arc8_113933.trc:
ORA-01017: invalid username/password; logon denied
Fri Sep 03 10:47:27 2021
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
评论 有用 0
