RE: Resizing Log file

From: Hallas, John <HallasJ_at_logicae.com>
Date: Fri, 01 Jun 2001 06:09:29 -0700
Message-ID: <F001.00317995.20010601052052@fatcity.com>

FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - lastnameinitial_at_logica.com eg SMITHK_at_logica.com. Emails using the old format will continue to be delivered until 30th June 2001.

Hi Nirmal,
Try something like the following script

alter database add logfile group 1
( '/u01/oradata/eval/redo1.log')

size 10M;

alter database add logfile group 2
( '/u01/oradata/eval/redo2.log')

size 10M;

alter database add logfile group 3
( '/u01/oradata/eval/redo3.log')

size 10M;

alter system switch logfile;
alter system switch logfile;
alter system switch logfile;

alter database drop logfile group 4;

alter database drop logfile group 5;
alter database drop logfile group 6;

                -----Original Message-----
                From:   Nirmal Kumar  Muthu Kumaran
[mailto:NIRMALK_at_qtel.com.qa]
                Sent:   31 May 2001 20:38
                To:     Multiple recipients of list ORACLE-L
                Subject:        Resizing Log file

                hi dba's,

                In my DB, oracle 816, NT4,  the redolog member's size is
only 50kb. I'm
                having only two groups with a single member each.

                I tried with alter database command, there is only options
for adding and
                droping log group or member...

                How can i resize it.. to increase the size 5mb.

                Regards,
                Nirmal.
                -- 
                Please see the official ORACLE-L FAQ: http://www.orafaq.com
                -- 
                Author: Nirmal Kumar  Muthu Kumaran
                  INET: NIRMALK_at_qtel.com.qa

                Fat City Network Services    -- (858) 538-5051  FAX: (858)
538-5051
                San Diego, California        -- Public Internet access /
Mailing Lists
        
--------------------------------------------------------------------
                To REMOVE yourself from this mailing list, send an E-Mail
message
                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
and in
                the message BODY, include a line containing: UNSUB ORACLE-L
                (or the name of mailing list you want to be removed from).
You may
                also send the HELP command for other information (like

subscribing).

This e-mail and any files transmitted with it, are confidential to Logica and are intended solely for the use of the individual or entity to whom they are addressed.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hallas, John
  INET: HallasJ_at_logicae.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Fri Jun 01 2001 - 08:09:29 CDT