Hi Dorlon,jsuri,

LOGFILE
GROUP 1 (
'/hfs/oracle/disk04/oradata/AGI/redoAGI_101.log',
'/hfs/oracle/disk03/oradata/AGI/redoAGI_102.log'
) SIZE 500k,
GROUP 2 (
'/hfs/oracle/disk04/oradata/AGI/redoAGI_201.log',
'/hfs/oracle/disk03/oradata/AGI/redoAGI_202.log'
) SIZE 500k,
GROUP 3 (
'/hfs/oracle/disk04/oradata/AGI/redoAGI_301.log',
'/hfs/oracle/disk03/oradata/AGI/redoAGI_302.log'
) SIZE 500k

These are the redo logs i have in the production database. You told me to create new redolog groups,

ALTER DATABASE AGI
ADD LOGFILE
GROUP 4 (
'/hfs/oracle/disk04/oradata/AGI/redoAGI_401.log',
'/hfs/oracle/disk03/oradata/AGI/redoAGI_402.log'
) SIZE 2M,
GROUP 5 (
'/hfs/oracle/disk04/oradata/AGI/redoAGI_501.log',
'/hfs/oracle/disk03/oradata/AGI/redoAGI_502.log'
) SIZE 2M,
GROUP 6 (
'/hfs/oracle/disk04/oradata/AGI/redoAGI_601.log',
'/hfs/oracle/disk03/oradata/AGI/redoAGI_602.log'
) SIZE 2M;

Then Force a couple of log switches so that the current redo log is one of the 2M ones.


ALTER SYSTEM SWITCH LOGFILE;

Now the group 4 is current and all other 5 groups are not active
then

alter database agi
drop logfile group 1;

alter database agi
drop logfile group 2;

alter database agi
drop logfile group 3;

I am assuming that these are the steps i have to follow. This database is on production, so any other steps i have to cosider?