On Sep 13, 9:08 pm, arr..._at_inbox.com wrote:
> Transporting tablespaces between platforms worked.
>
> Now I'm trying to transport on the same platform (Windows)
>
> expdp system_at_SRC_INST dumpfile=data.dmp directory=dumpdir
> transport_tablespaces=appdata
>
> I get the dump file & the log file in the dumpdir directory
>
> Then I do 2 separate things:
>
> #1 RMAN
> RMAN> connect target sys_at_SRC_INSTANCE
> RMAN> convert tablespace appdata to platform 'Microsoft Windows IA (32-
> bit)' format 'c://temp/converted_%U';
> RMAN> exit
>
> --tablespace sits on a single datafile, I rename it for simplicity
> cp c://temp/converted_* c://temp/data.dbf
>
> #2, alternatively
> cp ${SRC_ORAHOME}/oradata/${SRC_INST}/data.dbf c://temp/data_cold_backup.dbf
>
> ---------------------------------------------------------------------
> NOW HERE'S WHERE MY PROBLEMS START
> ---------------------------------------------------------------------
>
> Method 1 (trying to import with the RMAN-generated file:
>
> impdp system_at_DEST_INST dumpfile=data.dmp directory=dumpdir
> transport_datafiles=c://temp/data.dbf
>
> Connected to: Oracle Database 10g Enterprise Edition Release
> 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
> Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully
> loaded/unloaded
> Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/
> ********@DEST_INST dumpfile=data.dmp directory=dumpdir
> transport_datafiles=c://temp/data.dbf
> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
> ORA-39123: Data Pump transportable tablespace job aborted
> ORA-19722: datafile c://temp/data.dbf is an incorrect version
>
> Method 2 (trying to import straight with the cold-copied file
> bypassing the conversion):
>
> impdp system_at_DEST_INST dumpfile=data.dmp directory=dumpdir
> transport_datafiles=c://temp/data_cold_backup.dbf
>
> Connected to: Oracle Database 10g Enterprise Edition Release
> 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
> Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully
> loaded/unloaded
> Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/
> ********@DEST_INST dumpfile=data.dmp directory=dumpdir
> transport_datafiles=c://temp/data_cold_backup.dbf
> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
> ORA-39123: Data Pump transportable tablespace job aborted
> ORA-19721: Cannot find datafile with absolute file number 6 in
> tablespace APPDATA
>
> Method 3 (take the cold-backed file and convert it on target)
>
> #1 RMAN
> RMAN> connect target sys_at_DEST_INSTANCE
> RMAN> convert datafile 'c://temp/data_cold_backup.dbf'
> db_file_name_convert 'c://windows/temp', 'c://temp';
> RMAN> exit
>
> impdp system_at_DEST_INST dumpfile=data.dmp directory=dumpdir
> transport_datafiles=c://temp/data_long_converted_name.dbf
>
> Connected to: Oracle Database 10g Enterprise Edition Release
> 10.2.0.1.0 - Production
> With the Partitioning, OLAP and Data Mining options
> Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully
> loaded/unloaded
> Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/
> ********@DEST_INST dumpfile=data.dmp directory=dumpdir
> transport_datafiles=c://temp/data_long_converted_name.dbf
> Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
> ORA-39123: Data Pump transportable tablespace job aborted
> ORA-19721: Cannot find datafile with absolute file number 6 in
> tablespace APPDATA
>
> *************************
>
> So either way, the dump file is accepted, while the datafile isn't.
> But cross-platform, converted files get in ok.
>
> Any ideas?
10.2.0.1? Maybe it is fixed already ... have you opened a service
request or done some searching via metalink?
Received on Fri Sep 14 2007 - 19:25:39 CDT
