Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

999

积分

1

好友

942

主题
1#
发表于 2017-4-12 18:30:20 | 查看: 1964| 回复: 0
刚刚接触oracle不久,最近做window 32位系统下数据库(oracle10g)到 linux 64位系统(oracle11g)的表空间迁移,遇到如下问题:
将数据从原库中通过rman工具命令transport tablespace导出后,上传至linux系统中,执行impdp导入出现如下问题:
$ impdp system/xxxxx@xxx directory=dumpdir dumpfile='DMPFILE.DMP' transport_datafiles=/oracle/ora11g/oradata/elms/PERFSTAT01.DBF,/oracle/ora11g/oradata/elms/USERS001.DBF,/oracle/ora11g/oradata/elms/TBS_ELMS_8610_DEV_PRD01.DBF logfile=imp_8610_three.log
Import: Release 11.2.0.3.0 - Production on Sat Jan 5 10:20:24 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-31694: master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" failed to load/unload
ORA-31640: unable to open dump file "/oracle/ora11g/oradata/elmsdg/DMPFILE.DMP" for read
ORA-19505: failed to identify file "/oracle/ora11g/oradata/elmsdg/DMPFILE.DMP"
ORA-27046: file size is not a multiple of logical block size
Additional information: 1

请高手们帮忙看看,是怎么回事啊,我在window下执行导入时,可正常导入,但是编译(utlirp.sql)是又有报错:select to_number('must_be_open_upgrade')from v$instance where status !='open migrate'--------ora-01722:无效的数字。
下载专业ORACLE数据库恢复工具PRM-DUL  For Oracle http://www.parnassusdata.com/

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线 : 13764045638  QQ: 47079569     邮箱:service@parnassusdata.com
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-20 16:13 , Processed in 0.045947 second(s), 21 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569