FATAL-1278: Multiple (2) redo log threads with current data detected

Owned by Clive Otten (Unlicensed)
Jan 21, 2020
1 min read

This article explains how to resolve issue when MINE reports multiple redo log threads with current data

 

Problem Details

Problem Statement

MINE reports multiple redo log threads

Applicable Error Code

FATAL-1278: Multiple (2) redo log threads with current data detected

Affected Versions

Replicate 2.7 and 2.8 , Oracle RAC 

Affected Platforms

Platform Independent

 

Description

FATAL-1278: Multiple (2) redo log threads with current data detected, please use parameter _MINE_RAC_SKIP_THREADS

Reason:
If the database was built as RAC, but now it's used as non-RAC. 
E.g. because it's a clone from production RAC.

Solution

Set the parameter _MINE_RAC_SKIP_THREADS equal to the redo threads that mine needs to ignore.
You can provide more than one redo threads by separating them with comma. The redo thread is gather from THREAD# is v$log, v$thread, etc.
E.g dbvrep> set _MINE_RAC_SKIP_THREADS = 2, 3

The MINE process must then be restarted.