Re: RMAN Backup timing question

From: DA Morgan <>
Date: Wed, 02 Jan 2008 20:44:58 -0800
Message-ID: <> wrote:

> On Jan 2, 5:52 pm, hpuxrac <> wrote:

>> On Jan 2, 5:32 pm, wrote:
>>> I have a database, I did level 0 backup using RAMN, let us say it took
>>> t1 minutes.
>>> Now I deleted lot of data in database using delete staements (as part
>>> of some application archiving process). I do level 0 backup again.
>>> Will time taken now be roughly same as t1 or lot less because many
>>> blocks are "empty".
>>> Thanks.
>> What version of oracle?
>> If you just "delete rows" but haven't truncated tables releasing
>> extents or dropped tables ... then the blocks aren't exactly empty are
>> they? They may not contain rows but that's a different story.
> Thanks. This was a general question. I have versions from 8.1.6 to
> 10.2 running on Widnows and HP UNIX.

It will be different in the different versions. Read the docs:

But be aware that 8.1.6 is so old the docs are no longer online. Look at the 8.1.7 docs and hopefully they are similar.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Jan 02 2008 - 22:44:58 CST

Original text of this message