Introduction: Oracle Logical Standby Database can be used for write opeartion if required to do reports and test any statement. Although if the same transaction got executed on Primary then it will create conflict and SQL apply got abrupt on Standby, hence it will result in out of sync between Primary & Standby. In this article, we will see how to resolve such issue by skipping the transaction. Prerequisites: Logical standby should be configured and in sync. Environment: Server Primary Standby Hostname drdb.oraeasy.com dcdb.oraeasy.com OS OEL 9 OEL 9 SID ORADBDR ORADBDC Service Name ORADBDR ORADBDC Now proceed to create the issue scenario and its resolution step by step: 1. Check the sync between Primary and Standby. ==> Primary: SQL> select name,db_unique_name,databas...