RESIZING REDOLOG FILES
spool addlogfiles
select member from v$logfile;
select group# from v$log where status='ACTIVE';
-- note down the active redolog and make sure you are not deleting the active one.
ALTER DATABASE DROP LOGFILE GROUP 11 ;
ALTER DATABASE ADD LOGFILE GROUP 11
('/oracle/SID/origlogA/log_g11m1.dbf',
'/oracle/SID/mirrlogA/log_g11m2.dbf') SIZE 200M REUSE;
ALTER DATABASE DROP LOGFILE GROUP 13 ;
ALTER DATABASE ADD LOGFILE GROUP 13
('/oracle/SID/origlogA/log_g13m1.dbf',
'/oracle/SID/mirrlogA/log_g13m2.dbf') SIZE 200M REUSE;
select group# from v$log where status='ACTIVE';
ALTER DATABASE DROP LOGFILE GROUP 15 ;
ALTER DATABASE ADD LOGFILE GROUP 15
('/oracle/SID/origlogA/log_g15m1.dbf',
'/oracle/SID/mirrlogA/log_g15m2.dbf') SIZE 200M REUSE;
select group# from v$log where status='ACTIVE';
ALTER DATABASE ADD LOGFILE GROUP 17
('/oracle/SID/origlogA/log_g17m1.dbf',
'/oracle/SID/mirrlogA/log_g17m2.dbf') SIZE 200M;
select group# from v$log where status='ACTIVE';
ALTER DATABASE DROP LOGFILE GROUP 12 ;
ALTER DATABASE ADD LOGFILE GROUP 12
('/oracle/SID/origlogB/log_g12m1.dbf',
'/oracle/SID/mirrlogB/log_g12m2.dbf') SIZE 200M REUSE;
ALTER SYSTEM SWITCH LOGFILE;
select group# from v$log where status='ACTIVE';
ALTER DATABASE DROP LOGFILE GROUP 14 ;
ALTER DATABASE ADD LOGFILE GROUP 14
('/oracle/SID/origlogB/log_g14m1.dbf',
'/oracle/SID/mirrlogB/log_g14m2.dbf') SIZE 200M REUSE;
ALTER SYSTEM SWITCH LOGFILE;
select group# from v$log where status='ACTIVE';
ALTER DATABASE DROP LOGFILE GROUP 16 ;
ALTER DATABASE ADD LOGFILE GROUP 16
('/oracle/SID/origlogB/log_g16m1.dbf',
'/oracle/SID/mirrlogB/log_g16m2.dbf') SIZE 200M REUSE;
ALTER SYSTEM SWITCH LOGFILE;
select group# from v$log where status='ACTIVE';
ALTER DATABASE ADD LOGFILE GROUP 18
('/oracle/SID/origlogB/log_g18m1.dbf',
'/oracle/SID/mirrlogB/log_g18m2.dbf') SIZE 200M;