Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: to much archivelog

Re: to much archivelog

From: zeb <thierry.constant2_at_wanadoo.fr>
Date: Sun, 26 Jan 2003 15:13:36 +0100
Message-ID: <3e33ed38$0$14159$626a54ce@news.free.fr>


thanks, the archivelog are generated by
the night batch loads, and they are very big ...

<Kenneth Koenraadt> a écrit dans le message de news: 3e2f0892.1700334_at_news.inet.tele.dk...
> Hi Zeb,
>
> If it's a warehouse, it shouldn't generate that much redo log, since
> DW is primarily read-only data. So you should first examine why it
> generates that much redo and then try to do something about it, e.g.
> some operations could be optimized to generate less redo.
>
> If your only problem is disk space, there is also software available
> which will nicely copy the archive logs to tape as they are generated.
>
> Switching between ARCHIVELOG and NOARCHIVELOG, as you suggest, is
> hopeless...most likely you will end up with a corrupted DB.....
>
>
> - Kenneth Koenraadt
>
> On Wed, 22 Jan 2003 21:48:41 +0100, "zeb"
> <thierry.constant2_at_wanadoo.fr> wrote:
>
> >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
> >
> >
> >
> >
> >
> >
>
Received on Sun Jan 26 2003 - 08:13:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US