Re: RMAN Backup timing question

On Jan 3, 1:57 pm, sybra..._at_hccnet.nl wrote:
> On Thu, 3 Jan 2008 09:03:08 -0800 (PST), zigzag..._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-Hidequotedtext -
>
> >> > > - 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- Hide quoted text -
>
> - Show quoted text -

Sybrand:
I noticed in 2007 100+ people called you moron or worse, 2008 there will be more.
A terrorist DBA who is always wasting internet bandwidth should be thrown out from this and other forums. Received on Thu Jan 03 2008 - 19:50:59 CST