ORA-19722: datafile is an incorrect version | ORA-39123: Data Pump transportable tablespace job aborted
ORA-19722: datafile is an incorrect version |
ORA-19722 indicates the mismatch of
the datafile version on the basis of SCN value. I got this when trying to
transport the tablespace from one database to another database. Read my post
regarding Transporting the tablespace between databases to get to know more
about the process. See below the step I was performing when I got the error:
C:\Users\parain>impdp directory=DB_DUMP dumpfile=TRANS_TAB.DMP logfile=impTRANSTAB.log transport_datafiles=
'F:\DATABASE\ORADB11G\TRANSTAB01.DBF'
Import: Release 11.2.0.4.0 - Production on Thu May 10 17:30:23 2018
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Username: system@oradb112
Password:
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/********@oradb112 directory=DB_DUMP dumpfile=TRANS_TAB.DMP
logfile=impTRANSTAB.log transport_datafiles='F:\DATABASE\ORADB11G\TRANSTAB01.DBF'
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-19722: datafile F:\DATABASE\ORADB11G\TRANSTAB01.DBF is an incorrect version
Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at Thu May 10 17:30:36 2018 elapsed 0 00:00:02
Resolution:
The reason I got the error was I
copied the datafile after I put the tablespace back in READ WRITE mode. Since
the EXPDP backup was taken when the tablespace was in READ ONLY mode, the
datafile was also meant to be copied at the same time. Make sure you are not
making the same mistake if you are getting this error.
I hope this helps !!
No comments:
Post a Comment