RAC 添加redo log group

 

策略：每个组的日志大小默认是50M每个，如果写入或者更新很频繁的库，建议改大日志文件的大小。

每个日志组最好要有两个以上的成员。

----------

select * from v$log ;

select * from v$logfile ;

--------

------

---删除日志组：

alter database drop logfile group 19;

alter system switch logfile;  ---日志切换

alter system checkpoint ;  --- 将active 的日志变为 inactive

------

---要求：每个节点6个组，每个组两个成员

 alter database add logfile thread 1 group 19  size XXXXXXXXX;

 alter database add logfile thread 2 group 29  size XXXXXXXXX;

 alter database add logfile thread 3 group 39  size XXXXXXXXX;

----

--节点1：

/*alter database add logfile thread 1 group 19('+DATA_DG/querydb/redo19_1.log','+DATA_DG/querydb/redo19_2.log') size 1024m;

alter database add logfile thread 1 group 20('+DATA_DG/querydb/redo20_1.log','+DATA_DG/querydb/redo20_2.log') size 1024m;*/

alter database add logfile thread 1 group 1('+DATA_DG/querydb/redo01_1.log','+DATA_DG/querydb/redo01_2.log') size 1024m;

alter database add logfile thread 1 group 2('+DATA_DG/querydb/redo02_1.log','+DATA_DG/querydb/redo02_2.log') size 1024m;

alter database add logfile thread 1 group 3('+DATA_DG/querydb/redo03_1.log','+DATA_DG/querydb/redo03_2.log') size 1024m;

alter database add logfile thread 1 group 4('+DATA_DG/querydb/redo04_1.log','+DATA_DG/querydb/redo04_2.log') size 1024m;

alter database add logfile thread 1 group 5('+DATA_DG/querydb/redo05_1.log','+DATA_DG/querydb/redo05_2.log') size 1024m;

alter database add logfile thread 1 group 6('+DATA_DG/querydb/redo06_1.log','+DATA_DG/querydb/redo06_2.log') size 1024m;

----

---节点2：

--alter database add logfile thread 2 group 7('+DATA_DG/querydb/redo07_1.log','+DATA_DG/querydb/redo07_2.log') size 1024m;

--alter database add logfile thread 2 group 8('+DATA_DG/querydb/redo08_1.log','+DATA_DG/querydb/redo08_2.log') size 1024m;

--alter database add logfile thread 2 group 9('+DATA_DG/querydb/redo09_1.log','+DATA_DG/querydb/redo09_2.log') size 1024m;

--alter database add logfile thread 2 group 10('+DATA_DG/querydb/redo10_1.log','+DATA_DG/querydb/redo10_2.log') size 1024m;

--alter database add logfile thread 2 group 11('+DATA_DG/querydb/redo11_1.log','+DATA_DG/querydb/redo11_2.log') size 1024m;

--alter database add logfile thread 2 group 12('+DATA_DG/querydb/redo12_1.log','+DATA_DG/querydb/redo12_2.log') size 1024m;

-----节点3：

/*alter database add logfile thread 3 group 13('+DATA_DG/querydb/redo13_1.log','+DATA_DG/querydb/redo13_2.log') size 1024m;

alter database add logfile thread 3 group 14('+DATA_DG/querydb/redo14_1.log','+DATA_DG/querydb/redo14_2.log') size 1024m;

alter database add logfile thread 3 group 15('+DATA_DG/querydb/redo15_1.log','+DATA_DG/querydb/redo15_2.log') size 1024m;

alter database add logfile thread 3 group 16('+DATA_DG/querydb/redo16_1.log','+DATA_DG/querydb/redo16_2.log') size 1024m;

alter database add logfile thread 3 group 17('+DATA_DG/querydb/redo17_1.log','+DATA_DG/querydb/redo17_2.log') size 1024m;

alter database add logfile thread 3 group 18('+DATA_DG/querydb/redo18_1.log','+DATA_DG/querydb/redo18_2.log') size 1024m;*/