oracle最新scn补丁,Oracle全面修正了关于DB Link和SCN补丁的公告

3. What is the change introduced by the patches listed above?

These patches increase the database's current maximum SCN (system change number) limit.

At any point in time, the Oracle Database calculates a "not to exceed" limit for the number of SCNs a database can have used, based on the number of seconds elapsed since 1988. This is known as the database's current maximum SCN limit. Doing this ensures that Oracle Databases will ration SCNs over time, allowing over 500 years of data processing for any Oracle Database.

These recommended patches enable the databases to allow for a higher current maximum SCN limit. The rate at which this limit is calculated can be referred to as the "SCN rate" and these patches help allow higher SCN rates to enable databases to support many times higher transaction rates than earlier releases.

Please note that the patches only increase the max limit but the current SCN is not impacted. So, if all your databases don't have any major change in transaction rate, the current SCN would still remain below the current maximum SCN limit and database links between newer (or patched) and unpatched databases would continue to work. The patches provide the safety measure to ensure that you don't have any issue with dblinks independent of any possible future change in your transaction rate.

请注意，这个补丁仅仅是增加了最大的SCN限制，所以如果你的数据库在事务率方面没有改变，或者事务率不高，当前的SCN将维持在最大SCN限制以下，在旧版本和新版本之间的DB link也可能毫无问题。

With the patches applied, this change in current maximum SCN limit will happen automatically starting 23rd June 2019.

如果应用了补丁，SCN 新算法的自动生效期是：2019年6月23日。

4. What happens if the recommended PSU / patchset is not applied?

If this patch is not applied, the unpatched database will have a lower SCN rate or lower current max SCN limit.

The newer or patched databases will have higher SCN rate or higher current max SCN limit.

如果不应用补丁，低版本的数据库使用低SCN增长率，高版本数据库使用高SCN增长率。这两类数据库互联，就可能出现SCN的问题。

Therefore, there can be situations when the patched database is at a higher SCN level (due to the higher SCN rate allowance) and the unpatched database is at a much lower SCN level (due to lower SCN rate allowance).

When you open a dblink between these two databases, it has to sync the SCN levels of both the databases and if the SCN increase needed in the unpatched database for this sync is beyond it's allowed SCN rate or current max SCN limit, then the dblink connection cannot be established.

This situation will not rise immediately after the change, but can potentially arise any time after 23rd June 2019.