Oracle RACDB 增加、删除 在线重做日志组
select * from v$log;
select * from v$logfile ;
----删除日志组：
alter database drop logfile group 19;
-- 日志切换
alter system switch logfile; —日志切换
alter system checkpoint ; — 将active 的日志变为 inactive
-- 增加日志组
----要求：每个节点6个组，每个组两个成员
----节点1：
--alter database add logfile thread 1 group 19('+DATA_DG/racdb/redo1_19_1.log','+DATA_DG/racdb/redo1_19_2.log') size 1024m;
--alter database add logfile thread 1 group 20('+DATA_DG/racdb/redo1_20_1.log','+DATA_DG/racdb/redo1_20_2.log') size 1024m;
alter database add logfile thread 1 group 1 ('+DATA_DG/racdb/redo1_01_1.log','+DATA_DG/racdb/redo1_01_2.log') size 1024m;
alter database add logfile thread 1 group 2 ('+DATA_DG/racdb/redo1_02_1.log','+DATA_DG/racdb/redo1_02_2.log') size 1024m;
alter database add logfile thread 1 group 3 ('+DATA_DG/racdb/redo1_03_1.log','+DATA_DG/racdb/redo1_03_2.log') size 1024m;
alter database add logfile thread 1 group 4 ('+DATA_DG/racdb/redo1_04_1.log','+DATA_DG/racdb/redo1_04_2.log') size 1024m;
alter database add logfile thread 1 group 5 ('+DATA_DG/racdb/redo1_05_1.log','+DATA_DG/racdb/redo1_05_2.log') size 1024m;
alter database add logfile thread 1 group 6 ('+DATA_DG/racdb/redo1_06_1.log','+DATA_DG/racdb/redo1_06_2.log') size 1024m;
--节点2：
alter database add logfile thread 2 group 7 ('+DATA_DG/racdb/redo2_07_1.log','+DATA_DG/racdb/redo2_07_2.log') size 1024m;
alter database add logfile thread 2 group 8 ('+DATA_DG/racdb/redo2_08_1.log','+DATA_DG/racdb/redo2_08_2.log') size 1024m;
alter database add logfile thread 2 group 9 ('+DATA_DG/racdb/redo2_09_1.log','+DATA_DG/racdb/redo2_09_2.log') size 1024m;
alter database add logfile thread 2 group 10 ('+DATA_DG/racdb/redo2_10_1.log','+DATA_DG/racdb/redo2_10_2.log') size 1024m;
alter database add logfile thread 2 group 11 ('+DATA_DG/racdb/redo2_11_1.log','+DATA_DG/racdb/redo2_11_2.log') size 1024m;
alter database add logfile thread 2 group 12 ('+DATA_DG/racdb/redo2_12_1.log','+DATA_DG/racdb/redo2_12_2.log') size 1024m;
--节点3：
alter database add logfile thread 3 group 13 ('+DATA_DG/racdb/redo3_13_1.log','+DATA_DG/racdb/redo3_13_2.log') size 1024m;
alter database add logfile thread 3 group 14 ('+DATA_DG/racdb/redo3_14_1.log','+DATA_DG/racdb/redo3_14_2.log') size 1024m;
alter database add logfile thread 3 group 15 ('+DATA_DG/racdb/redo3_15_1.log','+DATA_DG/racdb/redo3_15_2.log') size 1024m;
alter database add logfile thread 3 group 16 ('+DATA_DG/racdb/redo3_16_1.log','+DATA_DG/racdb/redo3_16_2.log') size 1024m;
alter database add logfile thread 3 group 17 ('+DATA_DG/racdb/redo3_17_1.log','+DATA_DG/racdb/redo3_17_2.log') size 1024m;
alter database add logfile thread 3 group 18 ('+DATA_DG/racdb/redo3_18_1.log','+DATA_DG/racdb/redo3_18_2.log') size 1024m;
--增加日志成员
alter database add logfile member '/oradata/oggtdb/redo1_04_02.log' to group 4 ;
--alter database add logfile member '/oradata/oggtdb/redo1_04_02.log' reuse to group 4 ;
--删除日志组成员
----删除日志组成员的操作只对数据库进行更改，操作系统的文件尚未删除
alter database drop logfile member '/oradata/oggtdb/redo1_04_02.log';
附：
ALTER DATABASE 语法DOC
https://docs.oracle.com/database/121/SQLRF/statements_1006.htm#SQLRF00802
alter_database::=
logfile_clauses ::=
