Force standby de-synchronisation for script testing
Just disable sending redo to the standby on the primary (replace with actual dest number):

SQL&gt; alter system set log_archive_dest_state_2=defer scope=memory;


To re-enable (replace with actual database name):

DGMGRL&gt; enable database orcl_sb