In Oracle : RMAN incremental backup for an Oracle DB

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle DBA

Real Application Cluster (RAC) Maintenance tasks Backup and Recovery Database Architecture Replication Oracle Performance Tuning Oracle DBA - Other articles Oracle scripts/ Selects for DBA Oracle Errors (ORA-nnnnn)

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle DBA -> Oracle Database Backup and Recovery

-> RMAN incremental backup for an Oracle DB

 

 RMAN incremental backup for an Oracle DB

 

 

Here are the main topics for this article:

 

1. Incremental database backup Overview

2. Incremental DIFFERENTIAL backup

3. Incremental CUMULATIVE backup

4. The advantages of each types of incremental backup

 

 

1. Incremental database backup Overview

 

Sometimes we need to backup the database changes only from the last backup (only the last changes are backed up). This is an incremental backup. There are 2 types of incremental backup: DIFFERENTIAL (by default) & CUMULATIVE. 

NOTE: The incremental backups are only for the DATA files.

2. Incremental DIFFERENTIAL backup

 

RMAN incremental backup  Picture 1

 

DIFFERENTIAL backup = which backs up all blocks changed after the most recent incremental backup at level 1 or 0. (See Picture 1). The following RMAN command is used to take a DIFFERENTIAL database backup: 

RMAN> BACKUP INCREMENTAL LEVEL 1 DATABASE;

 

 

3. Incremental CUMULATIVE backup

 

RMAN incremental backup Picture 2

 

CUMULATIVE backup =  which backs up all blocks changed after the most recent incremental backup at level 0. (See Picture 2)

The following RMAN command is used to take a CUMULATIVE database backup: 

RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;

 

 

4. The advantages of each types of incremental backup

 

Here are the advantages of each types of incremental backup:

 

 Advantages of the DIFFERENTIAL backup  Advantages of the CUMULATIVE backup
 
  1. Less space disk used

  2. Less network traffic

  3. Less time to take a backup
 
  1. Less time to recover

 

 

In-Oracle.com  -> Oracle DBA -> Oracle Database Backup and Recovery

-> RMAN incremental backup for an Oracle DB

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.