checkout headroom on metalink, lots of information.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Deepak Sharma <dmarc-noreply@xxxxxxxxxxxxx>
Sent: May 26, 2016 12:15 AM
To: Oracle-l Digest Users
Subject: SCN Jumping issue
Just recently (last week) we came across an alert from OEM for one of our
primary databases, related to SCN Jumping or increasing very rapidly.
We already have an Oracle SR in place, but wanted to check with the community
about their thoughts in case someone has had similar experience in the past
(and any solution).
This is an Oracle 11.2.0.4 database (1) using RMAN backup, and (2) has several
connections coming over using database links to it (research shows the issue
could be db link related).
Some of the other DBs that have DB Links to ours, see messages related to
sudden increase of SCNs for their own DBs, in alertlog (fyi).
The OEM alert seem pretty serious, and says we have about 55 days before the DB
would freeze temporarily or throw ORA-600 errors.
Could be related to this :
https://community.oracle.com/thread/2336601?tstart=0
Questions Regarding the InfoWorld SCN Bug | Oracle
Community<https://community.oracle.com/thread/2336601?tstart=0>
community.oracle.com
As some of you may know, Oracle and InfoWorld announced today a bug in Oracle's
SCN mechanism
