从rac impdp 导入数据到 单实例报错。
本帖最后由 Samdy_Chan 于 2013-08-30 11:52:12 编辑
大家好:我是想从64位的 oracle 10g rac 整库导出,然后整库导入到 32位的单实例 oracle 11g,都是 linux 环境 。
我用以下导出命令成功从 oracle 10g RAC 整库导出到 full.dmp文件:
impdp "'/ as sysdba'" directory=dmp_dir dumpfile=full.dmp full=y paralle=5 versionl=10.2.0.3.0
但导入到 32位的单实例的 oracle 11g 时出现如下错误:
impdp "'sys/sys123@demo as sysdba'" directory=dmp_dir dumpfile=full.dmp logfile=imp.log remap_datafile=+DATA/WXXRDB/DATAFILE/mytbs01.dbf:/oracle/oradata/demo/mytbs.dbf full=y parallel=5 version=11.2.0.1.0
Processing object type DATABASE_EXPORT/TABLESPACE
ORA-31684: Object type TABLESPACE:"UNDOTBS1" already exists
ORA-31684: Object type TABLESPACE:"SYSAUX" already exists
ORA-31684: Object type TABLESPACE:"TEMP" already exists
ORA-39083: Object type TABLESPACE failed to create with error:
ORA-01276: Cannot add file +DATA/wxxrdb/datafile/undotbs2.263.813114239. File has an Oracle Managed Files file name.
Failing sql is:
CREATE UNDO TABLESPACE "UNDOTBS2" DATAFILE '+DATA/wxxrdb/datafile/undotbs2.263.813114239' SIZE 209715200 AUTOEXTEND ON NEXT 5242880 MAXSIZE 32767M BLOCKSIZE 8192 EXTENT MANAGEMENT LOCAL AUTOALLOCATE
ORA-31684: Object type TABLESPACE:"USERS" already exists
----------
我已经用 remap_datafile 了,为什么还是创建不了 mytbs 表空间的和数据文件呢:ORA-01276: Cannot add file +DATA/wxxrdb/datafile/undotbs2.263.813114239. File has an Oracle Managed Files file name.
我想整库导入到单实例中,请问我以上哪里出错了,要实现从我的 oracle 10g rac 整库导入到单实例11g中,正确的 expdp 和 impdp 应该怎么写呢?
哪位大侠可以帮忙写给我测试参考一下吗?
待复,衷心感谢!
------解决方案--------------------full是导出全库结构,每个库的结构都不相同,不建议使用full