Wednesday, 12 June 2019

expdp error fails DETERMINE_FATAL_ERROR with ORA-01157: cannot identify/lock data file 202 - see DBWR trace file

NOTE : In this scenario using rman backup we have restored from linux to window  12.1.0.2.0 version , After than when we apply expdp it throws an error. after finding out one of tempfile was not created, created tempfile and expdp completed.

D:\>expdp \"sys/infodba@SMRPRODB as sysdba\" dumpfile=expdpSMRwindow.dmp directory=expdp_w logfile=expdpSMRwinodow.log FULL=Y EXCLUDE=STATISTICS CONTE
NT=ALL JOB_NAME=FULL_EXPDP

Export: Release 12.1.0.2.0 - Production on Sun Jun 9 17:32:09 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, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYS"."FULL_EXPDP":  "sys/********@SMRPRODB AS SYSDBA" dumpfile=expdpSMRwindow.dmp directory=expdp_w logfile=expdpSMRwinodow.log FULL=Y EXCLU
DE=STATISTICS CONTENT=ALL JOB_NAME=FULL_EXPDP
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/EARLY_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/TABLE_DATA
Processing object type DATABASE_EXPORT/NORMAL_OPTIONS/VIEWS_AS_TABLES/TABLE_DATA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 1.986 GB
Processing object type DATABASE_EXPORT/PRE_SYSTEM_IMPCALLOUT/MARKER
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [MARKER]
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '/u04/MasterDB/oradata/SMRPRODB/temp02.dbf'

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
000000268F3EC4A0     27116  package body SYS.KUPW$WORKER
000000268F3EC4A0     11286  package body SYS.KUPW$WORKER
000000268F3EC4A0     13515  package body SYS.KUPW$WORKER
000000268F3EC4A0      3173  package body SYS.KUPW$WORKER
000000268F3EC4A0     12035  package body SYS.KUPW$WORKER
000000268F3EC4A0      2081  package body SYS.KUPW$WORKER
000000269F44FC18         2  anonymous block

In procedure BUILD_OBJECT_STRINGS
In procedure BUILD_SUBNAME_LIST with MARKER:.
In function NEXT_PO_NUMBER
FORALL
FORALL
DBMS_LOB.TRIM
DBMS_LOB.TRIM
DBMS_METADATA.FETCH_XML_CLOB
DBMS_METADATA.FETCH_XML_CLOB
In procedure DETERMINE_FATAL_ERROR with ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '/u04/MasterDB/oradata/SMRPRODB/temp02.dbf'
Processing object type DATABASE_EXPORT/PRE_INSTANCE_IMPCALLOUT/MARKER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [MARKER]
ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '/u04/MasterDB/oradata/SMRPRODB/temp02.dbf'

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
000000268F3EC4A0     27116  package body SYS.KUPW$WORKER
000000268F3EC4A0     11286  package body SYS.KUPW$WORKER
000000268F3EC4A0     13515  package body SYS.KUPW$WORKER
000000268F3EC4A0      3173  package body SYS.KUPW$WORKER
000000268F3EC4A0     12035  package body SYS.KUPW$WORKER
000000268F3EC4A0      2081  package body SYS.KUPW$WORKER
000000269F44FC18         2  anonymous block

In procedure BUILD_OBJECT_STRINGS
In procedure BUILD_SUBNAME_LIST with MARKER:.
In function NEXT_PO_NUMBER
FORALL
FORALL
DBMS_LOB.TRIM
DBMS_LOB.TRIM
DBMS_METADATA.FETCH_XML_CLOB
DBMS_METADATA.FETCH_XML_CLOB
In procedure DETERMINE_FATAL_ERROR with ORA-01157: cannot identify/lock data file 202 - see DBWR trace file
ORA-01110: data file 202: '/u04/MasterDB/oradata/SMRPRODB/temp02.dbf'
Job "SYS"."FULL_EXPDP" stopped due to fatal error at Sun Jun 9 17:32:20 2019 elapsed 0 00:00:09




D:\>

No comments:

Post a Comment