Home » RDBMS Server » Backup & Recovery » INCREMENTAL and CUMULATIVE backups
INCREMENTAL and CUMULATIVE backups [message #60440] Sun, 08 February 2004 19:29 Go to next message
ora
Messages: 47
Registered: June 2002
Member
Hi,

Can anybody explain me the difference between the INCREMENTAL and CUMULATIVE backups. It looks same to me.

Thanx
Re: INCREMENTAL and CUMULATIVE backups [message #60454 is a reply to message #60440] Mon, 09 February 2004 04:06 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
quoting the docs

An incremental backup reads the entire file and then backs up only those data blocks that have changed since a previous backup.
A level 0 incremental backup, which is the base for subsequent incremental backups, copies all blocks containing data.
The only difference between a level 0 backup and a full backup is that a full backup is never included in an
incremental strategy. If no level 0 backup exists when you run a level 1 or higher backup, RMAN makes a level 0
backup automatically to serve as the base.

A level n incremental backup in which n is greater than zero backs up either:

All blocks changed after the most recent backup at level n or lower (the default type of incremental backup,
which is called a differential backup)
or
All blocks changed after the most recent backup at level n-1 or lower (called a cumulative backup)
Previous Topic: rman and really big files
Next Topic: Cold Backup Restoration
Goto Forum:
  


Current Time: Thu Mar 28 17:38:20 CDT 2024