GoldenGate Database Initial Setup
GoldenGate Uni-Directional Replication
GoldenGate Bi-Directional Replication
GoldenGate as a Clusterware Resource
Checking and Diagnosing GoldenGate
Converting Bi-Directional to Uni-Directional
GoldenGate Best Practices - Bi-Directional
GoldenGate High Availability with RAC
set lines 120 col job_name format a20 col ACTUAL_START_DATE format a30 col run_duration format a30 select JOB_NAME, STATUS, to_char(ACTUAL_START_DATE,'DD-MON-YYYY HH24:MI') start_date, RUN_DURATION from dba_scheduler_job_run_details where job_name = 'SYNC_SEQUENCES_JOB' order by 3;
set lines 120 col sequence_name format a30 col sync_date format a40 select * from ggate.sync_sequences_log order by sync_date;
set lines 120
col sequence_name format a30
select * from ggate.mol_gg_sequences
order by owner;
select owner, sequence_name, valueint, valuepoc,
case when mod(ValueInt,2) = mod(ValuePOC,2) then 'ERROR'
else 'ODD EVEN SUCCESS'
end Validation
from ggate.mol_gg_sequences
order by owner, sequence_name;
SET PAGESIZE 0 LINESIZE 120 FEEDBACK OFF
spool /u07/goldengate/dirout/sequence_sync_output.sql
SELECT 'set echo on timing on' from dual;
SELECT 'conn ggate/ggate123' from dual;
SELECT 'exec mol_sequences.mol_sequence_sync(''' || SEQUENCE_OWNER || ''',''' || SEQUENCE_NAME || ''',100);'
FROM DBA_SEQUENCES
WHERE SEQUENCE_OWNER in ('MAILONLINE','RDRCOMMENTS','REGISTRATION','LEGAL','FBIAGENT')
AND SEQUENCE_NAME not in ('HIBERNATE_SEQUENCE','HEALTHCHECK_SEQ','TN_TEST_SEQ')
ORDER BY 1;
spool off
alter session set nls_date_format = 'DD-MON-YYYY HH24:MI:SS'; set linesize 100 col group_name format a12 col scn format a16 select GROUP_NAME, LOG_CSN as SCN, SEQNO, RBA, LAST_UPDATE_TS from GGATE.CHKPTAB;
SET LINESIZE 160
COL TABLE_NAME FORMAT A40
COL RECCSN FORMAT 999999999999
select to_char(EXCP_DATE,'DD-MON-YYYY HH24:MI:SS') EXCEPTION_DATE,
REP_NAME, TABLE_NAME, RECCSN, LOGRBA, LOGPOSITION, SRCROWID SOURCE_ROWID,
ERRMSG FROM ggate.exceptions;