Re: RMAN Backup timing question

<zigzagdna_at_yahoo.com> wrote in message
news:62f193fb-a518-4914-b718-4e5ed5eeecb1_at_e4g2000hsg.googlegroups.com... 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?

Yes. Deletion does not change the fact that it has been used before. Received on Thu Jan 03 2008 - 19:55:57 CST