首先我们必须知道ASM实例的alert日志位置,ASM实例的alert日志默认路径为:/u01/app/grid/diag/asm/+asm/+ASM1/trace/alert_+ASM1.log,在该日志里面告诉了我们非常重要的信息,以下几个实际应用场景。
1、ASM的alert日志作为ASM实例的晴雨表,向我们展示了ASM实例的“健康状态”。
2、ASM的alert日志告诉了我们创建磁盘组时候的操作系统块设备和ASM 磁盘的对应关系。例如:/dev/sdb1 和ASMDISK1对应。
以下为ASM实例的alert日志实际输出:
Tue Jun 16 19:27:14 2015
SQL> CREATE DISKGROUP DATA NORMAL REDUNDANCY DISK 'ORCL:ASMDISK1',
'ORCL:ASMDISK2',
'ORCL:ASMDISK3',
'ORCL:ASMDISK4' ATTRIBUTE 'compatible.asm'='11.2.0.0.0','au_size'='1M' /* ASMCA */
NOTE: Assigning number (1,0) to disk (ORCL:ASMDISK1)
NOTE: Assigning number (1,1) to disk (ORCL:ASMDISK2)
NOTE: Assigning number (1,2) to disk (ORCL:ASMDISK3)
NOTE: Assigning number (1,3) to disk (ORCL:ASMDISK4)
NOTE: initializing header on grp 1 disk ASMDISK1
NOTE: initializing header on grp 1 disk ASMDISK2
NOTE: initializing header on grp 1 disk ASMDISK3
NOTE: initializing header on grp 1 disk ASMDISK4
GMON updating for reconfiguration, group 1 at 3 for pid 23, osid 1888
NOTE: group 1 PST updated.
NOTE: initiating PST update: grp = 1
GMON updating group 1 at 4 for pid 23, osid 1888
NOTE: group DATA: initial PST location: disk 0000 (PST copy 0)
NOTE: group DATA: initial PST location: disk 0001 (PST copy 1)
NOTE: group DATA: initial PST location: disk 0002 (PST copy 2)
NOTE: PST update grp = 1 completed successfully
NOTE: cache registered group DATA number=1 incarn=0x15f22f86
NOTE: cache began mount (first) of group DATA number=1 incarn=0x15f22f86
NOTE: cache opening disk 0 of grp 1: ASMDISK1 label:ASMDISK1
NOTE: cache opening disk 1 of grp 1: ASMDISK2 label:ASMDISK2
NOTE: cache opening disk 2 of grp 1: ASMDISK3 label:ASMDISK3
NOTE: cache opening disk 3 of grp 1: ASMDISK4 label:ASMDISK4
* allocate domain 1, invalid = TRUE
NOTE: attached to recovery domain 1
NOTE: cache creating group 1/0x15F22F86 (DATA)
NOTE: cache mounting group 1/0x15F22F86 (DATA) succeeded
NOTE: allocating F1X0 on grp 1 disk ASMDISK1
NOTE: allocating F1X0 on grp 1 disk ASMDISK2
NOTE: allocating F1X0 on grp 1 disk ASMDISK3
NOTE: Created Used Space Directory for 1 threads
NOTE: diskgroup must now be re-mounted prior to first use
NOTE: cache dismounting (clean) group 1/0x15F22F86 (DATA)
NOTE: messaging CKPT to quiesce pins Unix process pid: 1888, image: oracle@racdb1 (TNS V1-V3)
NOTE: lgwr not being msg'd to dismount
freeing rdom 1
NOTE: detached from domain 1
NOTE: cache dismounted group 1/0x15F22F86 (DATA)
GMON dismounting group 1 at 5 for pid 23, osid 1888
GMON dismounting group 1 at 6 for pid 23, osid 1888
NOTE: Disk ASMDISK1 in mode 0x7f marked for de-assignment
NOTE: Disk ASMDISK2 in mode 0x7f marked for de-assignment
NOTE: Disk ASMDISK3 in mode 0x7f marked for de-assignment
NOTE: Disk ASMDISK4 in mode 0x7f marked for de-assignment
SUCCESS: diskgroup DATA was created
3、ASM的alert日志告诉了我们ASM实例使用的参数文件spfile路径和文件名。
以下为ASM实例的alert日志实际输出:
NOTE: Advanced to new COD format for group DATA
NOTE: updated gpnp profile ASM diskstring:
NOTE: updated gpnp profile ASM SPFILE to +DATA/db-cluster/asmparameterfile/registry.253.882559645
Tue Jun 16 19:27:26 2015
4、ASM的alert日志告诉了我们RAC下心跳网络的网卡和IP地址信息、MAC地址等。
以下为ASM实例的alert日志实际输出:
Private Interface 'em3:1' configured from GPnP for use as a private interconnect.
[name='em3:1', type=1, ip=169.254.31.158, mac=b8-2a-72-e0-18-3b, net=169.254.0.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Private Interface 'em4:1' configured from GPnP for use as a private interconnect.
[name='em4:1', type=1, ip=169.254.167.137, mac=b8-2a-72-e0-18-3c, net=169.254.128.0/17, mask=255.255.128.0, use=haip:cluster_interconnect/62]
Public Interface 'em1' configured from GPnP for use as a public interface.
[name='em1', type=1, ip=172.28.254.31, mac=b8-2a-72-e0-18-39, net=172.28.254.0/24, mask=255.255.255.0, use=public/1]
CELL communication is configured to use 0 interface(s):
CELL IP affinity details:
NUMA status: NUMA system w/ 2 process groups
cellaffinity.ora status: cannot find affinity map at '/etc/oracle/cell/network-config/cellaffinity.ora' (see trace file for details)
CELL communication will use 1 IP group(s):
Grp 0:
Picked latch-free SCN scheme 3
Using LOG_ARCHIVE_DEST_1 parameter default value as /u01/app/11.2.0/grid/dbs/arch
5、ASM的alert日志告诉了我们voting文件在具体位置
以下为ASM实例的alert日志实际输出:
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA
. Found 3 voting file(s).
NOTE: Voting file relocation is required in diskgroup DATA
NOTE: Attempting voting file relocation on diskgroup DATA
NOTE: Successful voting file relocation on diskgroup DATA
NOTE: Attempting voting file refresh on diskgroup DATA
NOTE: Refresh completed on diskgroup DATA
. Found 3 voting file(s).
阅读(2422) | 评论(0) | 转发(0) |