SCN Message and Note 1380295.1 in import

From: Hemant K Chitale <hemantkchitale_at_gmail.com>
Date: Sun, 5 Feb 2012 15:46:33 +0800
Message-ID: <CAMNBsZtdCdHeQbc0rK8fhYj_xPHRtbyzLbLdyNPSactNvNVe6Q_at_mail.gmail.com>

During an impdp import into a 10.2.0.5 PSU6 database, we see this message : "Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropped and recreated. See My Oracle Support article number 1380295.1."

The message appears immediately after "Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM" in the import log.

My guess is that it relates to the the recent 'bug' about SCNs being extraordinarily incremented in a Hot Backup of database running distributed queries/transactions. This message did NOT appear in previous import tests when running 10.2.0.5.0 (i.e. without PSU6) so I presume that it is a new warning introduced in PSU6.

We don't have Streams configured but I wonder if Ebusiness Suite 11i has some complications. We do have database links and distributed queries.

 I can't find the note on support.oracle.com and have logged an SR.

Has anyone encountered this earlier ?

Hemant K Chitale

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Feb 05 2012 - 01:46:33 CST