默认的redolog位置是db_create_file_dest【+DATA】和db_recovery_file_dest【+FRA】，如果redolog设置较大，则需要同时设置较大的FRA。
由于FRA设置的较小是6G，而redolog设置了4组，每组2G，导致instance 2的redolog未能创建，进而导致instance 2未能启动。
需要增加instance 2的redolog。
select * from v$Log;
GROUP# THREAD# SEQUENCE# BYTES BLOCKSIZE MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME NEXT_CHANGE# NEXT_TIME
---------- ---------- ---------- ---------- ---------- ---------- --- ---------- ------------- ----------------- ------------ -----------------
1 1 3 2097152000 512 2 NO CURRENT 1085027 16-04-30 18:04:24 2.8147E+14
2 1 2 2097152000 512 2 YES INACTIVE 691910 16-04-29 15:46:47 1085027 16-04-30 18:04:24
select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_
---------- ---------- ------- -------------------------------------------------------------------------------- ---
1 ONLINE +DATA/dzgddb/onlinelog/group_1.257.910452793 NO
1 ONLINE +FRA/dzgddb/onlinelog/group_1.257.910452797 YES
2 ONLINE +DATA/dzgddb/onlinelog/group_2.258.910452801 NO
2 ONLINE +FRA/dzgddb/onlinelog/group_2.258.910452803 YES
可见目前只有2个redolog group，而且都是thread 1的，需要增加thread 2的onlinelog。
在节点1上给节点2建立2个日志组
alter database add logfile thread 2 size 2g;
alter database add logfile thread 2 size 2g;
alter database enable thread 2;
如下对每个实例再增加一组logfile：
alter database add logfile thread 1 size 2g;
alter database add logfile thread 2 size 2g;
文章评论