Re: Differential incremental backups

From: Jared Still <>
Date: Thu, 18 Mar 2010 11:41:35 -0700
Message-ID: <>

On Thu, Mar 18, 2010 at 11:11 AM, Orlando L <> wrote:

> That is the question Joel. I was always under the impression the earliest
> we could go back is to the point of base backup, aka level 0 backup. The
> previous backups (March 12, Friday as in your example) before the latest
> base backup (Mar14, Sunday) and archivelogs would get deleted by RMAN when
> we take the Mar 14, Sunday base backup, I assume. So I will not be able to
> use them to roll back to Mar 12 if I do restore on Mar 15.

Don't assume.

Read the docs, setup a test environment, and test until you understand how it works.

Reading the docs is good, but until you accompany that with actual hands on testing, you will not understand what you are doing.

And if you do not understand the implementation of RMAN in your environment, you will eventually find yourself in a position where you have lost a database, and either have no working backup at all, or find yourself forced to use a backup that causes data loss.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: Home Page:

Received on Thu Mar 18 2010 - 13:41:35 CDT

Original text of this message