Reset the startup time after the GoldenGate process is disconnected.
After the system is restarted, the operator does not restart the goldengate process, resulting in the disconnection of the replication link.
In addition, some archiving logs have been backed up and deleted for a long time. First, I tried to reextract the process and found that the archive file is missing.
Unfortunately, the backup software fails and the link cannot be restarted normally.
Only reinitialization can be performed. First, confirm that the extraction process ext1, the transmission process dpump1, And the replication process rep1 are in the stop State.
Modify e PROCESS startup time
Alter extract ext1, TRANLOG, BEGIN
Start Process e and process d
Start ext1
Start dpump1
Reinitialize data based on the scn number
SELECT dbms_flashback.get_system_change_number from dual;
-- 10653006236238
You can use dblink or data pump.
Restart the r process according to the scn number.
Start replicat rep1, aftercsn 10653006236238
Check the Process status. The link status is normal.
GoldenGate unidirectional table DML Synchronization
Oracle GoldenGate series: restoration principles of Extract processes
Oracle GoldenGate installation Configuration
OGG-01004 OGG-1296 error for Oracle goldengate
Oracle GoldenGate Quick Start Tutorial: Basic Concepts and configurations
Build a GoldenGate bidirectional replication environment from Oracle to Oracle