在虚拟机上添加共享磁盘后节点2的ASM实例无法加载到

在节点1用DBCA给ASM增加磁盘图形过程比较容易,新建了两个目录分别是ARCHLOG和BACKUP. 可不能装载节点2上面! [oracle@node2bdump]$ export ORACLE_SID=+ASM2 [oracle@node2bdump]$ asmcmd ASMCMDll commands: -------- cd du find help ls lsct lsdg mkalias

在节点1用DBCA给ASM增加磁盘图形过程比较容易,新建了两个目录分别是ARCHLOG和BACKUP. 可不能装载节点2上面!

[oracle@node2bdump]$ export ORACLE_SID=+ASM2

[oracle@node2bdump]$ asmcmd

ASMCMD>ll

        commands:

        -------- 

        cd

        du

        find

        help

        ls

        lsct

        lsdg

        mkalias

        mkdir

        pwd

        rm

        rmalias

ASMCMD>ls

ARCHLOG/

BACKUP/

DATA/

ASMCMD>cd DATA

ASMCMD>ls

MYRAC/

ASMCMD>cd ..

ASMCMD>cd ARCHLOG

无法进入该目录

启动ASM实例

SQL>startup

ORA-32004:obsolete and/or deprecated parameter(s) specified

ASMinstance started

 

TotalSystem Global Area   92274688 bytes

FixedSize                  1217884 bytes

VariableSize              65890980 bytes

ASMCache                  25165824 bytes

ORA-15032:not all alterations performed

ORA-15003:diskgroup "DATA" already mounted in another lock name space

ORA-15003:diskgroup "BACKUP" already mounted in another lock name space

ORA-15003:diskgroup "ARCHLOG" already mounted in another lock name space

ASM实例已经存在

 

[oracle@node2dbs]$ ps -ef | grep asm_

oracle   26435    1  0 17:05 ?        00:00:00 asm_pmon_+ASM2

oracle   26437    1  0 17:05 ?        00:00:00 asm_diag_+ASM2

oracle   26439    1  0 17:05 ?        00:00:00 asm_psp0_+ASM2

oracle   26459    1  0 17:05 ?        00:00:01 asm_lmon_+ASM2

oracle   26461    1  0 17:05 ?        00:00:00 asm_lmd0_+ASM2

oracle   26463    1  0 17:05 ?        00:00:00 asm_lms0_+ASM2

oracle   26480    1  0 17:05 ?        00:00:00 asm_mman_+ASM2

oracle   26482    1  0 17:05 ?        00:00:00 asm_dbw0_+ASM2

oracle   26484    1  0 17:05 ?        00:00:00 asm_lgwr_+ASM2

oracle   26486    1  0 17:05 ?        00:00:00 asm_ckpt_+ASM2

oracle   26488    1  0 17:05 ?        00:00:00 asm_smon_+ASM2

oracle   26490    1  0 17:05 ?        00:00:00 asm_rbal_+ASM2

oracle   26492    1  0 17:05 ?        00:00:00 asm_gmon_+ASM2

oracle   26564    1  0 17:05 ?        00:00:00 asm_lck0_+ASM2

oracle   32297 24832 0 17:09 pts/1    00:00:00 grep asm_

 

exportORACLE_SID=+ASM2

sqlplus/ as sysdba

SQL>shutdown immediate;

SQL>conn / as sysdba

Connectedto an idle instance.

SQL>startup

ASMinstance started

TotalSystem Global Area   92274688 bytes

FixedSize                  1217884 bytes

VariableSize              65890980 bytes

ASMCache                  25165824 bytes

ORA-15032:not all alterations performed

ORA-15063:ASM discovered an insufficient number of disks for diskgroup

"BACKUP"

ORA-15063:ASM discovered an insufficient number of disks for diskgroup

"ARCHLOG"

 

查看ASM日志

Tail-100 /opt/oracle/database/admin/+ASM/bdump/alert_+ASM2.log

SQL>ALTER DISKGROUP ALL MOUNT

TueSep 25 17:52:30 2012

NOTE:cache registered group DATA number=1 incarn=0x28a105da

NOTE:cache registered group ARCHLOG number=2 incarn=0x25e105d8

NOTE:cache registered group BACKUP number=3 incarn=0x262105d9

TueSep 25 17:52:30 2012

LoadedASM Library - Generic Linux, version 2.0.4(KABI_V2) library for asmlib interface

TueSep 25 17:52:30 2012

NOTE:Hbeat: instance not first (grp 1)

ERROR: no PST quorum in group 2:required 1, found 0

Tue Sep 25 17:52:30 2012

NOTE: cache dismounting group2/0x25E105D8 (ARCHLOG)

NOTE: dbwr not being msg'd to dismount

ERROR: diskgroup ARCHLOG was not mounted

TueSep 25 17:52:30 2012

ERROR:no PST quorum in group 3: required 1, found 0

TueSep 25 17:52:30 2012

NOTE:cache dismounting group 3/0x262105D9 (BACKUP)

NOTE:dbwr not being msg'd to dismount

ERROR:diskgroup BACKUP was not mounted

NOTE:cache opening disk 0 of grp 1: VOL1 label:VOL1

NOTE:F1X0 found on disk 0 fcn 0.0

NOTE:cache opening disk 1 of grp 1: VOL2 label:VOL2

NOTE:cache mounting (not first) group 1/0x28A105DA(DATA)

TueSep 25 17:52:31 2012

kjbdomattsend to node 0

TueSep 25 17:52:31 2012

NOTE:attached to recovery domain 1

TueSep 25 17:52:32 2012

NOTE:opening chunk 1 at fcn 0.7142 ABA

NOTE:seq=42 blk=940

TueSep 25 17:52:32 2012

NOTE:cache mounting group 1/0x28A105DA(DATA) succeeded

SUCCESS:diskgroup DATA was mounted

TueSep 25 17:52:34 2012

NOTE:recovering COD for group 1/0x28a105da(DATA)

SUCCESS:completed COD recovery for group 1/0x28a105da(DATA)

 

关闭虚拟机 修改VMX文件增加

scsi1.sharedBus = "VIRTUAL"