Reset the startup time after the GoldenGate process is disconnected.

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.