无法传日志到物理备库,日志报:1017 ORA-16191

郑全

又遇到这个问题，主库老是无法往物理备库传日志，报：

Mon Sep 15 03:40:38 2025
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



两边密码一样的

在备库日志文件中，发现以下错误：

Mon Sep 15 03:34:01 2025
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_6842.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-06512: at line 19
Mon Sep 15 03:42:36 2025
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_ora_7815.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-06512: at line 19



orcl_ora_7815.trc

Error in executing triggers on connect internal
*** 2025-09-15 03:42:36.925
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=0, mask=0x0)
----- Error Stack Dump -----
ORA-00604: error occurred at recursive SQL level 1
ORA-16000: database open for read-only access
ORA-06512: at line 19

*** 2025-09-15 03:43:08.532
*** 2025-09-15 03:43:08.532 1213 krsv.c
krsv_fg_so_init: Cleanup action 1

*** 2025-09-15 03:43:08.532
Stopping background process MMNL

*** 2025-09-15 03:43:09.554
Stopping background process MMON

*** 2025-09-15 03:43:10.578
Managed Recovery: Cancel posted.

*** 2025-09-15 03:43:11.625
ksukia: Starting kill, flags = 1
ksukia: Attempt 1 to kill process oracle@his1, OS id=4582
ksukia: killed 1 out of 1 processes.

*** 2025-09-15 03:43:12.690
ksukia: Starting kill, flags = 1
ksukia: killed 0 out of 0 processes.

*** 2025-09-15 03:43:14.868
*** 2025-09-15 03:43:14.868 1292 krsv.c
krsv_fg_so_delete: Process state object
175439236: Cleanup shutdown
*** 2025-09-15 03:43:14.868 4343 krsh.c
ARCH: Archival disabled due to shutdown: 1089

*** 2025-09-15 03:43:15.891
*** 2025-09-15 03:43:15.891 4343 krsh.c
ARCH: Archival disabled due to shutdown: 1089


看来有什么东西在执行，
看以前帖子，可能有触发器，
执行：
ALTER SYSTEM SET "_system_trig_enabled"=FALSE;

再去查看，发现日志开始执行恢复了。

看来问题解决。

这个问题，说明，备库有触发器，可能导致主库无法向备库传日志。