oracle 10g RAC添加日志组和成员以及删除日志成员
SQL> alter database add logfile thread 1 group5('+data/myrac/onlinelog/myrac1_redolog_group5_01') size 100m;
SQL> alter database add logfile member '+data/myrac/onlinelog/myrac1_redolog_group5_02' to group 5;
SQL> alter database add logfile thread 2 group 6('+data/myrac/onlinelog/myrac1_redolog_group6_01')size 100m;
手误 添加错了名字
先增加成员再说
SQL> alter database add logfile member '+data/myrac/onlinelog/myrac1_redolog_group6_02' to group 6;
SQL> alter database add logfile member '+data/myrac/onlinelog/myrac1_redolog_group6_01' to group 6;
删除不了
SQL> alter database drop logfile member'+DATA/myrac/onlinelog/myrac1_redolog_group6_01';
alter database drop logfile member'+DATA/myrac/onlinelog/myrac1_redolog_group6_01'
* www.2cto.com
第 1 行出现错误:
ORA-00362: 要求输入成员以组成组 6 中的有效日志文件
ORA-01517: 日志成员: '+DATA/myrac/onlinelog/myrac1_redolog_group6_01'
日志状态 未使用当中啊!
SQL> select group#,archived,status from v$log;
GROUP# ARC STATUS
---------- --- ----------------
1 NO ACTIVE
2 NO INACTIVE
3 NO CURRENT
4 NO INACTIVE
5 NO CURRENT
6 YES UNUSED
已选择6行。
在节点2 实例2
数据库实例上 切换日志
SQL> alter system switch logfile;
SQL> /
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------------------- ------------- --------------
1 1 87 52428800 1 NO INACTIVE 4427645 25-9月 -12
2 1 86 52428800 1 NO INACTIVE 4356268 25-9月 -12
3 2 43 52428800 1 NO ACTIVE 4402972 25-9月 -12
4 2 42 52428800 1 NO INACTIVE 4206757 24-9月 -12
5 1 88 104857600 2 NO CURRENT 4495802 26-9月 -12
6 2 44 104857600 3 NO CURRENT 4497190 26-9月 -12
www.2cto.com
已选择6行。
SQL> alter system switch logfile;
SQL> /
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------------------- ------------- --------------
1 1 87 52428800 1 NO INACTIVE 4427645 25-9月 -12
2 1 86 52428800 1 NO INACTIVE 435626825-9月 -12
3 2 43 52428800 1 NO ACTIVE 4402972 25-9月 -12
4 2 45 52428800 1 NO CURRENT 4497215 26-9月 -12
5 1 88 104857600 2 NO CURRENT 4495802 26-9月 -12
6 2 44 104857600 3 NO ACTIVE 4497190 26-9月 -12
已选择6行。
SQL> alter system switch logfile;
SQL> /
GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIME
---------- ---------- ---------- ---------- ---------- ------------------- ------------- -------------- www.2cto.com
1 1 87 52428800 1 NO INACTIVE 4427645 25-9月 -12
2 1 86 52428800 1 NO INACTIVE 4356268 25-9月 -12
3 2 46 52428800 1 NO CURRENT 4497279 26-9月 -12
4 2 45 52428800 1 NO INACTIVE 449721526-9月 -12