Sunday 13 May 2018

ORA-19722: datafile is an incorrect version - Oracle Database

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