Verify Databases Have Supplemental Logging Enabled - Intergraph Smart 3D - Administration

Intergraph Smart 3D Project Management

PPMProductFamily
3D Design and Visualization
PPMProduct
Intergraph Smart 3D
PPMCategory
Administration
SPFVersion_custom
2019 (10.0)
Version_S3D
12.1(2019)

You must perform the following procedure at the Host and at all Satellite locations that participate in the Workshare.

  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, you must 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;