Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Standby out of sync - ORA-16191: Primary log shipping client not logged on standby

Ganesh SMay 23 2024

Hi ,

Oracle DB - 19.21.0.0.0

Primary and standby are not in sync, getting below error. Already tried transferring sys password but issue persists.

Below error captured in dest status. Please suggest.

select DEST_ID,DEST_NAME,STATUS,DESTINATION,error from gv$archive_dest_status where status <> 'INACTIVE' order by 1,2;

DEST_ID DEST_NAME STATUS DESTINATION ERROR
-------- -------------------- --------- -------------- ------------------------------------------------------------
1 LOG_ARCHIVE_DEST_1 VALID
2 LOG_ARCHIVE_DEST_2 ERROR STBY_HOGSI ORA-16191: Primary log shipping client not logged on standby

This post has been answered by Balamurugan Sivalingam on May 23 2024
Jump to Answer
Comments
Post Details
Added on May 23 2024
2 comments
397 views