CDC Issue while using Replicate Log Reader- Oracle as source

[dineshkumarl]

Hi Team,

We are facing the below mentioned error while using Replicate Log Reader for connecting Oracle database.

"Failed to open Redo log '/db/redo1/log123abc.dbf", "Redo online file with sequence 1 was not found in V$Log".

As part of prerequisites, we have created a directory pointing to Archived redo log.  When it comes to Online redo logs, here these online redo logs are stored in database files. 

To which we can create directory and get access to.  However, they currently have 6 mount points where these online redo logs database files are stored.

The DBA wants to know if we have to create 1 directory and point to any one of these mount points where the online redo log database files reside or do we have to create (6 directories) one directory for each mount point to access online redo log database files.

We are referring to : Required permissions | Qlik Replicate Help to grant required permissions. The Create Any directory permission has not been granted. Instead we are creating directories and pointing to respective redo logs.

Kindly assist

[john_wang · Accepted solution]

Hello @dineshkumarl ,

Thanks for reaching out.

You are right - you need to create the corresponding directories manually, each directory for each mount point where the online redo log database files reside.

In summary, If you want Replicate to create and manage the Oracle directories, you need to grant the CREATE ANY DIRECTORY privilege; if you want to create the directory manually (without grant the above privileges), then each directory for each mount point, it's same for both ONLINE and ARCHIVED redo log files. Detailed info can be found at User Guide page of create and manage the Oracle directories.

Hope this helps.

Regards,

John.

[dineshkumarl]

Thank you John, let me perform the same and post by observations.

[dineshkumarl]

@john_wang 

I am receiving the following error after configuring directories for online Redo logs.

"Oracle instance uses more than one archived Redo log destination id. Please configure the correct destination id, if the Redo logs of '1' destination cannot be accessed."

Currently I have one directory pointing to Archived Redo logs and 6 directories pointing to Online Redo logs in different mount points. 

Kindly suggest.

[john_wang]

Hello @dineshkumarl ,

Thanks for your update.

As I remember this is a general information (rather than an error). However you may query the view "v$archived_log" to select one of the DEST_ID (eg Name is not null, and the status is valid etc), more detailed information can be found in Replicate User Guide "Archived redo logs destination ID "& "Alternate archived redo logs destination ID", and Oracle doc V$ARCHIVED_LOG.

If you need additional assistance , please open support ticket and attach below information:

1- Task Diag Packages with SOURCE_UNLOAD/SOURCE_CAPTURE set to Verbose

2- Export the result of query "select * from v$archived_log where name is not null" Excel format and attach to case. 

Support team would like to help you to solve the issue.

Regards,

John.

[dineshkumarl]

@john_wang  We were able to fix the issue. There were more mount points to be added for online redo logs which fixed the redo log issue. 

However, the CDC isn't going through. I do not see any error in the task. I am analyzing the task log currently.