Re: RMAN Backup timing question

On Thu, 3 Jan 2008 09:03:08 -0800 (PST), zigzagdna_at_yahoo.com wrote:

>On Jan 3, 11:43 am, vitalis..._at_gmail.com wrote:
>> On Jan 3, 4:36 pm, zigzag..._at_yahoo.com wrote:
>>
>>
>>
>>
>>
>> > On Jan 2, 11:44 pm, DA Morgan <damor..._at_psoug.org> wrote:
>>
>> > > zigzag..._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
>> > > damor..._at_x.washington.edu (replace x with u to respond)
>> > > Puget Sound Oracle Users Groupwww.psoug.org-Hidequoted text -
>>
>> > > - Show quoted text -
>>
>> > I think in Oracle10g with compression option, backup times shold
>> > reduce, oher versions timing will be same.
>>
>> > Prem
>>
>> I don't know the specifics about each version by heart, but it goes
>> something like this:
>>
>> 9i -> RMAN skips blocks that have NEVER been formatted
>> 10g -> it skips all unused blocks (even if they have been formatted
>> and were used earlier)
>> 8i -> I don't care ;)- Hide quoted text -
>>
>> - Show quoted text -
>Thanks. Question is what is meant by unused in 10G. I think after
>deletion, block still has some header information, so it is used?

This is not the question. The question is why you don't just look it up in the documentation. You would have had your answer hours ago. Now you just show you didn't make a New Years Resolution to become a little more inquisitive and industrious and you still prefer to trash this forum with RTFM questions.

-- 
Sybrand Bakker
Senior Oracle DBA