This discussion is archived
1 Reply Latest reply: Nov 6, 2012 2:01 AM by AnnamalaiA RSS

ERROR OGG-00663 in goldengate initial load

961013 Newbie
Currently Being Moderated
Hi experts,


please help me in solve this issue.posting here logfile.

012-11-06 14:10:29 INFO OGG-03500 Oracle GoldenGate Capture for Oracle, load1.prm: WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of WE8MSWIN1252.
2012-11-06 14:10:30 ERROR OGG-01960 Oracle GoldenGate Capture for Oracle, load1.prm: Failed to validate table SH.PRODUCTS. The table is created with the NOLOGGING option, which is not supported. Extract may not be able to capture data from it.
2012-11-06 14:10:30 ERROR OGG-00663 Oracle GoldenGate Capture for Oracle, load1.prm: OCI Error retrieving bind info for query (status = 100), SQL < select (select count(*) from dba_tables where logging = 'NO' and owner = 'SH' and table_name = 'PRODUCTS') + (select count(*) from dba_tab_partitions where table_owner = 'SH' and table_name = 'PRODUCTS' and logging = 'NO') + (select count(*) from dba_tab_subpartitions where table_owner = 'SH' and table_name = 'PRODUCTS' and logging = 'NO') from DUAL >.
2012-11-06 14:10:30 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, load1.prm: PROCESS ABENDING.
  • 1. Re: ERROR OGG-00663 in goldengate initial load
    AnnamalaiA Journeyer
    Currently Being Moderated
    Hi,

    Some of the tables created with Nologging option,

    1. Check whether supplemental logging enabled at database level, then
    2.make sure logging is enable at table level, add trandata for table
    3. enable logging on tablespace level and start the extract process,

    ex, ALTER TABLESPACE users FORCE LOGGING;

    HTH
    Annamalai

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points