Re: RMAN Backup timing question
From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 02 Jan 2008 20:44:58 -0800
Message-ID: <1199335477.388131@bubbleator.drizzle.com>
>> On Jan 2, 5:32 pm, zigzag..._at_yahoo.com 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.
Date: Wed, 02 Jan 2008 20:44:58 -0800
Message-ID: <1199335477.388131@bubbleator.drizzle.com>
zigzagdna_at_yahoo.com wrote:
> On Jan 2, 5:52 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>> On Jan 2, 5:32 pm, zigzag..._at_yahoo.com 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: http://tahiti.oracle.com
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Wed Jan 02 2008 - 22:44:58 CST