As databases increase in size and queries place demands on the continued availability of the operating system, the time and hardware resources require back up. Although most database systems have incorporated backup and recovery tools into their interfaces and infrastructure it is advisable to understand the backup and recovery process without the tools.
There are number of reasons for data loss in the database like system outages, data corruption and database files corruption. Basically there are two main reasons for data loss in database.
The database failures that occur while update transactions is taking place. The corruption of OnDmand database which is usually caused by media failure |