You must perform the following procedure at the Host and at all Satellite locations that participate in the Workshare.
Open SQL*Plus, and connect as a user with SYSDBA privileges.
At the SQL prompt, type SELECT supplemental_log_data_min, force_logging FROM v$database;, and press ENTER.
The system responds by printing the value of the property. If the value is YES, as displayed, then supplemental logging is enabled.
If the value returned is NO, you must enable supplemental logging on the database server.
Open SQL *Plus on the database server.
At the command prompt, type the following:
CMD> SQLPLUS /NOLOG
SQL> CONNECT SYS/[password] AS SYSDBA
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL> ALTER DATABASE FORCE LOGGING;
SQL> ALTER DATABASE OPEN;
SQL> ALTER SYSTEM SWITCH LOGFILE;