0 Replies Latest reply on May 3, 2019 6:30 PM by user12167109

    Tablespace Transportable / ASM - Oracle 12

    user12167109

      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