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 >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Resizing of redo log
Hi Pawan, You should create a new redo log group with a bigger size then drop an old redo group with INACTIVE status (v$log) and repeate this procedure once again for each substituted redo log group. You can control status of a substituted redo log by using ALTER SYSTEM SWITCH LOGFILE; Regards, Ed > > > > > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Edward Shevtsov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Resizing of redo log
Pawan Dalmia wrote: > > How is it possible to increase the size og online redo log files > > Regards > Pawan Dalmia > > -- A script-of-death does it in the X-rated section of the Oriole site (http://www.oriole.com). I guess that reading it carefully should answer most of your questions. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Resizing of redo log
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 >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Resizing of redo log
You must create other groups, make alter system switch logfile (until CURRENT is one of the new), and delete old groups. You can change log_checkpoint_interval and log_checkpoint_timeout. Use Enterprise Manager. It´s easy. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Pawan Dalmia Enviado el: martes, 27 de agosto de 2002 13:18 Para: Multiple recipients of list ORACLE-L Asunto: Resizing of redo log 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Juan Miranda INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Resizing of redo log
Pawan Dalmia, hi, the only way to resize the redo log file is to add new log group with bigger size and drop the old one. You can look at oracle administrator's guide chapter 6 for detailed instructions. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] === 2002-08-27 03:18:00 ,you wrote£º=== >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: [EMAIL PROTECTED] > >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: [EMAIL PROTECTED] (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). = = = = = = = = = = = = = = = = = = = = zhu chao [EMAIL PROTECTED] 2002-08-27 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zhu chao INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).