但是重启数据库后,主库LOG_ARCHIVE_DEST_2

ERROR     ORA-16191: Primary log shipping client not logged on standby      STANDBY LGWR       LGWR

这是alert

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

------------------------------------------------------------

Errors in file /u01/app/oracle/diag/rdbms/cljka/cljk/trace/cljk_arc2_20139.trc:

ORA-16191: Primary log shipping client not logged on standby

PING[ARC2]: Heartbeat failed to connect to standby 'cljk111'. Error is 16191.

******************************************************************

LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2

******************************************************************

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

------------------------------------------------------------

Errors in file /u01/app/oracle/diag/rdbms/cljka/cljk/trace/cljk_nsa2_20422.trc:

ORA-16191: Primary log shipping client not logged on standby

Error 16191 for archive log file 3 to 'cljk111'

Thread 1 advanced to log sequence 34 (LGWR switch)

Current log# 1 seq# 34 mem# 0: /u01/app/oracle/cljkdata/redo1_1.rdo

Current log# 1 seq# 34 mem# 1: /u01/app/oracle/cljkdata/redo1_2.rdo

Successfully onlined Undo Tablespace 2.

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐