Re: to much archivelog

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 Wed Jan 22 2003 - 15:24:05 CST