Home » RDBMS Server » Server Administration » resize logfile (merged)
resize logfile (merged) [message #292616] Wed, 09 January 2008 07:01 Go to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi,

can anybody tell me the steps to resize an online logfile??.

Regards,
Balaji
Re: Resizing Logfile [message #292620 is a reply to message #292616] Wed, 09 January 2008 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't resize logfile, you have to create new ones and drop the old ones.

Regards
Michel
resize logfile [message #294521 is a reply to message #292616] Thu, 17 January 2008 22:11 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

hi all,

can anybody tell me the steps to resize an existing logfile??

/oradata/datafile/stbyorcl/redo01.log 50M.


Thanks & Regards,
Balaji
Re: resize logfile [message #294575 is a reply to message #294521] Fri, 18 January 2008 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't, you have to create a new log and drop the previous one.

By the way, redo logs should be multiplexed.

Regards
Michel
Re: resize logfile [message #294690 is a reply to message #294575] Fri, 18 January 2008 08:09 Go to previous messageGo to next message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Was the answer supplied last week (which is the same answer you got this week and next week) not clear enough?
Re: resize logfile [message #294815 is a reply to message #294690] Sat, 19 January 2008 08:05 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member



i want the steps please....
Re: resize logfile [message #294818 is a reply to message #294815] Sat, 19 January 2008 08:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What don't you understand in the answer?
Explain.

Regards
Michel
Re: resize logfile [message #294826 is a reply to message #294818] Sat, 19 January 2008 14:30 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

yeah i understood.

Thanks... Smile
Re: resize logfile (merged) [message #294862 is a reply to message #292616] Sun, 20 January 2008 04:40 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

What you understood?
Re: resize logfile (merged) [message #295323 is a reply to message #294862] Tue, 22 January 2008 02:19 Go to previous messageGo to next message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

what i should to undestand...
Re: resize logfile (merged) [message #295389 is a reply to message #292616] Tue, 22 January 2008 04:23 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member


Balaji please follow following steeps for resizing or recreating Online your Redo Log Files.Why you want to do it, I don't know, but I believe you must be having your own reasons.But before you begin ensure your database is not experiencing heavy traffic or do it at the time of least traffic probably at night [with peace at your alongside].

Step-I: have a look at your current log groups/members:

SELECT a.group#, a.member, b.bytes
FROM v$logfile a, v$log b WHERE a.group# = b.group#;


Step-II : Force a manual checkpoint i.e. ALTER SYSTEM CHECKPOINT GLOBAL; in order to avoid recovery related errors.

Step-III : Make your last redolog group as current [very important] by using manual log switch until you get desired result.

alter system switch logfile;

select group#, status from v$log;

    GROUP# STATUS
---------- ----------------
         1 INACTIVE
         2 INACTIVE
         3 INACTIVE
         4 CURRENT


Step-IV : After making the last group as current start dropping the groups one by one beginning from group number 1. Do it for all except the last group which has been recently made current.If you get any recovery related 312/624 error than carry out a fresh manual checkpoint and proceed again to drop the group.

alter database drop logfile group 1;


Step-V : Recreate your new loggroups with desired sizes & locations. Ensure you do not create any thing below minimum size [10g : minimum 4Mb, default 50Mb, OMF 100MB]. Ensure a correct log size as it may impact your database performance. Create number of groups as desired

alter database add logfile group 1 (
   'path/member1.log',  
   'path/member2.log') size 500M reuse;


Step-VI: Carry out a manual log switch. See that newly created group becomes current. Carry out manual checkpoint & log switch until your last old log(the only one left) becomes inactive than drop it.Veryfy new logs. If you are using RMAN than rman may search for dropped logfiles during your next backup.

Regards

Manjit Kumar [mkbhati]







Re: resize logfile (merged) [message #295411 is a reply to message #295389] Tue, 22 January 2008 05:08 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
- Checkpoint is not necessary
- add BEFORE drop, it is safer in case you could not add for one reason or another one.

Regards
Michel
Re: resize logfile (merged) [message #295448 is a reply to message #292616] Tue, 22 January 2008 06:21 Go to previous messageGo to next message
mkbhati
Messages: 93
Registered: February 2007
Location: Mumbai
Member

Thanks Michel

Regards

Manjit Kumar [mkbhati]
Re: resize logfile (merged) [message #335759 is a reply to message #295448] Wed, 23 July 2008 10:53 Go to previous message
balaji1482
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Thanks Manjit Kumar [mkbhati] for providing such useful steps to resize logfile.
Previous Topic: checking the status of oracle remotely
Next Topic: Auto Start Oracle 10G on windows 2003 Server
Goto Forum:
  


Current Time: Thu Dec 08 00:28:22 CST 2016

Total time taken to generate the page: 0.09643 seconds