-
當(dāng)前位置:首頁 > 創(chuàng)意學(xué)院 > 技術(shù) > 專題列表 > 正文
3、Oracle數(shù)據(jù)庫使用asm存儲,asm diskgroup mount不起來,說是報錯ora-1
4、ORACLE數(shù)據(jù)庫使用ASM作為存儲,重啟后發(fā)現(xiàn)一個diskgroup起不來了,報錯說是 ORA
女生說asm是什么意思啊
大家好!今天讓創(chuàng)意嶺的小編來大家介紹下關(guān)于女生說asm是什么意思啊的問題,以下是小編對此問題的歸納整理,讓我們一起來看看吧。
ChatGPT國內(nèi)免費(fèi)在線使用,一鍵生成原創(chuàng)文章、方案、文案、工作計(jì)劃、工作報告、論文、代碼、作文、做題和對話答疑等等
只需要輸入關(guān)鍵詞,就能返回你想要的內(nèi)容,越精準(zhǔn),寫出的就越詳細(xì),有微信小程序端、在線網(wǎng)頁版、PC客戶端
官網(wǎng):https://ai.de1919.com
本文目錄:
一、PROE里面怎么把ASM格式改成IGS格式。里面3D圖的顏色有些變成白色的呢?望誰能和我說下
proe轉(zhuǎn)換IGS后,面的顏色是默認(rèn)的顏色,你需要把哪些面改成白色你就先在ASM里改好就成。PROE這方面功能不如UG,UG可以選擇轉(zhuǎn)或者不轉(zhuǎn)換顏色、圖層。我經(jīng)常是2個軟件合起來用,比較方便。
二、匯編初學(xué)者的問題 就是怎么查看變量的值 知道這個我就可以自己學(xué)了。
用MASM32的調(diào)試程序 我感覺還是比較方便的
比如有PrintDec 等函數(shù)(準(zhǔn)確的說應(yīng)該是宏)可以直接在調(diào)試面板中顯示你想知道的寄存器值和指定內(nèi)存地址的值
加上
include include\debug.inc
includelib lib\debug.lib
不過這是win32匯編
三、Oracle數(shù)據(jù)庫使用asm存儲,asm diskgroup mount不起來,說是報錯ora-1
某用戶增加LUN到ASM DISKGROUP發(fā)現(xiàn)某個ASM Disk header KFBTYP_DISKHEAD被意外清除掉,導(dǎo)致該Diskgroup無法mount的問題, 后續(xù)DBA采用kfed merge等手法修復(fù)了KFBTYP_DISKHEAD block,但仍無法mount diskgroup,ALERT.log中出現(xiàn)如下的日志:
NOTE: F1X0 found on disk 0 fcn 0.0
NOTE: cache opening disk 1 of grp 1: VOL2 label:VOL2
NOTE: cache opening disk 2 of grp 1: VOL3 label:VOL3
NOTE: cache opening disk 3 of grp 1: VOL4 label:VOL4
NOTE: cache opening disk 4 of grp 1: VOL5 label:VOL5
NOTE: cache opening disk 5 of grp 1: VOL6 label:VOL6
NOTE: cache opening disk 6 of grp 1: VOL7 label:VOL7
NOTE: cache opening disk 7 of grp 1: VOL8 label:VOL8
NOTE: cache opening disk 8 of grp 1: VOL9 label:VOL9
NOTE: cache opening disk 9 of grp 1: VOL10 label:VOL10
NOTE: cache opening disk 10 of grp 1: VOL11 label:VOL11
NOTE: cache mounting (first) group 1/0x3A2C35D6 (DG)
* allocate domain 1, invalid = TRUE
kjbdomatt send to node 0
kjbdomatt send to node 2
Mon Jan 27 02:18:51 CST 2014
NOTE: attached to recovery domain 1
Mon Jan 27 02:18:51 CST 2014
NOTE: starting recovery of thread=1 ckpt=1712.152 group=1
NOTE: advancing ckpt for thread=1 ckpt=1712.153
NOTE: cache recovered group 1 to fcn 0.491275704
Mon Jan 27 02:18:51 CST 2014
NOTE: LGWR attempting to mount thread 1 for disk group 1
NOTE: LGWR mounted thread 1 for disk group 1
NOTE: opening chunk 1 at fcn 0.491275704 ABA
NOTE: seq=1713 blk=154
Mon Jan 27 02:18:51 CST 2014
NOTE: cache mounting group 1/0x3A2C35D6 (DG) succeeded
SUCCESS: diskgroup DG was mounted
Mon Jan 27 02:18:53 CST 2014
NOTE: recovering COD for group 1/0x3a2c35d6 (DG)
WARNING: cache read a corrupted block gn=1 dsk=0 blk=2817 from disk 0
NOTE: a corrupted block was dumped to the trace file
ERROR: cache failed to read dsk=0 blk=2817 from disk(s): 0
ORA-15196: invalid ASM block header [kfc.c:8281] [endian_kfbh] [2147483648] [2817] [173 != 1]
System State dumped to trace file /u01/app/oracle/admin/+ASM/bdump/+asm2_rbal_31204.trc
NOTE: cache initiating offline of disk 0 group 1
WARNING: process 31204 initiating offline of disk 0.3913073997 (VOL1) with mask 0x3 in group 1
WARNING: Disk 0 in group 1 in mode: 0x7,state: 0x2 will be taken offline
NOTE: PST update: grp = 1, dsk = 0, mode = 0x6
Mon Jan 27 02:18:54 CST 2014
ERROR: too many offline disks in PST (grp 1)
Mon Jan 27 02:18:54 CST 2014
WARNING: Disk 0 in group 1 in mode: 0x7,state: 0x2 was taken offline
Mon Jan 27 02:18:54 CST 2014
NOTE: halting all I/Os to diskgroup DG
NOTE: active pin found: 0x0x65faff60
NOTE: active pin found: 0x0x65fb0170
NOTE: active pin found: 0x0x65fb0010
NOTE: active pin found: 0x0x65fb0220
NOTE: active pin found: 0x0x65fb02d0
NOTE: active pin found: 0x0x65fb00c0
NOTE: active pin found: 0x0x65fb0380
Mon Jan 27 02:18:54 CST 2014
ERROR: ORA-15130 in COD recovery for diskgroup 1/0x3a2c35d6 (DG)
ERROR: ORA-15130 thrown in RBAL for group number 1
Mon Jan 27 02:18:54 CST 2014
Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm2_rbal_31204.trc:
ORA-15130: diskgroup "DG" is being dismounted
Mon Jan 27 02:18:54 CST 2014
ERROR: PST-initiated MANDATORY DISMOUNT of group DG
NOTE: cache dismounting group 1/0x3A2C35D6 (DG)
Mon Jan 27 02:18:57 CST 2014
kjbdomdet send to node 0
detach from dom 1, sending detach message to node 0
kjbdomdet send to node 2
detach from dom 1, sending detach message to node 2
Mon Jan 27 02:18:57 CST 2014
Dirty detach reconfiguration started (old inc 23, new inc 23)
List of nodes:
0 1 2
Global Resource Directory partially frozen for dirty detach
* dirty detach - domain 1 invalid = TRUE
138 GCS resources traversed, 0 cancelled
6104 GCS resources on freelist, 6124 on array, 6124 allocated
Dirty Detach Reconfiguration complete
Mon Jan 27 02:18:57 CST 2014
freeing rdom 1
Mon Jan 27 02:18:57 CST 2014
WARNING: dirty detached from domain 1
Mon Jan 27 02:18:57 CST 2014
SUCCESS: diskgroup DG was dismounted
Mon Jan 27 02:18:57 CST 2014
WARNING: PST-initiated MANDATORY DISMOUNT of group DG not performed - group not mounted
Mon Jan 27 02:18:57 CST 2014
Errors in file /u01/app/oracle/admin/+ASM/bdump/+asm2_b001_31755.trc:
ORA-15001: diskgroup "DG" does not exist or is not mounted
ORA-15001: diskgroup "DG" does not exist or is not mounted
ORA-15001: diskgroup "DG" does not exist or is not mounted
Mon Jan 27 02:31:00 CST 2014
這里可以看到Diskgroup mount到了recovering COD for group 1/0x3a2c35d6 (DG)階段時,發(fā)現(xiàn)了一個邏輯壞塊WARNING: cache read a corrupted block gn=1 dsk=0 blk=2817 from disk 0 NOTE: a corrupted block was dumped to the trace file ERROR: cache failed to read dsk=0 blk=2817 from disk(s): 0,并因?yàn)樵搲膲K引起了ORA-15196: invalid ASM block header [kfc.c:8281] [endian_kfbh] [2147483648] [2817] [173 != 1]。
這里2817是出錯的ASM metadata的block number,173是實(shí)際從endian_kfbh位置讀出的值,173!=1 這里的1是該位置理論上該有的值,由于讀取到block中錯誤的字節(jié)序endian_kfbh信息,所以這里出現(xiàn)了ASM ORA-600錯誤。
這里recovering COD for group 1/0x3a2c35d6 (DG) 里的COD 指asm metadata file number 4 COD, Continuing Operation Directory (COD) 該metadata file 4 中記錄的是在單個metadata block中無法完成的操作記錄到COD中,這樣當(dāng)ASM instance crash時可以恢復(fù)這些操作。例如創(chuàng)建 刪除和resize文件,這其中file number 4 blkn=1為KFBTYP_COD_RB 即回滾rollback數(shù)據(jù),后面的數(shù)據(jù)為KFBTYP_COD_DATA。
可回滾的操作opcodes包括:
1 - Create a file
2 - Delete a file
3 - Resize a file
4 - Drop alias entry
5 - Rename alias entry
6 - Rebalance space COD
7 - Drop disks force
8 - Attribute drop
9 - Disk Resync
10 - Disk Repair Time
11 - Volume create
12 - Volume delete
13 - Attribute directory creation
14 - Set zone attributes
15 - User drop
每次ASM diskgroup 嘗試mount時都會讀取FILE number 4 COD中的數(shù)據(jù)來保證操作要么完成、要么回滾。
對于此類ASM file number 4 COD出現(xiàn)了源數(shù)據(jù)壞塊的情況, 一般需要手動設(shè)置內(nèi)部事件,并嘗試手動Patch ASM metadata的手法才能修復(fù)。
建議遇到此類事件第一時間備份ASM disk header 100M的數(shù)據(jù),保護(hù)現(xiàn)場,以便專業(yè)恢復(fù)人員介入恢復(fù)時現(xiàn)場不被破壞。
如果自己搞不定可以找ASKMACLEAN專業(yè)ORACLE數(shù)據(jù)庫修復(fù)團(tuán)隊(duì)成員幫您恢復(fù)!
四、ORACLE數(shù)據(jù)庫使用ASM作為存儲,重啟后發(fā)現(xiàn)一個diskgroup起不來了,報錯說是 ORA
如果出現(xiàn)diskgroup 無法mount的錯誤,且alert.log中出現(xiàn)如下信息,則可能是丟失了必要數(shù)量的PST了:
Wed Jan 01 21:34:37 IST 2014
SQL> ALTER DISKGROUP ALL MOUNT
Wed Jan 01 21:34:38 IST 2014
NOTE: cache registered group DATA number=1 incarn=0x1c58c060
Wed Jan 01 21:34:38 IST 2014
ERROR: no PST quorum in group 1: required 2, found 0 >>>>>>>>>>>>>>>>> HERE
Wed Jan 01 21:34:38 IST 2014
NOTE: cache dismounting group 1/0x1C58C060 (DATA)
NOTE: dbwr not being msg'd to dismount
ERROR: diskgroup DATA was not mounted
Wed Jan 01 22:37:51 IST 2014
該P(yáng)ST quorum丟失的問題常由以下幾個原因?qū)е拢?/p>
ASM DISK丟失
ASM DISK corrupted損壞
部分ASM DISK的AUN=1 PST部分損壞,或者被數(shù)據(jù)不完整
不當(dāng)?shù)腁SM_DISKSTRING參數(shù)設(shè)置
不當(dāng)?shù)腁SM DISK權(quán)限設(shè)置
對于該no PST quorum問題的常見對策:
重建diskgroup
手動修復(fù)PST(十分復(fù)雜)
如果自己搞不定可以找ASKMACLEAN專業(yè)ORACLE數(shù)據(jù)庫修復(fù)團(tuán)隊(duì)成員幫您恢復(fù)!
以上就是關(guān)于女生說asm是什么意思啊相關(guān)問題的回答。希望能幫到你,如有更多相關(guān)問題,您也可以聯(lián)系我們的客服進(jìn)行咨詢,客服也會為您講解更多精彩的知識和內(nèi)容。
推薦閱讀:
電子商務(wù)專業(yè)好就業(yè)嗎(電子商務(wù)主要學(xué)什么就業(yè)方向)