Backup Types in Oracle

Backing-up is a crucial process that everyone should do in order to have a fail-safe, for when the inevitable happens. The principle is to make copies of particular data in order to use those copies for restoring the information if a failure occurrs (a data loss event due to deletion, corruption, theft, viruses etc.).

You can perform the backup manually by copying the data to a different location, or automatically using a backup program.

Each program has its own approach in executing the backup, but there are four common backup types implemented and generally used in most of these programs: full backup, differential backup, incremental backup and mirror backup. A type of backup actually defines how data is copied from source to destination and lays the grounds of a data repository model (how the back-up is stored and structured).

The image below provides an overview comparison between these backup types, for detailed information about each read the rest of the article:

Oracle Backup types

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Current day month ye@r *

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube