The original goldengate extraction process of the main library after oracle master / standby switching

After the oracle master / slave switch, the original goldengate extraction process of the master database will abend error. In this case, you need to configure the following parameters in the extraction process:

TRANLOGOPTIONS MINEFROMACTIVEDG

This feature is a new feature of goldengate12.1.2.1.0: it supports real-time capture of changes from ADG's online logs.

Start the extraction process for goldengate:

Start ext_app

If the application is not started at this time, there is no delay before shutting down the extraction process. In fact, the following operations can also be used (standby, careful use, data loss is possible):

# alter extract ext_app, tranlog, begin now

Correct handling steps:

If you start the extraction process at this point, the error process will become abend, or you can view the error message:

View report ext_app

The following error can be sent, and the error message is very clear:

2018-09-27 18:05:06 ERROR OGG-02803 Encountered a Data Guard role transition. Alter Extract to SCN 8096622950106 and restart Extract, or recreate Extract with the correct number of th

Reads at SCN 8096622950106.

Modify the extraction scn number of the extraction process and start:

Alter ext_app, scn 8096622950106

Start ext_app