Database Disaster Recovery

Disaster is defined as an event that is unpredictable timing and is very destructive, which has four main factors, namely:
–  All of a sudden
–  not expected
–  the highly damaging
–  lack of planning

Disasters occur with uncertain frequency and its effect increases for those who do not prepare for the onset of catastrophic possibilities. Plans for disaster prevention and repair can help protect all the assets of the organization, including human resources, jobs, key data, and organizational facilities.

Here’s a list of events that could disrupt business continuity that is classified at the source, due to natural or man-made.
Examples of natural events that may affect business continuity is as follows:
–  Fire or explosion
–  Earthquakes, hurricanes, floods, fires and natural
Examples of events caused by humans that could affect business continuity as the following:
–  Events bombings, sabotage, or other intentional attack
–  Failure of communications infrastructure
–  computer virus

Database disaster recovery must inlcude in Disaster recovery planning (DRP), DRP  is a rational plan for the management and cost-effective disaster on the system and the information that would have occurred. In it there are aspects of the catastrophe in information systems. As with any insurance policy, a preventive plan against disasters on information systems and effective post-disaster recovery should a disaster despite the perceived benefits “will never occur” precisely because of the effectiveness of information systems. But the collapse of the information system itself is a disaster, interruption of daily activities due to loss of information.

To maintain database security can be done the following things:
–  Restrictions on access privileges for each existing account and logging (recording) for each of the changes.
–  Backup the database every day that moved into the CD (Compact Disc) by admin database who authorized.
The process of data backup can be seen more clearly in the image below.

Database Disaster Recovery Diagram1

Anticipation of Disaster
In anticipation of disasters such as fires, natural disasters, viruses, etc. then do the following:
–  Store database backups in a safe
–  Database backup is saved to another location
–  Database replication to another location
To detail can be seen in the following figure.

Database Disaster Recovery Diagram2