Re: SCN Jumping issue

From: Michael McMullen <ganstadba_at_hotmail.com>
Date: Thu, 26 May 2016 14:35:07 +0000
Message-ID: <SN1PR12MB07992F61243B4C5D1B9CE1E7A6410_at_SN1PR12MB0799.namprd12.prod.outlook.com>

checkout headroom on metalink, lots of information.

---

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Deepak Sharma <dmarc-noreply_at_freelists.org> 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

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

Received on Thu May 26 2016 - 16:35:07 CEST