在Solaris平臺中ASM所需磁碟的Format過程
近期在增加ASM磁碟過程中遇到如下錯誤：
SQL> alter diskgroup datadg add disk '/dev/rac/DBdg01' rebalance power 0;
alter diskgroup datadg add disk '/dev/rac/DBdg01' rebalance power 0
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15031: disk specification '/dev/rac/DBdg01' matches no disks
ORA-15025: could not open disk '/dev/rac/DBdg01'
ORA-15056: additional error message
SVR4 Error: 13: Permission denied
Additional information: 42
Additional information: –1897261352
經過兩天排查，最終的處理方法歸結為在OS環境透過Format命令格式化分割槽時如下的0號分割槽沒有留空間，6號區從0號Cylinders 開始導致的。
Part Tag Flag Cylinders Size Blocks
0 root wm 0 - 4 117.66MB (5/0/0) 240975
具體處理過程如下：
bash-3.00# format
Searching for disks...done
c3t6000B5D0006A0000006A10C100080000d0: configured with capacity of 1023.95GB
c3t6000B5D0006A0000006A10C100090000d0: configured with capacity of 279.87GB
AVAILABLE DISK SELECTIONS:
.....
6. c3t6000B5D0006A0000006A10C100040000d0
/scsi_vhci/ssd@g6000b5d0006a0000006a10c100040000
7. c3t6000B5D0006A0000006A10C100050000d0
/scsi_vhci/ssd@g6000b5d0006a0000006a10c100050000
.....
Specify disk (enter its number): 7
selecting c3t6000B5D0006A0000006A10C100050000d0
[disk formatted]
FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition table
current - describe the current disk
format - format and analyze the disk
repair - repair a defective sector
label - write label to the disk
analyze - surface analysis
defect - defect list management
backup - search for backup labels
verify - read and display labels
save - save new disk/partition definitions
inquiry - show vendor, product and revision
volname - set 8-character volume name
!
quit
format> p
PARTITION MENU:
0 - change `0' partition
1 - change `1' partition
2 - change `2' partition
3 - change `3' partition
4 - change `4' partition
5 - change `5' partition
6 - change `6' partition
7 - change `7' partition
select - select a predefined table
modify - modify a predefined partition table
name - name the current table
print - display the current table
label - write partition map and label to the disk
!
quit
partition> m
Select partitioning base:
0. Current partition table (original)
1. All Free Hog
Choose base (enter number) [0]? 0
Part Tag Flag Cylinders Size Blocks
0 root wm 0 0 (0/0/0) 0
1 swap wu 0 0 (0/0/0) 0
2 backup wu 0 - 44555 1023.95GB (44556/0/0) 2147376420
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 usr wm 0 - 44555 1023.95GB (44556/0/0) 2147376420
7 unassigned wm 0 0 (0/0/0) 0
Do you wish to continue creating a new partition
table based on above table[yes]?
Free Hog partition[6]?
Enter size of partition '0' [0b, 0c, 0.00mb, 0.00gb]: 100m
Enter size of partition '1' [0b, 0c, 0.00mb, 0.00gb]:
Enter size of partition '3' [0b, 0c, 0.00mb, 0.00gb]:
Enter size of partition '4' [0b, 0c, 0.00mb, 0.00gb]:
Enter size of partition '5' [0b, 0c, 0.00mb, 0.00gb]:
Enter size of partition '7' [0b, 0c, 0.00mb, 0.00gb]:
Part Tag Flag Cylinders Size Blocks
0 root wm 0 - 4 117.66MB (5/0/0) 240975
1 swap wu 0 0 (0/0/0) 0
2 backup wu 0 - 44555 1023.95GB (44556/0/0) 2147376420
3 unassigned wm 0 0 (0/0/0) 0
4 unassigned wm 0 0 (0/0/0) 0
5 unassigned wm 0 0 (0/0/0) 0
6 usr wm 5 - 44555 1023.83GB (44551/0/0) 2147135445
7 unassigned wm 0 0 (0/0/0) 0
Okay to make this the current partition table[yes]? yes
Enter table name (remember quotes): DBdg01
Ready to label disk, continue?
Ready to label disk, continue? lable
`lable' is not expected.
Ready to label disk, continue? y
partition> q
FORMAT MENU:
disk - select a disk
type - select (define) a disk type
partition - select (define) a partition table
current - describe the current disk
format - format and analyze the disk
repair - repair a defective sector
label - write label to the disk
analyze - surface analysis
defect - defect list management
backup - search for backup labels
verify - read and display labels
save - save new disk/partition definitions
inquiry - show vendor, product and revision
volname - set 8-character volume name
!
quit
format> s
Saving new disk and partition definitions
Enter file name["./format.dat"]:
format> quit
以上過程完成後，下一步工作就是在ASM環境下新增磁碟，操作步驟如下：
bash-3.00# su - oracle
Oracle Corporation SunOS 5.10 Generic Patch January 2005
You have new mail.
[dbserv1]@dbserv-db1[/export/home/oracle]$export ORACLE_SID=+ASM1
[+ASM1]@dbserv-db1[/export/home/oracle]$asmcmd
ASMCMD> lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N N 512 4096 1048576 1048217 812839 0 812839 0 BACKUP/
MOUNTED EXTERN N N 512 4096 1048576 999760 40673 0 40673 0 DATADG/
ASMCMD> exit
[+ASM1]@dbserv-db1[/export/home/oracle]$sqlplus / as sysdba
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Jun 30 18:42:26 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
SQL> alter diskgroup DATADG add disk '/dev/rac/DBdg01' rebalance power 0;
Diskgroup altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[+ASM1]@dbserv-db1[/export/home/oracle]$asmcmd
ASMCMD> lsdg
State Type Rebal Unbal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED EXTERN N N 512 4096 1048576 1048217 812839 0 812839 0 BACKUP/
MOUNTED EXTERN N N 512 4096 1048576 2048165 1089067 0 1089067 0 DATADG/
ASMCMD> exit
[+ASM1]@dbserv-db1[/export/home/oracle]$eixt
-bash: eixt: command not found
[+ASM1]@dbserv-db1[/export/home/oracle]$exit
logout
bash-3.00# id
uid=0(root) gid=0(root)
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/18841027/viewspace-1200019/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle ASM Rebalance執行過程OracleASM
- 直播平臺建設過程中不可或缺的推送功能
- ASM磁碟組限制ASM
- 簡歷&面試&擇業篇-在面試的過程中你所需要注意的問題面試
- ASM磁碟組更換磁碟的操作方法ASM
- 在ASM磁碟組中刪除歸檔日誌報ORA-15028ASM
- 【ASM】Oracle asm磁碟被格式化，如何掛載該磁碟組ASMOracle
- 遷移ASM磁碟組ASM
- Ubuntu 磁碟擴容過程Ubuntu
- 教育平臺原始碼：網校平臺開發過程中，你需要注意的關鍵點原始碼
- Windows平臺Nginx部署https網站的過程WindowsNginxHTTP網站
- solaris中如何設定解析度？在solaris中設定解析度的方法教程
- 服務執行過程中磁碟壞道引起的思考
- SAP Commerce Cloud ASM 模組的登入過程CloudASM
- 【ASM】Oracle asm刪除磁碟組注意事項ASMOracle
- 【ASM】ASM磁碟頭被重寫，如何修復ASM
- ASM 磁碟組的建立及擴容ASM
- DOM在Ahooks中的處理過程Hook
- 如何搭建直播平臺，開發過程中頂起大梁的功能有哪些？
- 從定位資料塊所在ASM磁碟到ASM strippingASM
- 在平時的測試過程中,測試需要做推進工作嗎?
- ORACLE ASM的SSD磁碟空間回收分析OracleASM
- 一次ASM新增新的磁碟組ASM
- puppeteer在開發過程中的實踐
- 線上教育平臺開發過程中，購物功能是如何實現的？
- 直播平臺軟體開發過程中的雲端儲存和備份
- 安卓平臺Flutter啟動過程全解析安卓Flutter
- SLM——模擬過程與資料管理平臺
- 簡述知識付費平臺搭建過程
- Solaris 解析度調整與KDE/GNome平臺切換
- 校園交易平臺後臺系統git操作全過程Git
- 一個Flutter中臺元件的開發過程Flutter元件
- Linux運維學習過程中，磁碟的磁軌簡單介紹Linux運維
- 給ubuntu虛機增加一個磁碟的過程Ubuntu
- 【ARCH】Oracle 判斷asm磁碟組大小，超過閾值清理指令碼OracleASM指令碼
- VS2017平臺編譯 zmq-4.2.5 過程編譯MQ
- ORACLE ASM磁碟組空間溢位OracleASM
- 使用udev擴充套件ASM磁碟組dev套件ASM
- ASM磁碟組擴容操作文件ASM