这两天oracle rac1报错:oracle instance rac1 - cannot allocate log,archival required.
之后查看日志组
select * from v$log;
================
group thread size
1 1 1024m
2 1 1024m
3 2 1024m
4 2 1024m
之后执行添加命令
alter database add logfile thread 1 group 5;
alter database add logfile thread 2 group 6;
之后查看日志组
select * from v$log;
================
group thread size
1 1 1024m
2 1 1024m
3 2 1024m
4 2 1024m
之后执行添加命令
alter database add logfile thread 1 group 5;
alter database add logfile thread 2 group 6;
发现默认大小是100M,这个是否影响数据库的后续恢复
参考资料:http://www.makeru.com.cn/