oracle加redo,ORACLE redo日志组添加方法

alter database add logfile thread 1  group 1 size 512M;

alter database add logfile thread 2  group 2 size 512M;

alter database add logfile thread 1  group 3 size 512M;

alter database add logfile thread 2  group 4 size 512M;

alter database add logfile thread 1  group 5 size 512M;

alter database add logfile thread 2  group 6 size 512M;

alter database add logfile thread 1  group 7 size 512M;

alter database add logfile thread 2  group 8 size 512M;

alter database add logfile thread 1  group 9 size 512M;

alter database add logfile thread 2  group 10 size 512M;

alter database add logfile thread 1 size 512M;

alter database add logfile thread 2 size 512M;

alter database add logfile thread 1 size 512M;

alter database add logfile thread 2 size 512M;

alter database add logfile thread 1 size 512M;

alter database add logfile thread 2 size 512M;

alter database drop logfile group 1;

alter database drop logfile group 2;

alter database drop logfile group 3;

alter database drop logfile group 4;

alter database drop logfile group 11;

alter database drop logfile group 12;

alter database drop logfile group 13;

alter database drop logfile group 14;

alter database drop logfile group 15;

alter database drop logfile group 16;

alter database drop logfile group 17;

alter database drop logfile group 18;

alter database drop logfile group 19;

alter database drop logfile group 20;

alter database drop logfile group 21;

alter database drop logfile group 22;