查看日志和日志文件信息:
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;
问题解决。