Please do not copy paste from out side source Natural and ma

Please do not copy paste from out side source. Natural and man-made disasters can completely destroy a database. Describe a disaster that would require database recovery and discuss your thoughts on preparing for and recovering from that disaster. You may use a disaster that you have read about in recent years, or you may describe a hypothetical, but possible, disaster.

Solution

A violent earthquake is a natural phenomenon that can completelt destroy the hardware, servers and infrastructures hosting a database. In such scenario, the database will be completely destroyed. The necessary preparation to recover from such a disaster is to maintain a standby copy of the entire database at a remote geographical location. Such a standby should periodically be refreshed with the latest data of the active database. The frequency of backup to the remote side would depend on the criticality of the data.

In case of the disaster occuring, the infrastructure must be rebuilt first at a different or the same location depending on the chances of the disaster occuring again. Once the rebuild is complete, the database needs to be restored from the remote site.