今天中午进行一次将 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
————————————————————————————





