Oracle Database Discussions

This is not a GoldenGate question. Why are you shipping logs? Is this data guard, logical standby or logmining server? Is 11r2g your primary and 12c your standby?

Cheers

Kee Gan

Dear KGan

Thanks for the reply.

This is GoldenGate replication.

For  INTEGRATED CAPTURE we have to ship redo from source to minig server (target) using log_archive_dest and log_archive_config parameters. At target standby by logs will be used by capture process to extract the transactions.

I have to find reason why standby logs are not written at destination while connection is made successfully.

  LNS: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned

Any advise will be appreciated.

Umaruddin Ansari

Hi UDA,

So you had configured the Downstream Capture to capture the changed data from a standby.. But the shipment of redo or archive logs are not related to Oracle GoldenGate. Check if your DG configuration is good. The issue falls to Oracle GoldenGate when your redo or archive logs are shipped well and if your Integrated Capture is not mining the logs.

As I mentioned, please check your DG configuration. Now, as a first solution you must manually copy your failed archived redo logs to the standby server and restart standby. But I suppose you must investigate your network connection between primary and standby databases.

Please check the below posts which might be helpful for you,.

Oracle Error: ORA-00272

Error Description:
Error writing archive log string

Error Cause:
An I/O error occurred while archiving a redo log file.

Action:
Check that the output device is still available and correct any device errors that may have occurred. Also, make certain that sufficient space for archiving is available on the output device.

Also it is better to post this error in the Data Guard Forum and not it Oracle GoldenGate..

Regards,

Veera

Let us be clear about what you want to do. You have a primary AIX 11.2.0.3 that you do not want Goldengate to run on. So you want to set up a logmining server which is just an 'empty' database that logs can be shipped to. See https://docs.oracle.com/goldengate/1212/gg-winux/GIORA/ic_deploy.htm#GIORA472 

Or the version 11 equivalent. Then you want GoldenGate integrated extract to run on this server. So far these 2 servers are the source.

If you want to have logs from Database: AIX - 11.2.0.3  64bit and shipped to Database : OEL 6 , 12.1.0.2 64bit and have OEL6 as the downstream mining server then it does become trickier. Yes Oracle does support 11.2.0.3 (with numerous patches needed) logs shipped to a dataguard (logmining server is under this umbrella) running 12c. I have not done this so the errors you are getting may attribute to this. Whatever it is, this is NOT the GoldenGate target. A logmining server is still the source. See the diagram in http://www.ateam-oracle.com/oracle-goldengate-best-practice-goldengate-downstream-extract-with-oracle-data-guard/

The whole thing is the source.

What is your aim here with GoldenGate? Are you trying to migrate the 11.2 database to 12c using GoldenGate? if so then setup a logmining server with the same database version (11.2) and then shipped the Goldengate trails (do not mix up GoldenGate trails with Oracle redo/archived logs) to your 12c. GoldenGate replicat CANNOT process oracle logs.

This is how OGG works,

SOURCE ( 11r2 Redo -> extract -> OGG trails -> OGG extract pump) --------> TARGET(-> OGG trails -> Replicat -> 12c database)

Cheers

Kee Gan