Oracle 10g的RAC 在线日志也放在共享磁盘上,居然有两个当前状态,单实例下一般是三组日志,一组当前,一组活动,另外一组无效状态.
Oracle 10g的RAC 在线日志也放在共享磁盘上
[日期：2012-09-26] 来源：Linux社区 作者：ZengMuAnSha [字体：]
ASMCMD> pwd
data/myrac/onlinelog
ASMCMD> ls -ls
Type Redund Striped Time Sys Block_Size Blocks Bytes Space Name
ONLINELOG UNPROT FINE SEP 25 18:00:00 Y 512 102401 52429312 58720256 group_1.257.772910379
ONLINELOG UNPROT FINE SEP 25 18:00:00 Y 512 102401 52429312 58720256 group_2.258.772910389
ONLINELOG UNPROT FINE SEP 26 14:00:00 Y 512 102401 52429312 58720256 group_3.265.772919275
ONLINELOG UNPROT FINE SEP 26 14:00:00 Y 512 102401 52429312 58720256 group_4.266.772919281
很惊讶,原以为每个实例的在线日志文件存放在每个实例下的本地目录下.
在数据库实例上查,ASM实例查不到
SQL> select group#,thread#,sequence#,members,status from v$log;
GROUP# THREAD# SEQUENCE# MEMBERS STATUS
---------- ---------- ---------- ---------- ----------------
1 1 87 1 CURRENT
2 1 86 1 INACTIVE
3 2 43 1 CURRENT
4 2 42 1 INACTIVE
居然有两个当前状态,单实例下一般是三组日志,一组当前,一组活动,另外一组无效状态. 如今四组 嘿嘿!
从THREAD#线程号可以区分是属于哪个实例的!
SQL> select group#,member from V$logfile;
GROUP# MEMBER
--------------------------------------------------------------------------------
1 DATA/myrac/onlinelog/group_1.257.772910379
2 DATA/myrac/onlinelog/group_2.258.772910389
3 DATA/myrac/onlinelog/group_3.265.772919275
4 DATA/myrac/onlinelog/group_4.266.772919281
从V$logfile来看各个文件归宿
下一步给每个实例增加一组日志 2组日志实在不够用,有些危险!
