更改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;
问题解决。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/14184018/viewspace-692550/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/14184018/viewspace-692550/