Re: Streams Replication: Source DB Oracle 11gR2, Target DB Oracle 11gR1

From: ddf <oratune_at_msn.com>
Date: Wed, 20 Jul 2011 10:48:40 -0700 (PDT)
Message-ID: <5a37212c-8ee6-4747-bf81-6b95da9d5539_at_m22g2000yqh.googlegroups.com>

On Jul 20, 5:02 am, Ora_DBA <sanjaydharmadhik..._at_gmail.com> wrote:
> We are replicating a few tables from Oracle Database 11gR2 to Oracle
> 11gR1 using Streams Replication (Downstream Capture). The archived log
> files from the source DB (11gR2) are shipped to a shared drive. We
> then register the archived log files at the target database (11gR1)
> using ALTER DATABASE REGISTER ... command.
>
> We are getting the following error message:
>
> ORA-01333: failed to establish Logminer Dictionary
> ORA-01304: subordinate process error. Check alert and trace logs
> ORA-01358: LogMiner version is less than mined dictionary version
>
> Do we need to update the target database to 11gR2 ? Is there a work-
> around?
>
> Any other information that might be relevant would be greatly
> appreciated.
>
> Thanks in advance.
>
> - Sanjay

11.1 is not forward compatible with 11.2. You need to upgrade the destination to 11.2 for this to function.

David Fitzjarrell Received on Wed Jul 20 2011 - 12:48:40 CDT