Re: [Q]Online redo log files

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/07/19
Message-ID: <33D05A1E.6B69@postoffice.worldnet.att.net>#1/1

The size of the *initial* online redo log files is defined in the CREATE DATABASE statement.

To change the size of the online redo log files, you have to drop them (very carefully !) and then add them back with the new size. To add/drop logfile groups and/or members, use the ALTER DATABASE ADD/DROP LOGFILE GROUP/MEMBER statement. Note that a database needs at least two online redo log files to run.

IMHO, your best approach is to add one or more new logfile group(s) with at least two files each, of the size you want, perform one or more ALTER SYSTEM SWITCH LOGFILE commands, make sure that the status of the online redo log files that you want to drop is INACTIVE (SELECT * FROM v$log), and then drop the old logfile group(s)/file(s).

Hope this helps.

Michael Serbanescu

---

Earvin C. Lim wrote:
>
> Hi there,
>
> Does anyone know where is the size of the online redo log files defined?
> and how can we change the size?
> We are running Oracle 7.3.2
> Thanks in advance!
>
> --
> Earvin Lim
> -- Programmer/Analyst
> -- Academic Computing Services
> -- University of Texas at Arlington
> email: elim_at_uta.edu
> Phone: (817)272-3678
Received on Sat Jul 19 1997 - 00:00:00 CDT