当前位置:网站首页>Troubleshooting of expdp export error when Oracle table has logical bad blocks
Troubleshooting of expdp export error when Oracle table has logical bad blocks
2022-04-23 13:42:00 【Not dizzy yet】
Feedback from a user EXPDP The export script is interrupted abnormally , An error occurs when a table is exported after access and troubleshooting , backstage ALERT There are corresponding errors in the log ; Finally, it is confirmed that the troubleshooting is a logical bad block problem , After communication, it is known that it is a backup table for a certain period of time , Reset after excluding this table later EXPDP Script , It can be exported normally , The following is the relevant log :
Error reporting and troubleshooting of separate export tables :
[oracle@test1 ~]$ expdp system/oracle directory=expdphis dumpfile=T1.dmp tables=test.test11_0301_BUGGY logfile=T1.log cluster=no
Export: Release 11.2.0.4.0 - Production on Sat Jan 22 12:19:11 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_TABLE_03": system/******** directory=expdphis dumpfile=T1.dmp tables=test.test11_0301_BUGGY logfile=T1.log cluster=no
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3.817 GB
Processing object type TABLE_EXPORT/TABLE/PROCACT_INSTANCE
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/TRIGGER
Job "SYSTEM"."SYS_EXPORT_TABLE_03" stopped due to fatal error at Sat Jan 22 12:22:22 2022 elapsed 0 00:03:04
Check background ALERT journal :
Sat Jan 22 12:19:18 2022
DM00 started with pid=1820, OS id=22939, job SYSTEM.SYS_EXPORT_TABLE_03
ALTER TABLE "SYSTEM"."SYS_EXPORT_TABLE_03" ADD (UNIQUE (process_order, duplicate))
Sat Jan 22 12:19:28 2022
CREATE INDEX SYS_MTABLE_000061006_IND_1 ON "SYSTEM"."SYS_EXPORT_TABLE_03" (object_schema, object_name, object_type)
CREATE INDEX SYS_MTABLE_000061006_IND_2 ON "SYSTEM"."SYS_EXPORT_TABLE_03" (base_process_order)
Sat Jan 22 12:19:29 2022
DW00 started with pid=167, OS id=23647, wid=1, job SYSTEM.SYS_EXPORT_TABLE_03
Sat Jan 22 12:20:21 2022
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2] [PC:0x6DC0806, klufprd()+302] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_dw00_23647.trc (incident=497337):
ORA-07445: exception encountered: core dump [klufprd()+302] [SIGSEGV] [ADDR:0x2] [PC:0x6DC0806] [Address not mapped to object] []
Incident details in: /u01/app/oracle/diag/rdbms/test/test1/incident/incdir_497337/test1_dw00_23647_i497337.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Jan 22 12:20:23 2022
Dumping diagnostic data in directory=[cdmp_20220122122023], requested by (instance=1, osid=23647 (DW00)), summary=[incident=497337].
Sat Jan 22 12:20:23 2022
Sweep [inc][497337]: completed
Sweep [inc2][497337]: completed
Sat Jan 22 12:21:54 2022
Thread 1 advanced to log sequence 49130 (LGWR switch)
Current log# 20 seq# 49130 mem# 0: /hisdata/datafile/group_20.630.1076516067
Current log# 20 seq# 49130 mem# 1: /hisdata/datafile/group_20.12531.1076516069
Sat Jan 22 12:21:54 2022
LNS: Standby redo logfile selected for thread 1 sequence 49130 for destination LOG_ARCHIVE_DEST_2
Sat Jan 22 12:21:54 2022
Archived Log entry 4742 added for thread 1 sequence 49129 ID 0xbcb39845 dest 1:
Sat Jan 22 12:22:22 2022
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$S_1_20220122121913.test','test' SCOPE=MEMORY SID='test1';
ALTER SYSTEM SET service_names='test' SCOPE=MEMORY SID='test1';
Sat Jan 22 11:31:55 2022
LNS: Standby redo logfile selected for thread 1 sequence 49125 for destination LOG_ARCHIVE_DEST_2
Sat Jan 22 11:31:55 2022
Archived Log entry 4722 added for thread 1 sequence 49124 ID 0xbcb39845 dest 1:
Sat Jan 22 11:32:43 2022
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2] [PC:0x6DC0806, klufprd()+302] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_dw03_66684.trc (incident=517785):
ORA-07445: exception encountered: core dump [klufprd()+302] [SIGSEGV] [ADDR:0x2] [PC:0x6DC0806] [Address not mapped to object]
[]
Incident details in: /u01/app/oracle/diag/rdbms/test/test1/incident/incdir_517785/test1_dw03_66684_i517785.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Sat Jan 22 11:32:45 2022
Dumping diagnostic data in directory=[cdmp_20220122113245], requested by (instance=1, osid=66684 (DW03)), summary=[incident=51
7785].
Sat Jan 22 11:32:45 2022
Sweep [inc][517785]: completed
Sweep [inc2][517785]: completed
Sat Jan 22 11:33:50 2022
CREATE TABLE "ET$34613C510001"
( "RQ",
"PATIENT_NO",
"KSDM",
"FEE",
"BQZJ",
"BQJS",
"BQJC",
"SQJC"
) ORGANIZATION EXTERNAL
( TYPE ORACLE_DATAPUMP DEFAULT DIRECTORY "EXPDPHIS" ACCESS PARAMETERS ( DEBUG = (0 , 0) DATAPUMP INTERNAL TABLE "test"."Z
Y_YJK_JCMX" JOB ( "SYSTEM","SYS_EXPORT_SCHEMA_02",23) WORKERID 1 PARALLEL 1 VERSION '11.2.0.4.0' ENCRYPTPASSWORDISNULL COMPR
ESSION ENABLED ENCRYPTION DISABLED ) LOCATION ('bogus.dat') ) PARALLEL 1 REJECT LIMIT UNLIMITED
AS SELECT /*+ PARALLEL(KU$,1) */ "RQ", "PATIENT_NO", "KSDM", "FEE", "BQZJ", "BQJS", "BQJC", "SQJC"
FROM RELATIONAL("test"."ZY_YJK_JCMX" NOT XMLTYPE) AS OF SCN 21109504765917 KU$
DROP TABLE "ET$34613C510001" PURGE
Sat Jan 22 11:34:56 2022
ALTER SYSTEM SET service_names='SYS$SYS.KUPC$S_1_20220122102337.test','test' SCOPE=MEMORY SID='test1';
Sat Jan 22 11:34:57 2022
DW01 terminating with fatal err=39078, pid=683, wid=2, job SYSTEM.SYS_EXPORT_SCHEMA_02
Sat Jan 22 11:34:57 2022
DW00 terminating with fatal err=39078, pid=2233, wid=1, job SYSTEM.SYS_EXPORT_SCHEMA_02
Sat Jan 22 11:34:57 2022
DW02 terminating with fatal err=39079, pid=2662, wid=3, job SYSTEM.SYS_EXPORT_SCHEMA_02
ALTER SYSTEM SET service_names='test' SCOPE=MEMORY SID='test1';
relevant TRACE journal :
[oracle@test1 ~]$ more /u01/app/oracle/diag/rdbms/test/test1/trace/test1_dw03_66684.trc
Trace file /u01/app/oracle/diag/rdbms/test/test1/trace/test1_dw03_66684.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/11.2.0.4/dbhome_1
System name: Linux
Node name: test1
Release: 4.14.35-2025.404.1.2.el7uek.x86_64
Version: #2 SMP Wed Jan 27 20:30:12 PST 2021
Machine: x86_64
Instance name: test1
Redo thread mounted by this instance: 1
Oracle process number: 2723
Unix process pid: 66684, image: oracle@test1 (DW03)
*** 2022-01-22 10:24:22.556
*** SESSION ID:(8230.2561) 2022-01-22 10:24:22.556
*** CLIENT ID:() 2022-01-22 10:24:22.556
*** SERVICE NAME:(SYS$BACKGROUND) 2022-01-22 10:24:22.556
*** MODULE NAME:(Data Pump Worker) 2022-01-22 10:24:22.556
*** ACTION NAME:(SYS_EXPORT_SCHEMA_02) 2022-01-22 10:24:22.556
KUPC: Setting remote flag for this process to FALSE
*** 2022-01-22 11:32:43.553
*** MODULE NAME:(Data Pump Worker) 2022-01-22 11:32:43.557
*** ACTION NAME:(SYS_EXPORT_SCHEMA_02) 2022-01-22 11:32:43.557
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x2] [PC:0x6DC0806, klufprd()+302] [flags: 0x0, count: 1]
Incident 517785 created, dump file: /u01/app/oracle/diag/rdbms/test/test1/incident/incdir_517785/test1_dw03_66684_i51778
5.trc
ORA-07445: exception encountered: core dump [klufprd()+302] [SIGSEGV] [ADDR:0x2] [PC:0x6DC0806] [Address not mapped to object]
[]
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory '/u01/app/oracle/diag/rdbms/test/test1/cdump'
版权声明
本文为[Not dizzy yet]所创,转载请带上原文链接,感谢
https://yzsam.com/2022/04/202204230601579888.html
边栏推荐
- Oracle creates tablespaces and modifies user default tablespaces
- 解决tp6下载报错Could not find package topthink/think with stability stable.
- According to the salary statistics of programmers in June 2021, the average salary is 15052 yuan. Are you holding back?
- Comparison and summary of applicable scenarios of Clickhouse and MySQL database
- Special window function rank, deny_ rank, row_ number
- Migrating your native/mobile application to Unified Plan/WebRTC 1.0 API
- 面试官给我挖坑:单台服务器并发TCP连接数到底可以有多少 ?
- Test on the time required for Oracle to delete data with delete
- Machine learning -- naive Bayes
- SAP ui5 application development tutorial 72 - animation effect setting of SAP ui5 page routing
猜你喜欢
TIA博途中基於高速計數器觸發中斷OB40實現定點加工動作的具體方法示例
Short name of common UI control
How do ordinary college students get offers from big factories? Ao Bing teaches you one move to win!
UEFI learning 01-arm aarch64 compilation, armplatformpripeicore (SEC)
面试官给我挖坑:单台服务器并发TCP连接数到底可以有多少 ?
kettle庖丁解牛第16篇之输入组件周边讲解
Dolphin scheduler source package Src tar. GZ decompression problem
./gradlew: Permission denied
SAP ui5 application development tutorial 72 - trial version of animation effect setting of SAP ui5 page routing
[point cloud series] foldingnet: point cloud auto encoder via deep grid deformation
随机推荐
Launcher hides app icons that do not need to be displayed
Solve tp6 download error course not find package topthink / think with stability stable
Usereducer basic usage
Personal learning related
[machine learning] Note 4. KNN + cross validation
Software test system integration project management engineer full truth simulation question (including answer and analysis)
kettle庖丁解牛第16篇之输入组件周边讲解
Oracle calculates the difference between two dates in seconds, minutes, hours and days
Zero copy technology
Lenovo Savior y9000x 2020
浅谈js正则之test方法bug篇
Use of GDB
Aicoco AI frontier promotion (4.23)
Oracle lock table query and unlocking method
Oracle and MySQL batch query all table names and table name comments under users
[point cloud series] full revolutionary geometric features
GDB的使用
TIA博途中基於高速計數器觸發中斷OB40實現定點加工動作的具體方法示例
Oracle database recovery data
Static interface method calls are not supported at language level '5'