RE: SCN Message and Note 1380295.1 in import
Date: Mon, 6 Feb 2012 18:12:58 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415937DD6F4DE4B_at_GVW1337EXC.americas.hpqcorp.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Feb 06 2012 - 12:12:58 CST