プロのOracle Databaseの復旧サービスを提供
携帯番号： +86 13764045638 メール：[email protected]
ASMを使うときにASM Diskgroupが現れて、MOUNTできなくなった上に、ASMインスタンスのalert.logに以下のようなエラが現れた：
ERROR: no read quorum in group: required 1, found 0 disks
ORA-15032: not all alterations performed
ORA-15017: diskgroup “TESTDG04” cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup “TESTDG04”
ERROR: /* ASMCMD */ALTER DISKGROUP testdg04 MOUNT
これはASM Diskgroup上の部分、Metadataメータデータにロジック損害/一致していない事情が現れたと意味している。この場合にはkfed repairでリカバリしてください （10.2.0.5バーション後)
kfed repairでうまくいかない場合には、ASM底の構造に詳しいプロ技術員が人工的にロジック損害を修復するという方法しかない。
ASMCMD> mount testdg04
ORA-15032: not all alterations performed
ORA-15017: diskgroup “TESTDG04” cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup “TESTDG04” (DBD ERROR: OCIStmtExecute)
SQL> /* ASMCMD */ALTER DISKGROUP testdg04 MOUNT
NOTE: cache registered group TESTDG04 number=1 incarn=0x22485c89
NOTE: cache began mount (first) of group TESTDG04 number=1 incarn=0x22485c89
NOTE: Assigning number (1,0) to disk (/oracleasm/asm-disk01)
Fri Jan 30 02:33:05 2015
ERROR: no read quorum in group: required 1, found 0 disks
NOTE: cache dismounting (clean) group 1/0x22485C89 (TESTDG04)
NOTE: messaging CKPT to quiesce pins Unix process pid: 8724, image: [email protected] (TNS V1-V3)
NOTE: dbwr not being msg’d to dismount
NOTE: lgwr not being msg’d to dismount
NOTE: cache dismounted group 1/0x22485C89 (TESTDG04)
NOTE: cache ending mount (fail) of group TESTDG04 number=1 incarn=0x22485c89
NOTE: cache deleting context for group TESTDG04 1/0x22485c89
GMON dismounting group 1 at 139 for pid 20, osid 8724
NOTE: Disk in mode 0x8 marked for de-assignment
ERROR: diskgroup TESTDG04 was not mounted
ORA-15032: not all alterations performed
ORA-15017: diskgroup “TESTDG04” cannot be mounted
ORA-15063: ASM discovered an insufficient number of disks for diskgroup “TESTDG04”
ERROR: /* ASMCMD */ALTER DISKGROUP testdg04 MOUNT
Fri Jan 30 02:33:05 2015
NOTE: No asm libraries found in the system
SQL> create diskgroup testdg04 external redundancy disk ‘/oracleasm/asm-disk01’;
Diskgroup created.
[oracle@mlab2 ~]$ kfed read /oracleasm/asm-disk01 aun=1 blkn=0|less
kfbh.endian: 1 ; 0x000: 0x01
kfbh.hard: 130 ; 0x001: 0x82
kfbh.type: 17 ; 0x002: KFBTYP_PST_META
kfbh.datfmt: 1 ; 0x003: 0x01
kfbh.block.blk: 256 ; 0x004: blk=256
kfbh.block.obj: 2147483648 ; 0x008: disk=0
kfbh.check: 4150372545 ; 0x00c: 0xf761a8c1
kfbh.fcn.base: 0 ; 0x010: 0x00000000
kfbh.fcn.wrap: 0 ; 0x014: 0x00000000
kfbh.spare1: 0 ; 0x018: 0x00000000
kfbh.spare2: 0 ; 0x01c: 0x00000000
kfdpHdrBv0.time.hi: 33015746 ; 0x000: HOUR=0x2 DAYS=0x1e MNTH=0x1 YEAR=0x7df
kfdpHdrBv0.time.lo: 2005330944 ; 0x004: USEC=0x0 MSEC=0x1bb SECS=0x38 MINS=0x1d
kfdpHdrBv0.last: 2 ; 0x008: 0x00000002
kfdpHdrBv0.next: 2 ; 0x00c: 0x00000002
kfdpHdrBv0.copyCnt: 1 ; 0x010: 0x01
kfdpHdrBv0.version: 0 ; 0x011: 0x00
kfdpHdrBv0.ub2spare: 0 ; 0x012: 0x0000
kfdpHdrBv0.incarn: 1 ; 0x014: 0x00000001
kfdpHdrBv0.copy[0]: 0 ; 0x018: 0x0000
kfdpHdrBv0.copy[1]: 0 ; 0x01a: 0x0000
kfdpHdrBv0.copy[2]: 0 ; 0x01c: 0x0000
kfdpHdrBv0.copy[3]: 0 ; 0x01e: 0x0000
kfdpHdrBv0.copy[4]: 0 ; 0x020: 0x0000
kfdpHdrBv0.dtaSz: 1 ; 0x022: 0x0001
ub1[0]: 2 ; 0x024: 0x02
ub1[1]: 0 ; 0x025: 0x00
ub1[2]: 0 ; 0x026: 0x00
ub1[3]: 0 ; 0x027: 0x00
ub1[4]: 0 ; 0x028: 0x00
ub1[5]: 0 ; 0x029: 0x00
ub1[6]: 0 ; 0x02a: 0x00
ub1[7]: 0 ; 0x02b: 0x00
ub1[8]: 0 ; 0x02c: 0x00
ub1[9]: 0 ; 0x02d: 0x00
自分でうまくいかないときに詩檀ソフトORACLEデータベースリカバリチームに助けを求めてください。
携帯番号： 13764045638 メール：[email protected]
ORACLE PRMは詩檀ソフトに独立で開發したORACLEデータベースディザスターリカバリソフトである。
ORACLE PRMをダウンロードするにはこちら：http://parnassusdata.com/sites/default/files/ParnassusData_PRMForOracle_3206.zip
PRM ガイドブックhttp://www.parnassusdata.com/sites/default/files /ParnassusData%20Recovery%20Manager%20For%20Oracle%20Database%E7%94%A8%E6%88%B7%E6%89%8B%E5%86%8C%20v0.3.pdf
[oracle@mlab2 trace]$ oerr ora 15063
15063, 00000, “ASM discovered an insufficient number of disks for diskgroup \”%s\””
// *Cause: ASM was unable to find a sufficient number of disks belonging to the
// diskgroup to continue the operation.
// *Action: Check that the disks in the diskgroup are present and functioning,
// that the owner of the ORACLE binary has read/write permission to
// the disks, and that the ASM_DISKSTRING initialization parameter
// has been set correctly. Verify that ASM discovers the appropriate
// disks by querying V$ASM_DISK from the ASM instance.
//
[oracle@mlab2 trace]$ oerr ora 15017
15017, 00000, “diskgroup \”%s\” cannot be mounted”
// *Cause: The disk group could not be mounted by the ASM instance either
// of an IO error or due to other reasons explained in alert log or
// trace files.
// *Action: Check for additional errors reported. Correct the error and
// retry the operation.
//
[oracle@mlab2 trace]$ oerr ora 15032
15032, 00000, “not all alterations performed”
// *Cause: At least one ALTER DISKGROUP action failed.
// *Action: Check the other messages issued along with this summary error.
//
Leave a Reply