Last updated on SEPTEMBER 10, 2009
Applies to:
Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 11.2.0.2Microsoft Windows
Microsoft Windows XP (64-bit Itanium)
Microsoft Windows Server 2003 (64-bit Itanium)
Microsoft Windows XP (64-bit AMD64 and Intel EM64T)
Microsoft Windows Server 2003 (64-bit AMD64 and Intel EM64T)
Microsoft Windows (64-bit) on Intel Itanium
Microsoft Windows Vista (32-bit)
Microsoft Windows Server 2003 R2 (64-bit AMD64 and Intel EM64T)
Microsoft Windows Server 2003 R2 (32-bit)
Microsoft Windows Vista x64 (64-bit)
Microsoft Windows Server 2008 (32-bit)
Microsoft Windows Server 2008 (64-bit Itanium)
Microsoft Windows Server 2008 x64 (AMD64/EM64T)
Generic Windows
Symptoms
1) After OS restore, ASM instance cannot detect SCSI disks previously configured:
SQL> ALTER DISKGROUP ALL MOUNT
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15063: ASM discovered an insufficient number of disks for diskgroup "DATA"
2) asmtoolg or asmtool are able to see the disk(s):
C:\>asmtool -list
NTFS \Device\Harddisk0\Partition1 20481M
FAT32 \Device\Harddisk0\Partition2 4094M
NTFS \Device\Harddisk0\Partition3 30725M
NTFS \Device\Harddisk0\Partition4 30718M
ORCLDISKDATA0 \Device\Harddisk3\Partition1 1027
3) Also, the dd for windows command is able to read on the disk (confirmed I/O access):
C:\> dd if=\\?\Device\Harddisk3\Partition1 of=C:\tmp.dmp bs=4096 count=1
1+0 records in
1+0 records out
4) But v$asm_disk view cannot discover the disk(s):
SQL> select path from v$asm_disks;
no rows selected
Or
SQL> Alter system asm_diskstring = '\\.\ORCLDISKDATA0’;
SQL> select path from v$asm_disks;
no rows selected
5) Kfed also confirmed a valid ASM disk header:
+ASM:oracle>kfed read tmp.dmp
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 0 ; 0x004: T=0 NUMB=0x0
kfbh.block.obj: 2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check: 1906290351 ; 0x00c: 0x719faeaf
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdhdb.driver.provstr: ORCLDISKDATA0 ; 0x000: length=13
kfdhdb.driver.reserved[0]: 1096040772 ; 0x008: 0x41544144
kfdhdb.driver.reserved[1]: 48 ; 0x00c: 0x00000030
kfdhdb.driver.reserved[2]: 0 ; 0x010: 0x00000000
kfdhdb.driver.reserved[3]: 0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]: 0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]: 0 ; 0x01c: 0x00000000
kfdhdb.compat: 168820736 ; 0x020: 0x0a100000
kfdhdb.dsknum: 0 ; 0x024: 0x0000
kfdhdb.grptyp: 1 ; 0x026: KFDGTP_EXTERNAL
kfdhdb.hdrsts: 3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname: DATA_0000 ; 0x028: length=9
kfdhdb.grpname: DATA ; 0x048: length=4
kfdhdb.fgname: DATA_0000 ; 0x068: length=9
kfdhdb.capname: ; 0x088: length=0
kfdhdb.crestmp.hi: 32888073 ; 0x0a8: HOUR=0x9 DAYS=0x8 MNTH=0x5
YEAR=0x7d7
kfdhdb.crestmp.lo: 1131875328 ; 0x0ac: USEC=0x0 MSEC=0x1c3 SECS=0x37
MINS=0x10
kfdhdb.mntstmp.hi: 32922857 ; 0x0b0: HOUR=0x9 DAYS=0x7 MNTH=0x7
YEAR=0x7d9
kfdhdb.mntstmp.lo: 3848871936 ; 0x0b4: USEC=0x0 MSEC=0x248 SECS=0x16
MINS=0x39
6) Also validated the automount feature is OK:
C:\> diskpart
DISKPART> automount enable
7) Shutdown and startup the ASM instance but the problem persists:
C:\> srvctl stop asm -n nodename
C:\> srvctl start asm -n nodename
Changes
OS was restored from backup.Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms