Oracle10g的RAC在线日志也放在共享磁盘上

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组日志实在不够用,有些危险!