Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Difficulty configuring GG extract in classic mode with 12c RAC instance and asm log archive dest

sidneysSep 13 2016 — edited Sep 14 2016

I have an EBS RAC instance named PILLARC2, where I want to configure GG to extract some data.

For now, I want to run this configuration in classic mode.

In the extract parameters I use TRANLOGOPTIONS DBLOGREADER

In the database, log_archve_dest_1='LOCATION=+RECOC1' as this is an ASM diskgroup.

The database is archiving its logs to this under +RECOC1/PILLARC2/ARCHIVELOG, I see the archive logs being generated there.

log_archive_format=%t_%s_%r.dbf

On starting the new extract, I get:

2016-09-13 21:29:32  ERROR   OGG-00446  Opening file +RECOC1/1_84_920192016.dbf in DBLOGREADER mode: (308) ORA-00308: cannot open archived log '+RECOC1/1_84_920192016.dbf'

ORA-17503: ksfdopn:2 Failed to open file +RECOC1/1_84_920192016.dbf

ORA-15173: entry '1_84_920192016.dbf' does not exist in directory '/'

Not able to establish initial position for begin time 2016-09-13 20:38:01.000000.

Why is the database able to identify the correct location but GG can't?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 12 2016
Added on Sep 13 2016
3 comments
921 views