OGG FAQ Processing

1403:ora-01403:no data foundWhen you run PL/SQL blocks, stored procedures, functions, triggers, and so on, assume that you need to performThe record was not queried. will return a 1403 errorGoldengate 1403 in the target segment replication process, godengate parses the SQL statement from the log, depending onthe WHERE condition of the SQL statement. Matching the corresponding record in the target segment's library
1403 error Reason: 1. Additional log related
? Data related? Table structure inconsistency/Index rebuild
Frequently asked Questions: 1. The production side I/O is too large, the memory consumption is too large configuration of multiple extract processes resulting in 2. Process "Suspended animation" 1> parameter configuration error: Tranlogoptions rawdeviceoffset 0 This parameter is only configured when AIX is using a bare device. Other environments cannot configure 2> view process status: Ggsci>send repxxx, statussend repxxx statussending status request to Replicat repxxx ... Current Status:processing datasequence #: 1rba:386168121157 Records on current Transaction3, RAC node clock not synchronized (OGG-01028) 1> Configuration parameters: Threadoptions maxcommitpropagationdelay 90000iolatency 900002> Configuring NTP clock synchronization Server
4, queue files do not voluntarily delete 1> implementation. Run multiple times: ADD exttrail ...

ADD Rmttrail ... 2> processing details for operation and maintenance documentation
5, the reference file username processing 1> tranlogoptions excludeuser username here username is required to replace the actual goldengateusername
6, the parameters of the file character set processing 1> setenv (nls_lang= "American_america. ZHS16GBK ") Here's American_america. ZHS16GBK is the word that needs to be replaced with the actual databaseset of character sets
7, the number of parameters in the file compression 1> rmthost *.*.*.*, Mgrport 7839, compress here compress must be configured to speed up transmission speed, reduce datapump delay
9, disaster-tolerant end storage performance Optimization 1> No primary key table suggests adding a primary key or a unique index 2> separate large tables into separate processes, adding a number of references: Batchsql

How does OGG jump over long business?Ggsci (cdla6702.netjets.com) 13> Send extract ext1i2d4, Showtrans
sending Showtrans request to EXTRACT ext1i2d4 ...
oldest redo log file necessary to restart Extract are:

Redo Log Sequence number 4762, RBA 77272080
-----------------------------------------------------------
xid:3.9.209025
items:0
extract:ext1i2d4
Redo thread:1
Start time:2014-03-22:00:11:06
scn:14.1966161432 (62095703576)
Redo seq:4762
Redo rba:77272080
status:running
Send extract ext1i2d4, Skiptrans 3.9.209025---->>> here should be XID. Not the SCN .

Question
Can I turn on the Oracle supplemental Log at the DB level only, without doing it at the Table level?


Answer
GoldenGate requires adding supplemental Logging at the Table level, regardless of the Database supplemental Settin G, due to issues with multiple Unique keys and/or lack of keys.

    It is highly recommended to use "ADD trandata" under the Ggsci interface.  If using the SQL command to add supplemental Logging at the Table level, the keys should is included (ex. 2 separate Unique Keys is all required).

How to open additional logs:to turn on supplemental logging at the database level, GoldenGate requires this command to be executed:

ALTER DATABASE ADD supplemental LOG DATA;

This change to add supplemental logging won't take effect until the current redo log are switched, so the following command must also be executed:

ALTER SYSTEM SWITCH LOGFILE.

(Note:you must has the alter DATABASE and ALTER SYSTEM privileges to execute the above SQL statements.)

to turn on supplemental logging at the table level, you can execute this command:

ALTER TABLE <table_name> add supplemental log group Ggs_mytab (<COLUMN_NAME>, <column_name>) Always;

(Note:you must has the ALTER TABLE privilege to execute the above SQL statement.)

Or You can turn the supplemental logging through Ggsci with the This command:

ggsci> dblogin userid <user>, password <pw>

ggsci> Add Trandata <schema>.<table>
How to determine if additional logs are open:1> database levelSelect Supplemental_log_data_min, SUPPLEMENTAL_LOG_DATA_PK,supplemental_log_data_ui, force_logging from V$database;
2> table levelSELECT * from Dba_log_groupswhere owner= ' <schema_name_in_upper_case> ' andtable_name= ' <table_name_in_upper_case> ';---Assume that data is returned, the additional log is already open. Otherwise not open

For a particular table, you can find which columns is part of the Supplemental Log group with the query below:

Select Log_group_name, column_name, POSITION from
Dba_log_group_columns
where owner= ' <schema_name_in_upper_case> ' and
Table_name= ' <table_name_in_upper_case> '
order BY position;

For a particular table, you can find out if supplemental Logging are turned on through Ggsci with the commands below:

ggsci> dblogin userid <user>, password <pw>
ggsci> Info Trandata <schema>.<table>
Select distinct A.sql_id,a.event,b.sql_text from v$session a,v$sql b where a.username= ' Gguser ' and a.program like ' replic at% ' and a.status= ' ACTIVE ' and a.sql_id=b.sql_id;

-----------------to organize it yourself.

OGG FAQ Processing