Re: Redo log problem

From: Dave Murfitt <dave-ANTISPAM_at_murfitt-consulting.com>
Date: Sat, 12 Jun 1999 13:17:23 +0100
Message-ID: <7jtimu$ro3$1@news8.svr.pol.co.uk>

You are running in archive log mode and are not moving the online redo logs as they are being filled.

The solution is to either change the mode to NOARCVHIVELOG mode or when the DB switches log files move them to a safe location. You can get ORACLE to do this automatically (see the manual on "arch") or yourself with a script.

Dave

<sanjeeb_b_at_my-deja.com> wrote in message news:7jta96$786$1_at_nnrp1.deja.com...
> Hi,
>
> I am facing the following problem.
>
> Message :
> --------------------------------------------------
> Warning - The following error occured during
> oracle redo log archieve.
>
> Oracle instance <instance name> - can not allocate
> log, archival required.
>
> --------------------------------------------------
>
> I am running the oracle version 8.0.3 on
> Window-NT.
>
> Thanking you,
>
> Sanjeeb Bhattacharya
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sat Jun 12 1999 - 07:17:23 CDT