Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-13 13:46:42 | 查看: 1242| 回复: 0
环境:windows 2008 server R2 sp1  11.2.0.3 rac

ocr_vote_dg是normal冗余(三个磁盘,创建后默认是3个失败组),其中一个磁盘在windows操作系统磁盘管理上不小心操作了删除卷,导致asm启动不了了,然后用kfed的repaire修复后,asm能启动了,但是ocr_vote_dg只有2个盘了,修复后的那个盘没有加入这个磁盘组,虽然kfed读出的磁盘头数据可以看出这个磁盘是属于这个磁盘组的。


asm磁盘组mount时应该会把该组的所有磁盘都加入吧,这个是怎么回事呢?如果需要手动加入,那么感觉就跟新加盘差不多了吧,修复就没有意义了
asm的alert日志
NOTE: Diskgroups listed in ASM_DISKGROUPS are
      DATA_DG
      OCR_VOTE_DG
NOTE: Diskgroup used for Voting files is:
      OCR_VOTE_DG
Diskgroup with spfile:OCR_VOTE_DG
Diskgroup used for OCR is:OCR_VOTE_DG
NOTE: cache registered group DATA_DG number=1 incarn=0x1d7dce42
NOTE: cache began mount (first) of group DATA_DG number=1 incarn=0x1d7dce42
NOTE: cache registered group OCR_VOTE_DG number=2 incarn=0x1d8dce43
NOTE: cache began mount (first) of group OCR_VOTE_DG number=2 incarn=0x1d8dce43
NOTE: Assigning number (1,0) to disk (\\.\ORCLDISKDATA_DG0)
NOTE: Assigning number (2,2) to disk (\\.\ORCLDISKOCR_VOTE_DG2)《===能识别有三个盘
NOTE: Assigning number (2,0) to disk (\\.\ORCLDISKOCR_VOTE_DG0)
NOTE: Assigning number (2,1) to disk (\\.\ORCLDISKOCR_VOTE_DG1)
NOTE: GMON heartbeating for grp 1
GMON querying group 1 at 4 for pid 23, osid 3792
NOTE: cache opening disk 0 of grp 1: DATA_DG_0000 path:\\.\ORCLDISKDATA_DG0
NOTE: F1X0 found on disk 0 au 2 fcn 0.0
NOTE: cache mounting (first) external redundancy group 1/0x1D7DCE42 (DATA_DG)
* allocate domain 1, invalid = TRUE
NOTE: attached to recovery domain 1
NOTE: cache recovered group 1 to fcn 0.80
NOTE: redo buffer size is 256 blocks (1053184 bytes)
NOTE: LGWR attempting to mount thread 1 for diskgroup 1 (DATA_DG)
NOTE: LGWR found thread 1 closed at ABA 9.20
NOTE: LGWR mounted thread 1 for diskgroup 1 (DATA_DG)
NOTE: LGWR opening thread 1 at fcn 0.80 ABA 10.21
NOTE: cache mounting group 1/0x1D7DCE42 (DATA_DG) succeeded
NOTE: cache ending mount (success) of group DATA_DG number=1 incarn=0x1d7dce42
NOTE: GMON heartbeating for grp 2
GMON querying group 2 at 6 for pid 23, osid 3792
GMON querying group 2 at 7 for pid 23, osid 3792
NOTE: cache opening disk 1 of grp 2: OCR_VOTE_DG_0001 path:\\.\ORCLDISKOCR_VOTE_DG1《=====这里只有两个了。。。
NOTE: F1X0 found on disk 1 au 2 fcn 0.848
NOTE: cache opening disk 2 of grp 2: OCR_VOTE_DG_0002 path:\\.\ORCLDISKOCR_VOTE_DG2
NOTE: F1X0 found on disk 2 au 2 fcn 0.869
NOTE: cache mounting (first) normal redundancy group 2/0x1D8DCE43 (OCR_VOTE_DG)






SQL> alter diskgroup ocr_vote_dg dismount force;

Diskgroup altered.
SQL> alter diskgroup ocr_vote_dg mount;

Diskgroup altered.

SQL> select group_number,name,path,FAILGROUP from v$asm_disk;

GROUP_NUMBER NAME                 PATH                                     FAILGROUP
------------ -------------------- ---------------------------------------- ------------------------------------------------------------
           0                      \\.\ORCLDISKOCR_VOTE_DG0
           0                      \\.\ORCLDISKOCR_VOTE_DG3
           2 OCR_VOTE_DG_0002     \\.\ORCLDISKOCR_VOTE_DG2                 OCR_VOTE_DG_0002
           1 DATA_DG_0000         \\.\ORCLDISKDATA_DG0                     DATA_DG_0000
           2 OCR_VOTE_DG_0001     \\.\ORCLDISKOCR_VOTE_DG1                 OCR_VOTE_DG_0001

kfed读取的磁盘头
C:\Users\Administrator>C:\kfedwin\kfed.exe read \\.\ORCLDISKOCR_VOTE_DG0
kfbh.endian:                          1 ; 0x000: 0x01
kfbh.hard:                          130 ; 0x001: 0x82
kfbh.type:                            1 ; 0x002: KFBTYP_DISKHEAD
kfbh.datfmt:                          1 ; 0x003: 0x01
kfbh.block.blk:                     254 ; 0x004: T=0 NUMB=0xfe
kfbh.block.obj:              2147483648 ; 0x008: TYPE=0x8 NUMB=0x0
kfbh.check:                   887466378 ; 0x00c: 0x34e5a98a
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:ORCLDISKOCR_VOTE_DG0 ; 0x000: length=20
kfdhdb.driver.reserved[0]:   1599226703 ; 0x008: 0x5f52434f
kfdhdb.driver.reserved[1]:   1163153238 ; 0x00c: 0x45544f56
kfdhdb.driver.reserved[2]:    809976927 ; 0x010: 0x3047445f
kfdhdb.driver.reserved[3]:            0 ; 0x014: 0x00000000
kfdhdb.driver.reserved[4]:            0 ; 0x018: 0x00000000
kfdhdb.driver.reserved[5]:            0 ; 0x01c: 0x00000000
kfdhdb.compat:                186646528 ; 0x020: 0x0b200000
kfdhdb.dsknum:                        0 ; 0x024: 0x0000
kfdhdb.grptyp:                        2 ; 0x026: KFDGTP_NORMAL
kfdhdb.hdrsts:                        3 ; 0x027: KFDHDR_MEMBER
kfdhdb.dskname:        OCR_VOTE_DG_0000 ; 0x028: length=16
kfdhdb.grpname:             OCR_VOTE_DG ; 0x048: length=11
kfdhdb.fgname:         OCR_VOTE_DG_0000 ; 0x068: length=16
kfdhdb.capname:                         ; 0x088: length=0
kfdhdb.crestmp.hi:             33037777 ; 0x0a8: HOUR=0x11 DAYS=0xe MNTH=0x7 YEAR=0x7e0
kfdhdb.crestmp.lo:            780820480 ; 0x0ac: USEC=0x0 MSEC=0x298 SECS=0x28 MINS=0xb
kfdhdb.mntstmp.hi:             33037806 ; 0x0b0: HOUR=0xe DAYS=0xf MNTH=0x7 YEAR=0x7e0
kfdhdb.mntstmp.lo:           2445704192 ; 0x0b4: USEC=0x0 MSEC=0x19f SECS=0x1c MINS=0x24

下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 13:33 , Processed in 0.079890 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569