-- IMPDP_TRANS_TBSP_SOL.par -- DIRECTORY=DATA_PUMP_DIR DUMPFILE=impdp_site_trans_tbsp_sol.dmp LOGFILE=site_imp-dump_tdb-solaris.log TRANSPORT_DATAFILES= /dtaarea2/oracle/data/site/users01.dbf, /dtaarea2/oracle/datafiles/site/site_data_01.dbf, /dtaarea2/oracle/datafiles/site/site_data_02.dbf, /dtaarea2/oracle/datafiles/site/site_data_03.dbf, /dtaarea2/oracle/datafiles/site/site_data_04.dbf, /dtaarea2/oracle/datafiles/site/site_data_05.dbf, /dtaarea2/oracle/datafiles/site/site_data_06.dbf, /dtaarea2/oracle/datafiles/site/sqlt_data_01.dbf, /dtaarea3/oracle/datafiles/site/audit_mv_data_01.dbf, /dtaarea3/oracle/datafiles/site/audit_mv_data_02.dbf, /dtaarea3/oracle/datafiles/site/audit_mv_data_03.dbf, /dtaarea3/oracle/datafiles/site/audit_mv_data_04.dbf, /dtaarea3/oracle/datafiles/site/audit_mv_data_05.dbf, /dtaarea3/oracle/datafiles/site/audit_mv_data_06.dbf, /dtaarea3/oracle/datafiles/site/audit_mv_index_01.dbf, /dtaarea3/oracle/datafiles/site/audit_mv_index_02.dbf, /dtaarea3/oracle/datafiles/site/ent_entity_data_01.dbf, /dtaarea3/oracle/datafiles/site/ent_entity_data_02.dbf, /dtaarea3/oracle/datafiles/site/ent_entity_data_03.dbf, /dtaarea3/oracle/datafiles/site/ent_entity_data_04.dbf, /dtaarea3/oracle/datafiles/site/ent_entity_index_01.dbf, /dtaarea3/oracle/datafiles/site/ent_entity_index_02.dbf, /dtaarea3/oracle/datafiles/site/ent_individual_data_01.dbf, /dtaarea3/oracle/datafiles/site/ent_individual_data_02.dbf, /dtaarea3/oracle/datafiles/site/ent_individual_data_03.dbf, /dtaarea3/oracle/datafiles/site/ent_individual_data_04.dbf, /dtaarea3/oracle/datafiles/site/ent_individual_index_01.dbf, /dtaarea3/oracle/datafiles/site/ent_individual_index_02.dbf, /dtaarea3/oracle/datafiles/site/ent_industry_occupation_data_01.dbf, /dtaarea3/oracle/datafiles/site/ent_industry_occupation_data_02.dbf, /dtaarea3/oracle/datafiles/site/ent_industry_occupation_data_03.dbf, /dtaarea3/oracle/datafiles/site/ent_industry_occupation_data_04.dbf, /dtaarea3/oracle/datafiles/site/ent_industry_occupation_index_01.dbf, /dtaarea3/oracle/datafiles/site/ent_industry_occupation_index_02.dbf, /dtaarea3/oracle/datafiles/site/ent_location_data_01.dbf, /dtaarea3/oracle/datafiles/site/ent_location_data_02.dbf, /dtaarea3/oracle/datafiles/site/ent_location_data_03.dbf, /dtaarea3/oracle/datafiles/site/ent_location_data_04.dbf, /dtaarea3/oracle/datafiles/site/ent_location_data_05.dbf, /dtaarea3/oracle/datafiles/site/ent_location_index_01.dbf, /dtaarea3/oracle/datafiles/site/ent_location_index_02.dbf, /dtaarea3/oracle/datafiles/site/ent_location_index_03.dbf, /dtaarea3/oracle/datafiles/site/ent_organization_data_01.dbf, /dtaarea3/oracle/datafiles/site/ent_organization_data_02.dbf, /dtaarea3/oracle/datafiles/site/ent_organization_data_03.dbf, /dtaarea3/oracle/datafiles/site/ent_organization_data_04.dbf, /dtaarea3/oracle/datafiles/site/ent_organization_index_01.dbf, /dtaarea3/oracle/datafiles/site/ent_organization_index_02.dbf, /dtaarea3/oracle/datafiles/site/ent_trade_name_data_01.dbf, /dtaarea3/oracle/datafiles/site/ent_trade_name_data_02.dbf, /dtaarea3/oracle/datafiles/site/ent_trade_name_data_03.dbf, /dtaarea3/oracle/datafiles/site/ent_trade_name_data_04.dbf, /dtaarea3/oracle/datafiles/site/ent_trade_name_index_01.dbf, /dtaarea3/oracle/datafiles/site/ent_trade_name_index_02.dbf, /dtaarea3/oracle/datafiles/site/site_data_07.dbf, /dtaarea3/oracle/datafiles/site/site_data_08.dbf, /dtaarea3/oracle/datafiles/site/site_data_09.dbf, /dtaarea3/oracle/datafiles/site/site_data_10.dbf, /dtaarea3/oracle/datafiles/site/site_data_11.dbf, /dtaarea3/oracle/datafiles/site/site_data_12.dbf, /dtaarea3/oracle/datafiles/site/site_data_13.dbf, /dtaarea3/oracle/datafiles/site/site_data_14.dbf, /dtaarea3/oracle/datafiles/site/site_data_16.dbf, /dtaarea3/oracle/datafiles/site/site_master_data_01.dbf, /dtaarea3/oracle/datafiles/site/site_work_data_01.dbf, /dtaarea3/oracle/datafiles/site/sitemaster1_work1_data_01.dbf, /dtaarea3/oracle/datafiles/site/sitemaster1_work1_data_02.dbf, /dtaarea3/oracle/datafiles/site/sitemaster1_work1_data_03.dbf, /dtaarea3/oracle/datafiles/site/sitemaster1_work1_data_04.dbf, /dtaarea3/oracle/datafiles/site/odi_user_data_01.dbf, /dtaarea3/oracle/datafiles/site/odi_user_data_02.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_data_01.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_data_02.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_data_03.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_data_04.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_data_01.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_data_02.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_data_03.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_data_04.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_hist_index_01.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_hist_index_02.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_history_data_01.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_history_data_02.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_history_data_03.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_history_data_04.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_index_01.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_form_type_index_02.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_index_01.dbf, /dtaarea3/oracle/datafiles/site/rev_acc_index_02.dbf, /dtaarea3/oracle/datafiles/site/rev_entity_acc_data_01.dbf, /dtaarea3/oracle/datafiles/site/rev_entity_acc_data_02.dbf, /dtaarea3/oracle/datafiles/site/rev_entity_acc_data_03.dbf, /dtaarea3/oracle/datafiles/site/rev_entity_acc_data_04.dbf, /dtaarea3/oracle/datafiles/site/rev_entity_acc_index_01.dbf, /dtaarea3/oracle/datafiles/site/rev_entity_acc_index_02.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_data_01.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_data_02.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_data_03.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_data_04.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_data_05.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_index_01.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_index_02.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_index_03.dbf, /dtaarea3/oracle/datafiles/site/revled_rev_period_index_04.dbf, /dtaarea4/oracle/datafiles/site/ent_entity_data_05.dbf, /dtaarea4/oracle/datafiles/site/ent_individual_data_05.dbf, /dtaarea4/oracle/datafiles/site/ent_individual_index_03.dbf, /dtaarea4/oracle/datafiles/site/ent_industry_occupation_index_03.dbf, /dtaarea4/oracle/datafiles/site/site_data_15.dbf, /dtaarea4/oracle/datafiles/site/site_data_16.dbf, /dtaarea4/oracle/datafiles/site/site_data_17.dbf, /dtaarea4/oracle/datafiles/site/site_data_18.dbf, /dtaarea4/oracle/datafiles/site/sitestg_data_01.dbf, /dtaarea4/oracle/datafiles/site/sitestg_data_02.dbf, /dtaarea4/oracle/datafiles/site/sitestg_index_01.dbf, /dtaarea4/oracle/datafiles/site/sitestg_index_02.dbf, /dtaarea4/oracle/datafiles/site/odi_user_data_03.dbf -- Data Pumps execution -- ========================================================================================= ** AFFECTED DATAFILE RECREATED BEFORE DATA PUMP EXECUTION ** ========================================================================================= $ impdp system/password parfile=IMPDP_TRANS_TBSP_SOL.par Import: Release 10.2.0.5.0 - 64bit Production on Thursday, 14 June, 2017 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** parfile=IMPDP_TRANS_TBSP_SOL.par Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK ORA-39123: Data Pump transportable tablespace job aborted ORA-29349: tablespace 'AUDIT_MV_INDEX' already exist Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error ========================================================================================= ** AFFECTED INDEX DATAFILE DROPPED PRIOR TO DATA PUMP EXECUTION ** ========================================================================================= $ impdp system/password parfile=IMPDP_TRANS_TBSP_SOL.par Import: Release 10.2.0.5.0 - 64bit Production on Thursday, 15 June, 2017 Copyright (c) 2003, 2007, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01": system/******** parfile=IMPDP_TRANS_TBSP_SOL.par Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK ORA-39123: Data Pump transportable tablespace job aborted ORA-01565: error in identifying file '/dtaarea3/oracle/datafiles/site/audit_mv_index_01.dbf' ORA-27037: unable to obtain file status SVR4 Error: 2: No such file or directory Additional information: 3 Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error