2 Replies Latest reply: Jan 3, 2013 12:21 PM by Nick.W-Oracle RSS

    supplemental logging configuration for GGS

    oracletune
      1. What is the difference in Oracle 11g R2 table supplemental logging types: 'USER LOG GROUP' vs 'ALL COLUMN LOGGING' ... where both types are defined by ALWAYS=ALWAYS per the DBA_LOG_GROUPS table.

      GOAL: correctly validate table logging attributes for Golden Gate configuration

      2. What is correct difference between:
      ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
      vs
      ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMS

      3. To replicate all rows for all DML to another schema, what is correct "table supplemental log type" command:

      a. ALTER TABLE [table_name] ADD SUPPLEMENTAL DATA (ALL) COLUMNS

      -or-

      b. ALTER TABLE [table_name] ADD SUPPLEMENTAL LOG GROUP table_set (id,name,date,desc) ALWAYS;
        • 1. Re: supplemental logging configuration for GGS
          MikeN
          Use ggsci "add trandata" instead of "alter table" to enable supplemental logging. The actual SQL can be traced if you want to know what it is, but it could change between releases. (You can script ggsci commands by piping commands through ggsci.)

          As for the different logging levels in Oracle, across versions, etc, that isn't in the GG docs, but can be (should be, in any case) found in the database docs.
          • 2. Re: supplemental logging configuration for GGS
            Nick.W-Oracle
            In GGSCI, you can also use the ADD SCHEMATRANDATA command which will automatically add supplemental logging for all tables in a schema. If you use GGSCI to ADD TRANDATA / SCHEMATRANDATA you can use the INFO TRANDATA command to determine if supplemental logging is enabled for a table.