暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

rman convert 转换报错 ora-17503 ora-15001 ora-15055

1889

今天中午进行一次将 AIX 环境下的 11203 RAC 迁移到 Linuxone 11204 RAC 下,数据迁移测试过程中 convert 转换具体报错如下:

channel ORA_DISK_32: SID=10906 device type=DISK
allocated channel: ORA_DISK_33
channel ORA_DISK_33: SID=11282 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of conversion at target command at 01/07/2021 12:53:31
ORA-19625: error identifying file +DATA/Jieke1/datafile/system.335.894968283
ORA-17503: ksfdopn:2 Failed to open file +DATA/Jieke1/datafile/system.335.894968283
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15055: unable to connect to ASM instance
ORA-12545: Connect failed because target host or object does not exist

脚本如下:

vim rman_convert.cmd
CONVERT FROM PLATFORM 'AIX-Based Systems (64-bit)'
PARALLELISM 20
datafile '+DATA/Jieke1/datafile/system.335.894968283' format '+DATA_DB/Jieke/datafile/system.335.dbf'                                                                                           
datafile '+DATA/Jieke1/datafile/sysaux.302.894995403' format '+DATA_DB/Jieke/datafile/sysaux.302.dbf'
……………省略很多数据转换…………………
; 
cat rman_convert.sh
date
rman target / cmdfile=rman_convert.cmd log=rman_convert.log
date

转换过程:

sqlplus / as sysdba
startup nomount pfile=’/home/oracle/pfile.ora’
ORACLE instance started.

Total System Global Area 1.4217E+11 bytes
Fixed Size 2235608 bytes
Variable Size 1.4496E+10 bytes
Database Buffers 1.2724E+11 bytes
Redo Buffers 433958912 bytes
SQL>
SQL> exit

执行转换脚本

nohup sh rman_convert.sh &

查看日志 tail -20f rman_convert.log
报错 ora-17503 ora-15001 ora-15055

经过多方查看,ASM 实例正常,磁盘组正常,oracle、grid 用户组正常,不存在 6751 权限问题。

id oracle 
uid=1101(oracle) gid=1000(oinstall) groups=10100(asmadmin),10110(asmdba),1001(dba),1002(oper),1000(oinstall)
id grid 
uid=1100(grid) gid=1000(oinstall) groups=10100(asmadmin),10110(asmdba),10120(asmoper),1001(dba),1002(oper),1000(oinstall)

检查实例,有所发现:

Jieker1:/home/oracle(Jieke1)>ps -ef | grep smon
oracle 1326 90607 0 14:31 pts/2 00:00:00 grep smon
grid 17960 1 0 09:38 ? 00:00:00 asm_smon_+ASM1
oracle 107374 1 0 13:59 ? 00:00:00 ora_smon_Jieke1
oracle 120101 1 0 14:26 ? 00:00:00 ora_smon_Jieke1

经查看,发现同一服务器有启动两个相同实例, 11204 open ,11023 刚通过参数文件 started.关闭 11204 实例后可正常转换。

————————————————————————————
公众号:JiekeXu之路
墨天轮:https://www.modb.pro/u/4347
CSDN :https://blog.csdn.net/JiekeXu
腾讯云:https://cloud.tencent.com/developer/user/5645107
————————————————————————————

0d.png

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

评论