调整日志组

1.查看,一共10组，每个线程5组，每个文件1G

SQL> select group#,THREAD#,sequence#,bytes/1024/1024,status,MEMBERS from v$log;

GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARCHIVED STATUS
---------- ---------- ---------- ---------- ---------- ---------- --------- ------------
71 1 1062357 1073741824 512 1 YES INACTIVE
72 1 1062358 1073741824 512 1 YES INACTIVE
73 1 1062359 1073741824 512 1 NO CURRENT
74 1 1062355 1073741824 512 1 YES INACTIVE
75 1 1062356 1073741824 512 1 YES INACTIVE
81 2 1016205 1073741824 512 1 YES INACTIVE
82 2 1016206 1073741824 512 1 YES INACTIVE
83 2 1016207 1073741824 512 1 YES INACTIVE
84 2 1016208 1073741824 512 1 NO CURRENT
85 2 1016204 1073741824 512 1 YES INACTIVE

10 rows selected.

set linesize 200 pagesize 200
col MEMBER for a90
select * from v$logfile;

2.按照需求添加

alter database add logfile thread 1 group 11('+DATA','+DATA') size 1G;
alter database add logfile thread 1 group 12('+DATA','+DATA') size 1G;
alter database add logfile thread 1 group 13('+DATA','+DATA') size 1G;
alter database add logfile thread 1 group 14('+DATA','+DATA') size 1G;
alter database add logfile thread 1 group 15('+DATA','+DATA') size 1G;

alter database add logfile thread 2 group 21('+DATA','+DATA') size 1G;
alter database add logfile thread 2 group 22('+DATA','+DATA') size 1G;
alter database add logfile thread 2 group 23('+DATA','+DATA') size 1G;
alter database add logfile thread 2 group 24('+DATA','+DATA') size 1G;
alter database add logfile thread 2 group 25('+DATA','+DATA') size 1G;

 

3.切换归档

alter system archive log current;
alter system checkpoint;（默认是local，如果是rac环境：加上global参数）
alter system checkpoint global;

4.删除原来的日志文件

alter database drop logfile group 1;
alter database drop logfile group 2;
alter database drop logfile group 3;
alter database drop logfile group 4;

5.调整后确认

SQL> select group#,THREAD#,sequence#,bytes/1024/1024,status from v$log;

GROUP# THREAD# SEQUENCE# BYTES/1024/1024 STATUS