Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

View v$asm_disk, v$asm_diskgroup, and asm logs

2025-03-29 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

Shulou(Shulou.com)06/01 Report--

[oracle@TestXLink dbs] $sqlplus / nolog

SQL*Plus: Release 11.2.0.1.0 Production on Wed Mar 14 23:17:54 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

SQL > conn / as sysasm

Connected to an idle instance.

SQL > startup mount

ASM instance started

Total System Global Area 284565504 bytes

Fixed Size 1336036 bytes

Variable Size 258063644 bytes

ASM Cache 25165824 bytes

ORA-15032: not all alterations performed

ORA-15017: diskgroup "DATA" cannot be mounted

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

SQL > col path for A30

SQL > set lines 100

SQL > select mode_status,name,state,path from v$asm_disk

MODE_ST NAME STATE PATH

-

ONLINE NORMAL / dev/raw/raw4

ONLINE NORMAL / dev/raw/raw2

ONLINE NORMAL / dev/raw/raw5

ONLINE NORMAL / dev/raw/raw3

ONLINE NORMAL / dev/raw/raw1

SQL > select * from v$asm_diskgroup

2

No rows selected

SQL > show parameter asm_disk

NAME TYPE VALUE

-

Asm_diskgroups string DATA

Asm_diskstring string / dev/raw/raw*

SQL >

The log of the following asm instance

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production

"alert_+ASM.log" 1376L, 59479C 1286jue 1 95%

Asm_diskstring = "/ dev/raw/raw*"

Asm_diskgroups = "DATA"

Asm_power_limit = 1

Diagnostic_dest = "/ u01/app/oracle/"

Wed Mar 14 23:18:07 2012

PMON started with pid=2, OS id=4493

Wed Mar 14 23:18:07 2012

VKTM started with pid=3, OS id=4495 at elevated priority

VKTM running at (10) millisec precision with DBRM quantum ms

Wed Mar 14 23:18:07 2012

GEN0 started with pid=4, OS id=4499

Wed Mar 14 23:18:07 2012

DIAG started with pid=5, OS id=4501

Wed Mar 14 23:18:07 2012

PSP0 started with pid=6, OS id=4503

Wed Mar 14 23:18:07 2012

DIA0 started with pid=7, OS id=4505

Wed Mar 14 23:18:07 2012

MMAN started with pid=8, OS id=4507

Wed Mar 14 23:18:07 2012

DBW0 started with pid=9, OS id=4509

Wed Mar 14 23:18:07 2012

LGWR started with pid=10, OS id=4511

Wed Mar 14 23:18:07 2012

CKPT started with pid=11, OS id=4513

Wed Mar 14 23:18:07 2012

SMON started with pid=12, OS id=4515

Wed Mar 14 23:18:07 2012

RBAL started with pid=13, OS id=4517

Wed Mar 14 23:18:07 2012

GMON started with pid=14, OS id=4519

Wed Mar 14 23:18:07 2012

MMON started with pid=15, OS id=4521

Wed Mar 14 23:18:07 2012

MMNL started with pid=16, OS id=4523

ORACLE_BASE from environment = / u01/app/oracle

Wed Mar 14 23:18:07 2012

SQL > ALTER DISKGROUP ALL MOUNT

NOTE: Diskgroups listed in ASM_DISKGROUPS are

DATA

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

NOTE: cache began mount (first) of group DATA number=1 incarn=0xbc9dab97

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

NOTE: cache dismounting (clean) group 1/0xBC9DAB97 (DATA)

NOTE: dbwr not being msg'd to dismount

NOTE: lgwr not being msg'd to dismount

NOTE: cache dismounted group 1/0xBC9DAB97 (DATA)

NOTE: cache ending mount (fail) of group DATA number=1 incarn=0xbc9dab97

Kfdp_dismount (): 2

Kfdp_dismountBg (): 2

ERROR: diskgroup DATA was not mounted

NOTE: cache deleting context for group DATA 1max Motel 1130517609

ORA-15032: not all alterations performed

ORA-15017: diskgroup "DATA" cannot be mounted

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

ERROR: ALTER DISKGROUP ALL MOUNT

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report