0

To add datafiles in ASM hit ORA-01119 ORA-17502 ORA-15041 after add new ASMDISKs to ASMDISKGROUP

张维照 2019-05-31
1138

问题描述

A friend asked me ,they add new disk to a ASM diskgroup. Disks were added successfully. and check free space available of ASM diskgroup was correct, But when tried alter tablespace add new datafile using the diskgroup one the disks were recently added, they got “ora-01119” and “ORA-17502″,”ORA-15041” errors during add new datafile.

SQL script:

alter diskgroup RAC_DISK1 add disk '/dev/raw/raw8' ;
ALTER tablespace FMIS1800 ADD datafile '+RAC_DISK1' size 4000M


专家解答

then reported following errors:

ORA-01119: error in creating database file ”
ORA-17502: ksfdcre:4 Failed to create file ”
ORA-15041: diskgroup space exhausted

then check raw device permissions and ASM info from dynamic view, No abnormalities.

ls -l /dev/raw/*

select group_number,disk_number,name,failgroup,create_date,path,writes,reads from v$asm_disk;
Select group_number,operation,state,power,actual,sofar,est_work,est_rate,est_minutes from v$asm_operation;
select path,total_mb,free_mb from v$asm_disk_stat;
select * from v$asm_operation;
select name,total_mb,free_mb from v$asm_diskgroup;

TIP:
We Found some different between the added new disk and before others disks,the new disk writes and reads from v$asm_disk is zero.

There are two possibilities
1) ASM disk group genuinely does not have enough space to create or extend the datafile.

This possibility was ruled out, as I knew that they added 8g of space ,just trying to create a datafile of size 4g.

2) Another possibility could be, that the disks are not rebalanced (this was the problem is my case)

To check ASM instance alert log, but never rebalance diskgroup info like this:


NOTE: starting rebalance of group 1/0xe7a18492 (DATA_DG) at power 1
Starting background process ARB0

Solution:

Solution is to rebalance the disk manually like this:

alter diskgroup RAC_DISK1 rebalance power 10

OR
Wait rebalance to complete (SUCCESS: rebalance completed for group in ASM alert.log for specific diskgroup)

Note:
We can also speed up the disk rebalance process by changing the value of ASM_POWER_LIMIT parameter (default is 1)

sql>show parameter asm_power_limit
sql>alter system set asm_power_limit=11;

Changing the value of this parameter is only recommended, when there is not much of activity in the database. As rebalance using value 11, will incur high amount of I/O, which may impact day-to-day operations.

We can monitor the rebalance activity by selecting data from v$asm_operation view. We can also check the column “UNBALANCED” in v$asm_diskgroup view. If the disks are correctly balanced, we’ll see default value of N in this column.

One the rebalance is done; we can add the datafile using the same command used before.

References oraclehandson ‘s article


「喜欢文章,快来给作者赞赏墨值吧」
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新发布
暂无内容,敬请期待...
数据库资讯
最新 热门 更多
本月热门
近期活动
全部
暂无活动,敬请期待...
相关课程
全部