SO: CentOS 6.4 (64 bits)
DB: 126.96.36.199.4 (64 bits)
I have 2 servers, both running CentOS and Clusterware 188.8.131.52. I am trying to create a replication method using Goldengate from SERVER1 to SERVER2, but i'm facing the "OGG-00446 Could not find archived log for sequence" error. Doing some research, i read somewhere that because my redo logs and archives are in ASM, i need to use some parameters to make the extract to work properly. Is this correct? Is there any differences in using ASM in the perspective of Goldengate?
I already executed the command "alter extract ext_name begin now" without success.
Any helps/suggestions will be extremely appreciated.
Thanks for the pacience and attention.
Thanks for your attention.
Here is my EXTRACT, with the TRANLOGOPTIONS DBLOGREADER, as you suggested:
setenv (ORACLE_HOME = "/u01/app/oracle/product/11.2.0/db_2")
setenv (ORCLE_SID = "prod1")
userid usr_gg, password passwd1
rmthost vm-server1, mgrport 7809
ddl include mapped objname usr_testes.*
But now i am getting the following error message:
2013-10-26 09:29:50 ERROR OGG-00446 Opening ASM file +DG_FRA/prod1/archivelog/2013_10_23/thread_1_seq_27.390.829580407 in DBLOGREADER mode: (26947) ORA-26947: Oracle GoldenGate replication is not enabled.
Not able to establish initial position for begin time 2013-10-22 22:50:00.
2013-10-26 09:29:50 ERROR OGG-01668 PROCESS ABENDING.
I did some research regarding this error, but i found anything but useless info.
Probably you are playing with Oracle database version 184.108.40.206 or later.
In this case you need set a new param in the database:
So, in order to use OGG, on Oracle 220.127.116.11, or Oracle 18.104.22.168+, you will need to issue the following command through SQL*Plus.
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;