Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Redo log file size question

Re: Redo log file size question

From: <fmhabash_at_gmail.com>
Date: Thu, 22 Feb 2007 17:54:23 -0500
Message-ID: <45DE1F1F.6020502@gmail.com>


Does not look like it. This worked for me...

ALTER DATABASE

  2     ADD LOGFILE GROUP 4 ('/u01/app/oracle/oradata/fred/redo04.log')
  3     SIZE 5K REUSE;

Database altered.

SQL+:SYS:FRED1> select * from v$log;

    GROUP#    THREAD#  SEQUENCE#      BYTES    MEMBERS ARC 
STATUS           FIRST_CHANGE# FIRST_TIM

---------- ---------- ---------- ---------- ---------- ---
Received on Thu Feb 22 2007 - 16:54:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US