Sunday, March 22, 2009

Resize Redolog Groups in Oracle

Dear All,

Buy product that make a difference SAVE ENERGY
exit signs


Here is the procedure to resize the redo log group in SAP/Oracle
To check all Redolog files Run command:
Select * from v$log;

Now add a group, To add a log group
Alter database add logfile group 5 ('/oracle/SID/origlogA/log_g15m1.dbf','/oracle/SID/mirrlogA/log_g15m2.dbf') size 200M;

alter database add logfile group 6 ('/oracle/SID/origlogB/log_g16m1.dbf','/oracle/SID/mirrlogB/log_g16m2.dbf') size 200M;

alter database add logfile group 7 ('/oracle/SID/origlogA/log_g17m1.dbf','/oracle/SID/mirrlogA/log_g17m2.dbf') size 200M;


alter database add logfile group 8 ('/oracle/SID/origlogB/log_g18m1.dbf','/oracle/SID/mirrlogB/log_g18m2.dbf') size 200M;

After these commands, Force System for log switch
Alter system switch logfile;
Drop Existing Log groups files (Make sure no group has status active or current)
Alter database drop logfile group 1;
Alter database drop logfile group 2;
Alter database drop logfile group 3;
Alter database drop logfile group 4;

Remove these files from OS level
Now again add same Group

Buy product that make a difference SAVE ENERGY

Exit Sign


alter database add logfile group 1 ('/oracle/SID/origlogA/log_g11m1.dbf','/oracle/SID/mirrlogA/log_g11m2.dbf') size 200M;

alter database add logfile group 2 ('/oracle/SID/origlogB/log_g12m1.dbf','/oracle/SID/mirrlogB/log_g12m2.dbf') size 200M;


alter database add logfile group 3 ('/oracle/SID/origlogA/log_g13m1.dbf','/oracle/SID/mirrlogA/log_g13m2.dbf') size 200M;


alter database add logfile group 4 ('/oracle/SID/origlogB/log_g14m1.dbf','/oracle/SID/mirrlogB/log_g14m2.dbf') size 200M;


We can drop Log group 5,6,7,8
In case any of these groups are Active or current stage use “Alter system switch logfile"
Alter database drop logfile group 5;
Alter database drop logfile group 6;
Alter database drop logfile group 7;
Alter database drop logfile group 8;

CHEERSSSSSSSS

Buy product that make a difference SAVE ENERGY
exit signs



Regards,
Gagan Deep Kaushal

2 comments:

Isrrael Flores said...

Hi Gagan,

This article it's very helpfull, I'm Isrrael and I'm from Mexico, I'm working at Softtek, and I try to read every week ur blog, 'cause u write very good articles.

Regards
Isrrael Flores

Gagan Deep Kaushal said...

Hi lsrrael,


Thanks , i will try to keep this blog updated ...I may not be able to post any thing new for next few weeks.....will come back soon ....


Regards,
Gagan

Post a Comment