ORA-15042 ASM disk "disknumber" is missing from group number "groupnumber"ORA-15066: offlining disk "" may result in a data loss 遇到该错误ORA-15042说明ASM下对应groupnumber的disk group 下对应disknumber的ASM Disk无法被找到,引起该错误的可能性有多种,如: ASM_DISKSTRING设置不当,导致部分需要的...
3,'MEMBER',既然知道 v$asm_disk的HEADER_STATUS状态的底层调用,那么“1,'UNKNOWN'',3,'MEMBER'”这些数字与状态之关的关系如何得来呢,当X$KFDSK的HDRSTS_KFDSK为1时,那么通过什么过程让v$asm_disk的HEADER_STATUS显示为 “UNKNOWN'”呢,继续往下看:...
官方文档对于V$ASM_DISK的描述是:V$ASM_DISKdisplays one row for every disk discovered by the Oracle Automatic Storage Management (Oracle ASM) instance, including disks that are not part of any disk group.翻译过来是:V$ASM_DISK为Oracle ASM实例发现的每个磁盘显示一行,包括不属于任何磁盘...
Errors in file /opt/oracle/product/10.2.0/asm/admin/+ASM/bdump/+asm1_rbal_30556.trc:ORA-15040: diskgroup is incompleteORA-15066: offlining disk "" may result in a data lossORA-15042: ASM disk "29" is missingORA-15042: ASM disk "28" is missingORA-15042: ASM disk "27" is missing...
操作过程中,需紧密监控 各个实例ASM alert 日志的信息。 2. 操作方法2:删掉重加 本操作仅在操作方法1失败后才进行。 ALTER DISKGROUP DATA drop disk DATA_0000; host dd if=zero of=/dev/rhdiskpower10 count=4096 bs=1024 ALTER DISKGROUP DATA add disk failgroup fg1 ‘/dev/rhdiskpower10’ name DATA...
ASM disk "5" is missing from group number "1"ERROR: alter diskgroup datadg mountWed Mar 13 07:42:03 2013SQL> alter diskgroup datadg mountNOTE: cache registered group DATADG number=1 incarn=0xccb845cdNOTE: cache began mount (first) of group DATADG number=1 incarn=0xccb845cdNOTE: Ass...
NOTE: cache closing disk 32 of grp 1: (notopen) NOTE: process _user171838_+asm1 (171838) initiating offline of disk 39.3915945266 () with mask 0x7e[0x7f]ingroup 1 NOTE: initiating PST update: grp = 1, dsk = 39/0xe9689532, mask = 0x6a,op=clear ...
5)查看ASM的alterlog存在以下信息, ERROR:diskgroupDGWEIXIUwasnotmounted 6)尝试手工mount,获取详细的错误日志信息 SQL>alterdiskgroupDGWEIXIUmount;alterdiskgroupDGWEIXIUmount * ERRORatline1: ORA-15032:notallalterationsperformedORA-15040:diskgroupisincompleteORA-15042:ASMdisk"1"ismissingSQL> ...
failgroup fg2 disk '/dev/oracleasm/disks/ASM_DSK2' * ERROR at line 4: ORA-15106: missing or invalid operating system disk locator string 12:50:33 SYS@ +ASM>create diskgroup dg1 12:53:57 2 normal redundancy 12:54:01 3 failgroup fg1 disk 'ORCL:ASM_DSK1' ...
ASM: Automatic Storage Management 使用Oracle ASM管理数据库的存储,需要安装三个oracleasm相关的包,分别是 oracleasm-support(平台架构相关) oracleasm-support-2.1.11-2.el7.x86_64.rpm 官网下载 oracleasmlib(平台架构相关) oracleasmlib-2.0.12-1.el7.x86_64.rpm 官网下载 oracleasm(kernel相关), kmod-oracl...