oracle rac 数据库大小,更改RAC数据库日志文件大小及数量 for ASM

查看日志和日志文件信息：

select b.THREAD#,a.GROUP#,a.STATUS,a.MEMBER,b.BYTES/1024/1024,b.ARCHIVED,b.STATUS

from v$logfile a,v$log b where a.GROUP#=b.GROUP#;

查询日志状态：

select group#,THREAD#,status,archived,bytes/1024/1024 from v$log;

1、每个节点各创建两个新的日志组

alter database add logfile thread 1 GROUP 5 size 200m;

alter database add logfile thread 1 group 6 size 200m;

alter database add logfile thread 2 group 7 size 200m;

alter database add logfile thread 2 group 8 size 200m;

2、切换日志组(rac1和rac2):

alter system switch logfile;

切换多次日志组后手工发起一个checkpint(rac1和rac2)：

alter system checkpoint;

3、在日志组不是active和current状态时删除掉日志组，取决于磁盘的速度，速度慢的可能切换后很长时间状态才改变，这个一定要确认好的。

alter database drop logfile group 1;

alter database drop logfile group 2;

alter database drop logfile group 3;

alter database drop logfile group 4;

4、添加1，2，3，4日志组

alter database add logfile thread 1 GROUP 1 size 200m;

alter database add logfile thread 1 group 2 size 200m;

alter database add logfile thread 2 group 3 size 200m;

alter database add logfile thread 2 group 4 size 200m;

5、多次切换日志组

alter system switch logfile;

6、删除中间过渡用的日志组5、6、7、8

alter database drop logfile group 5;

alter database drop logfile group 6;

alter database drop logfile group 7;

alter database drop logfile group 8;

7、添加一组日志组

alter database add logfile thread 3 GROUP 5 size 200m;

alter database add logfile thread 3 GROUP 6 size 200m;

8、备份当前的最新的控制文件

SQL> alter database backup controlfile to trace resetlogs；

问题解决。