Logfile Re-Org

select INST_ID,GROUP#,THREAD#,BYTES/1024/1024 MB, status from gv$log order by 1,2,3;

select INST_ID,GROUP#,THREAD#,BYTES/1024/1024 MB, status from gv$log where status='CURRENT' order by 1,2,3;

alter database drop logfile group 111;

alter database drop logfile group 112;

alter database drop logfile group 113;

alter database drop logfile group 121;

alter database drop logfile group 122;

alter database drop logfile group 123;

alter database drop logfile group 131;

alter database drop logfile group 132;

alter database drop logfile group 133;

alter database add logfile thread 1 group 111 size 4G;

alter database add logfile thread 1 group 112 size 4G;

alter database add logfile thread 1 group 113 size 4G;

alter database add logfile thread 2 group 121 size 4G;

alter database add logfile thread 2 group 122 size 4G;

alter database add logfile thread 2 group 123 size 4G;

alter database add logfile thread 3 group 131 size 4G;

alter database add logfile thread 3 group 132 size 4G;

alter database add logfile thread 3 group 133 size 4G;