Re: Error: Oracle Redo Log Archival

From: David Lane <dlane_at_cix.compulink.co.uk>
Date: Sat, 16 Jan 1999 11:06:31 GMT
Message-ID: <F5nG6v.M2y@cix.compulink.co.uk>

In article <36A05B6F.B9010829_at_hkc.net>, thomast_at_hkc.net (Thomas Tsang) wrote:

> This is a multi-part message in MIME format.
> --------------DA7BB5D92528DD58F8EA422D
> Content-Type: text/plain; charset=us-ascii
> Content-Transfer-Encoding: 7bit
>
> Thank for your information, but I want to know how to make sure the
> alter system archivelog and automatic archive logging is active. In the
> other hand, as the free disk space in my archive_log_dest is more than
> 10 G, I don't think it is the cause of the error.
>
>
> Thomas Tsang
>

I agree with the earlier message .... if you have this much space left, it has to be that you've not enabled the automatic archiving. This means that now Oracle has written to all the available redo logs and has 'frozen' until you free one or more of them by archiving them. You can do this manually as dba .... think it's an option of alter database (if not it's alter system). Once you've done this enable automatic archiving.

The system admin manual describes how to see what's enabled already.

Dave Lane (dlane_at_pt.lu) Received on Sat Jan 16 1999 - 05:06:31 CST