SCN Jumping issue

From: Deepak Sharma <"Deepak>
Date: Thu, 26 May 2016 04:15:34 +0000 (UTC)
Message-ID: <2132334367.928319.1464236134386.JavaMail.yahoo_at_mail.yahoo.com>

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

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

Received on Thu May 26 2016 - 06:15:34 CEST