当前位置:Gxlcms > mysql > 在虚拟机上添加共享磁盘后节点2的ASM实例无法加载到

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

时间:2021-07-01 10:21:17 帮助过:97人阅读

在节点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"

人气教程排行