We received the following message:
ERROR at line 1:
ORA-01119: error in creating database file '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup space exhausted
Check the diskspace in ASM:
SQL> select GROUP_NUMBER, NAME,TOTAL_MB, FREE_MB, USABLE_FILE_MB from V$ASM_DISKGROUP;
GROUP_NUMBER NAME TOTAL_MB FREE_MB USABLE_FILE_MB
------------ ------------------------------ ---------- ---------- --------------
1 ARCHIVELOGS 1349 1283 1283
2 DATA 2039 4 4
3 ONLINELOGS 705 581 581
SQL> select substr(name,1,10) name,substr(path,1,20) path, REDUNDANCY, TOTAL_MB, os_mb, free_mb from V$ASM_DISK where GROUP_NUMBER = 2;
NAME PATH REDUNDA TOTAL_MB OS_MB FREE_MB
---------- -------------------- ------- ---------- ---------- ----------
VOL1 ORCL:VOL1 UNKNOWN 2039 2039 4
First try to extend current diskgroup.
SQL> ALTER DISKGROUP data RESIZE DISK VOL1 size 4G;
ALTER DISKGROUP data RESIZE DISK VOL1 size 4G
*
ERROR at line 1:
ORA-15032: not all alterations performed
ORA-15289: ASM disk VOL1 cannot be resized beyond 2039 M
Diskgroup cannot be extended. Only solution is to add a new disk.
After adding the new disk, the new disk device is /dev/sde
List all current disks on Linux:
sfdisk -l
Now create a partition on /dev/sde to span the whole disk.
[root@dbvisit32 /]# fdisk /dev/sde
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-261, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-261, default 261):
Using default value 261
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@dbvisit32 /]# ls -la /dev/sde*
brw-r----- 1 root disk 8, 64 Jun 7 11:59 /dev/sde
brw-r----- 1 root disk 8, 65 Jun 7 11:59 /dev/sde1
Partition /dev/sde1 is now created.
Now make the disk available to ASM.
[root@dbvisit31 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
[root@dbvisit31 ~]# /etc/init.d/oracleasm createdisk VOL4 /dev/sde1
Marking disk "/dev/sde1" as an ASM disk: [ OK ]
[root@dbvisit31 ~]# /etc/init.d/oracleasm listdisks
VOL1
VOL2
VOL3
VOL4
Go back to ASM and add the new disk.
SQL> select substr(name,1,10) name,substr(path,1,20) path, REDUNDANCY, TOTAL_MB, os_mb, free_mb from V$ASM_DISK;
NAME PATH REDUNDA TOTAL_MB OS_MB FREE_MB
---------- -------------------- ------- ---------- ---------- ----------
ORCL:VOL4 UNKNOWN 0 2047 0
VOL1 ORCL:VOL1 UNKNOWN 2039 2039 215
VOL2 ORCL:VOL2 UNKNOWN 705 705 606
VOL3 ORCL:VOL3 UNKNOWN 1349 1349 1214
SQL> ALTER DISKGROUP DATA ADD DISK 'ORCL:VOL4';
SQL> select substr(name,1,10) name,substr(path,1,20) path, REDUNDANCY, TOTAL_MB, os_mb, free_mb from V$ASM_DISK where GROUP_NUMBER = 2;
NAME PATH REDUNDA TOTAL_MB OS_MB FREE_MB
---------- -------------------- ------- ---------- ---------- ----------
VOL1 ORCL:VOL1 UNKNOWN 2039 2039 368
VOL4 ORCL:VOL4 UNKNOWN 2047 2047 1892
All done. Disk group DATA now has an extra 2G.
分享到:
相关推荐
空格<space> 继续打开下一屏; 回车<return> 继续打开下一行; b 另外开上一屏; f 另外开下一屏; h 帮助; q或Ctrl+C 退出; /字符串 从上往下查找匹配的字符串; ?字符串 从下往上查找匹配的字符串; n...
- 0000687: "Script" property for TUniForm for adding Custom JS - 0000665: Compatibility with multiple IP systems - 0000685: UniDBGrid: Ellipsis in first column bug (IE) - 0000690: UniDBGrid: ...
- Fix: Remember category list selection after adding a torrent - Fix: download rate limiter for uTP connections - Change: Disabled feed icon has precedence over broken feed icon - Fix: DHT bootstrap ...
- NEW: Recreated the Drag & Drop example, adding two scroll views resized with screen height, and the ability to move items from one to the other. - NEW: Holding CTRL will now show the dimensions of ...
C++Builder 2006Update : TAdvToolBar v1.3.6----------- New : Persistence of toolbar visibility statesUpdate : TDBAdvGrid v2.0.5.0----------- New : OnColumnPopup event added for adding per column popup...
- bugfix: Share: An alert is shown when adding an email to the share list - bugfix: Slimey always saves as a new document Since 1.2.1 ----------- - feature: Billing Module. Allows defining ...
Ns-3-Adding-text-in-packets 将真实文本数据添加到 ns-3 数据包中。 座右铭是成功地将真实数据从一个节点发送到另一个节点。这已在 ns-3 中的三个示例中实现。 代码执行的先决条件: 将安装 ns-3。 安装后,...
第3周的杂货添加删除项目thanhthanhbui
Based on support-preference from Android Support Library, adding a lot of exciting features. Sample How to use add dependencies // replace with version above implementation 'moe.shizuku.preference...
Configure SSAS to meet requirements including memory limits, NUMA and disk layout. Monitor SSAS performance. Module 3: Working with Cubes and DimensionsThis module describes how to implement ...
NULL 博文链接:https://liu-weiaa.iteye.com/blog/666585
A Termux add-on app adding shortcuts to commands on the home screen. Termux:Widget on Google Play Termux:Widget on F-Droid When developing (or packaging), note that this app needs to be signed with ...
漂亮 :lipstick: 在现有的项目中添加漂亮的东西,包括铃铛和漂亮的东西。... :check_mark: Adding pretty-quick pre-commit to package.json :check_mark: Formatting whole repo 现在,您应该已经准备好要提
用CSS制作FEWD-unit4-adding-3d效果 树屋FEWD单元4:使用CSS添加3D效果
Hooks-Challenge --- OnlineStore-adding-hooks:将钩子添加到现有在线商店项目中
此自述文件的内容: autoauto- [添加内容](#adding-content)auto-[帖子](#posts)auto-[纸张](#papers)auto-[数据集](#datasets)自动-[开发](#development)auto- [部署](#deployment)autoauto ...
adding noise to gt |--- main_glr.m : main for GLR denoising |--- pcdGLR.m : function for GLR denoising |--- tool : tools for GLR |--- metric : for computing MSE |--- setParameter : for parameter ...
Jason discusses the proper way of adding interaction through gestures and the advanced graphical options available using Canvas, Renderscript and OpenGL. Finally, he discusses tablet development, the...
You can install FcPermissions by adding the following dependency to your build.gradle: allprojects { repositories { jcenter() maven { url "https://jitpack.io" } } } dependencies { compile '...
中国剩余定理Matlab代码使用中国余数定理将两个大数相加 问题陈述 问题编号27-编写MATLAB代码以使用中文余数定理添加超过计算机字大小的大整数。 团队成员 塔伦·阿南德(Tarun Anand)-16CO147 ...