Oracle 10g的RAC 在线日志也放在共享磁盘上

Oracle 10g的RAC 在线日志也放在共享磁盘上

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