Tablespace Transportable / ASM - Oracle 12 — oracle-tech

    Forum Stats

  • 3,714,741 Users
  • 2,242,616 Discussions
  • 7,845,043 Comments

Discussions

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Tablespace Transportable / ASM - Oracle 12

user12167109
user12167109 Member Posts: 1

I need do a task of transportable tablespoces, using exadata and databases oracle 12.1.0.2. When I do the import have error's, that suppose is by the ASM.

Any person some time did or do this task in these condiones.

The error is:

$ORACLE_HOME/bin/impdp "'/ as sysdba'" directory=impdp_dir dumpfile=DATOS_APUBLICAR_PEF.dmp transport_datafiles=+DATAC1/ASM/DATAFILE/DATOS_APUBLICAR_PEF.dbf.598.1007305559 remap_tablespace=DATOS_APUBLICAR_PEF:DATOS_PEF remap_schema=produccion:prod_sici

Import: Release 12.1.0.2.0 - Production on Fri May 3 15:23:10 2019

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production

With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

Advanced Analytics and Real Application Testing options

Master table "SYS"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded

Starting "SYS"."SYS_IMPORT_TRANSPORTABLE_01":  "/******** AS SYSDBA" directory=impdp_dir dumpfile=DATOS_APUBLICAR_PEF.dmp transport_datafiles=+DATAC1/ASM/DATAFILE/DATOS_APUBLICAR_PEF.dbf.598.1007305559 remap_tablespace=DATOS_APUBLICAR_PEF:DATOS_PEF remap_schema=produccion:prod_sici

Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK

ORA-39123: Data Pump transportable tablespace job aborted

ORA-19722: datafile +DATAC1/ASM/DATAFILE/DATOS_APUBLICAR_PEF.dbf.598.1007305559 is an incorrect version

Job "SYS"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at Fri May 3 15:23:11 2019 elapsed 0 00:00:01

Is possible that this copying wrong the file in AMS?

Thank you

Sign In or Register to comment.