Shortcuts to losing your data

                 

Please stand by..

We are Experiencing Technical Difficulties !!!

Loss of DATA can break a business.It will effect to the business objective and that can be influence into organisation, information system and security program. Threats have a significant impact on Databases and it can be physical or non physical threats. Data can be misplaced because of hardware failures, data can mistakenly delete from user, data corruption, and environmental disruption.

According to research by the University of Texas, “Only six percent of companies suffering from a catastrophic data loss survive, while 43 percent never reopen and 51 percent close within two years.” Further it state that, some of the organisation never recover from major losses of data. Jim Martin, the chief operating officer with Worldport Ireland state that, majority of data in organisations is not stored in central repository off site. World Trade Center is one of the convenient locations for business and most of the financial and investment organisations are located, which was destroyed in the attack on 2001. Hardware failures, breakdowns are almost natural incidence on occasion, users are no longer able to access the data on the databases and it has major impact on large amounts of corporate data. These kinds of situations emphasise the importance of proper disaster and recovery plan. Also importance of maintain a remote site replication of data is an efficient means of protection.

1.     User Error

Human error causes most data loss; Erroneous updates, delete from database or can be overwriting. Deleting the contents of a table and dropping database objects can mistakenly happen. 

2.     Data Corruption

Data can be corrupt because of the Software bugs or Virus attacks. 

3.     Media Failure

A failure within the electronic circuits or hardware components may cause for data loss.

4.     Disaster

Data can loss because of natural event or human behavior such as Terrorist attacks. It can be electrical Failures or complete loss of a power to a geographic area because of weather related (earthquakes, tsunamis) or other causes of power outage.

Oracle and SQL server both provide strong recoverability features; whereas in some aspects superior to the other. ORACLE supports incremental backups which is a strong option when managing large scale databases, where this has to be accomplished through transaction log applying in SQL server. A scheduled oracle database with full, differential and incremental backups would guarantee 100% recoverability along with the support of Data guard. Database mirroring is equivalent to oracle’s data guard, but important features oracle offer is yet unavailable in SQL server database mirroring,

Comparing Database snapshot with oracle’s flashback, oracle stands way up high. Oracle flashback is as easy as issuing a query where in SQL server snapshot has to be created and then look for the changes.

Data corruption and human error causes most data loss, in this scenario it is important to back up data from database since there is no option other than to recreate the data. Data can be corrupt because of the virus attacks or bugs however it can be directly effect to entire database, its associated table or few files.

In the event of a disaster, Property, computer equipment can be caused and valuable data can be loss.  Recovery from this type of data loss requires hardware redundancy and mirroring. There should be a proper disaster recovery plan for database with manageable process. Because of the large quantity of data organisations should ensure the backup strategy and backup medium is stored at an offsite location.

Considering the options offered by ORACLE and SQL server it was evident that ORACLE is in the lead and rich in options. It offers smoother restoration, recovery, zero data loss and also easy recovery from user errors.