Verify databases have supplemental logging enabled - Intergraph Smart 3D - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D Global Workshare (Oracle)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
13.1

Perform the following procedure at the Host and at all Satellite locations that participate in the Workshare. All Oracle databases that participate as Host or Satellites must be configured to write supplemental data to the redo log files. This supplemental data enabling is required for successful replication.

  1. Open SQL*Plus, and connect as a user with SYSDBA privileges.

  2. 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, follow the steps below to enable supplemental logging on the database server.

  1. Open SQL *Plus on the database server.

  2. 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;
    SQL> EXIT;