Re: to much archivelog

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:n0QX9.31271$jM5.79511_at_newsfeeds.bigpond.com...
> "zeb" <thierry.constant2_at_wanadoo.fr> wrote in message
> news:b0mvvk$qc6$1_at_news-reader10.wanadoo.fr...
> > Hi,
> >
> > We have a datawarehouse, ( 8.1.7, AIX 4.3.3 )
> > the database is in archivelog and we have disk space problem.
> > we have a lot of archive we don't need
> > we only need them to do the hot backup.
> >
> > do you know a method to get the archive only for the backup
> > something like:
> > - noarchive log
> > - put the database archive log
> > - do the hot backup
> > - put the database no archive log
> >
> > Is a good method ???
> >
> > Thanks in advance
> >
>
> Hi Zeb,
>
> It's been a long week and I've read this a couple of times and I'm sure
I'm
> missing something really silly but I'm utterly confused.
>
> You say that you only need the archivelogs so that you can perform the hot
> backup, after which you don't need the archivelogs anymore ?
>
> Well if you implement your strategy and you take your hot backups
(starting
> at redo log sequence 98) and after which you take the db out of archivelog
> mode (at redo log sequence 100) and then later on you lose a datafile (at
> redo log sequence 110) , what do we do ?
>
> Well, we restore the hot backup (at redo log sequence 98) and recover the
> database to the point of time when the hot backups were completed (redo
log
> sequence 100) and then, and then .....
>
> Well then we're kinda stuck. Because the rest of the database has moved on
> (it's now at redo log sequence 110) but we can't recover any further as
the
> subsequent archived redologs (101, 102, etc) have been overwritten but not
> archived. You *can't* get to 110 which makes your hot backups somewhat
> pointless !!
>
> I don't think so ...
>

I am tired !!

Forgot to mention that if disk space for your archived redo logs are a concern look at:

.Using read-only tablespaces where ever possible, as this is a DW

.Backing up more frequently, hence less need to store as many logs

Good luck (and good night :)

Richard Received on Thu Jan 23 2003 - 06:37:33 CST