Re: RMAN Backup timing question

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- Hide quoted text -
>
> - Show quoted text -

I think in Oracle10g with compression option, backup times shold reduce, oher versions timing will be same.

Prem Received on Thu Jan 03 2008 - 09:36:36 CST