RE: Resizing of redo log

I am extremly thankful to U and all those who replied to my query.

Thanx once again

-----Original Message-----
Sent: Tuesday, August 27, 2002 5:58 PM
To: Multiple recipients of list ORACLE-L

Pawan,
 To increase the size of your redo log is a multi step operation: Basically you ;
 select * from v$log; Gets info about logs...

select * from v$logfile; Gets more info about logs...

alter system switch logfile; Allows you to force a particular log active...

alter database drop logfile group 1; Drops a non active log....

alter database
add logfile group 1 'ORA:oranw734\database\glcd1-1.rdo' size 10 M; Creates a new log..

alter database
add logfile member 'SYS:\glcd1-2.rdo' to group 1; Adds a second log to the group...

Perform the above steps until you have resized all of the logs to the size you want and have cycled them through the active status to make sure they work.
Ron
ROR mª¿ªm
>>> Pawan.Dalmia_at_orange.co.in 08/27/02 07:18AM >>>

How is it possible to increase the size og online redo log files

Regards
Pawan Dalmia

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
--
Author: Pawan Dalmia
  INET: Pawan.Dalmia_at_orange.co.in 

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Pawan Dalmia
  INET: Pawan.Dalmia_at_orange.co.in

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).