Re: Redo Log Archive grows and grows....

From: Kevin A Lewis <Kevin_A_Lewis_at_Hotmail.com>
Date: Mon, 10 Feb 2003 15:15:46 GMT
Message-ID: <CmP1a.4$6v4.150@newreader.ukcore.bt.net>

It is not unusualy to have scripts that backup the archive log directory twice and only on the second successful backup delete the files so copied.

Some 3rd party backup tools that are Oracle aware do exactly that (arcserve, SAP's brbackup etc)

Left to their own devices archive log files will just keep on increasing in number to the limits of disc space or quota.

Regards Kevin

"André Hartmann" <andrehartmann_at_hotmail.com> wrote in message news:b28bgk$pfs2_at_pen6.pen.k12.va.us...
> Hi,
>
> I am running an Oracle9i server with an instance in archive log mode.
Now
> my archive grows and grows and at some stage will reach the hard disk
> limits... what can I do ?
>
> Under which circumstances can I delete part of the archive ? And how ?
Do
> I just delete the files or will this mess up the instance's archive and
> statistics information ? Is there a tool to maintain the archive ?
>
> Thanks very much,
>
> AH
> :)
>
>
>
>
>
Received on Mon Feb 10 2003 - 09:15:46 CST