Re: Redo log file size question
- From: "fmhabash@xxxxxxxxx" <cnewtonne@xxxxxxxxx>
- To: ashoke.k.mandal@xxxxxxxxxxxxx
- Date: Thu, 22 Feb 2007 17:54:23 -0500
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
---------- ---------- ---------- ---------- ---------- ---
---------------- ------------- ---------
1 1 370 104857600 5 NO
INACTIVE 2610612550 21-FEB-07
2 1 371 104857600 1 NO
CURRENT 2610895569 22-FEB-07
3 1 369 104857600 3 NO
INACTIVE 2610337265 20-FEB-07
4 1 0 5120 1 YES
UNUSED 0
--
//www.freelists.org/webpage/oracle-l
Other related posts:
