ORA-15081: failed to submit an I/O operation to a disk

本文详细阐述了在安装Grid基础设施后,使用RMAN和DBCA从文件系统或磁带环境恢复控制文件时遇到的错误。通过检查ASMDisks权限并调整访问权限为777,成功解决了无法创建指定目录的问题。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Problem:

While restoring controlfile to test environment, from filesystem or tape environment after installing grid infrastructure.

I got following errors from both RMAN  and DBCA, despite the fact that I could create directory alias in asmcmd.

RMAN> run {

2> allocate channel t1 device type ‘SBT_TAPE’

3> parms ‘ENV=(NSR_SERVER=bcksrv1, NSR_CLIENT=mydb, NSR_DATA_VOLUME_POOL=JB10)’;

4> RESTORE controlfile to ‘+DATA’ FROM ‘/tmp/ctl01.dbf’;

5> release channel t1 ;

6> }

allocated channel: t1

channel t1: SID=386 device type=SBT_TAPE

channel t1: NMO v5.0.0.0

Starting restore at 29-MAY-12

released channel: t1

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of restore command at 05/29/2012 14:31:34

ORA-19504: failed to create file “+DATA”

ORA-15045: ASM file name ‘+DATA’ is not in reference form

ORA-17502: ksfdcre:5 Failed to create file +DATA

ORA-15081: failed to submit an I/O operation to a disk

ORA-19600: input file is control file  (/tmp/ctl01.dbf)

ORA-19601: output file is control file  (+DATA)

Cause:

Access rights to oracle disk.

Solution:

I checked the asm disks. /dev/rdsk/disk * has grid:oinstall ownership.

Grid infra home and bin has grid:oinstall, while the oracle home and bin has oracle:oinstall, as told in the MOS.

In our case, access rights on disk device files, are not 77x. As the second 7 means access to group oinstall.

I changed the access rights to 777 and it worked.

 

转载于:https://www.cnblogs.com/tmao/p/4754877.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值