但是重启数据库后,主库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.