RE: SCN Message and Note 1380295.1 in import

  • From: "Powell, Mark" <mark.powell2@xxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 6 Feb 2012 18:12:58 +0000

I also ran a search on the Note id and got no hits.  I then tried a search on 
the phrase, " Cannot set an SCN larger than the current SCN," and got no useful 
hits except for  note: System Change Number (SCN), Headroom, Security and Patch 
Information [ID 1376995.1]


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Hemant K Chitale
Sent: Sunday, February 05, 2012 2:47 AM
To: ORACLE-L
Subject: SCN Message and Note 1380295.1 in import

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


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


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


Other related posts: