Restoring a database
Restoring a database allows for the complete restoration of data over a wide
range of potential system problems:
- Media failure . If one or more of the disk drives holding a database fail, you are faced
with a complete loss of data unless you can restore an earlier copy of the
data.
- User errors . If a user or application either unintentionally or maliciously makes a
large number of invalid modifications to data, the best way to deal with the
problem may be to restore the data to a point in time before the
modifications were made.
- Permanent loss of a server .If a server is disabled permanently, or a site is lost to a natural
disaster, you may need to activate a warm standby server or restore a copy
of a database to another server.
Additionally, backing up and restoring databases is useful for non-system
problems, such as moving or copying a database from one server to another. By
backing up a database from one computer, and restoring the database to another,
a copy of a database can be made quickly and easily.
This section provides the basic steps
required to restore a database. Please select a topic