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:\>
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