//
you're reading...
oracle

Oracle Fundamental Flaw.

In a Research by Infoworld.com.

 

Oracle has a very fundamental bug which can cause Database crash and cant be recovered

It is the Heart beat of Oracle database, SYSTEM CHANGE NUMBER.

When we Perform Hot backups Generally Oracle server will generate more scn numbers, If it is in a distributed databases When Oracle databases link to each other, maintaining data consistency requires them to synchronize to a common SCN. This is necessarily the highest SCN carried by any participating Oracle database instance because the SCN clock cannot run backward — so database linking causes the SCN in many databases to jump during normal operations. If there are more online backups the scn will jump high form millions to billions in short period, which may cause oracle to stop the instance or even worse database crash.

Oracle has released PATCH for this bug in JAN12 for 11R1 and 11gR2

Please Read Very detailed Article about bug by INFOWORLD.COM

To know More about SCN

Please read it from SCN~> What,why and How it funtions

Please post comments on further updates about this issue.

About these ads

About Sharath Ponugoti

I am simple guy Working as software engineer

Discussion

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: