当前位置:网站首页>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
边栏推荐
- Machine learning -- naive Bayes
- The interviewer dug a hole for me: what's the use of "/ /" in URI?
- Oracle calculates the difference between two dates in seconds, minutes, hours and days
- Detailed explanation of Oracle tablespace table partition and query method of Oracle table partition
- 集简云 x 飞书深诺,助力企业运营部实现自动化办公
- Utilisation de GDB
- Parameter comparison of several e-book readers
- Database transactions
- PG library checks the name
- sys. dbms_ scheduler. create_ Job creates scheduled tasks (more powerful and rich functions)
猜你喜欢
[machine learning] Note 4. KNN + cross validation
Cross carbon market and Web3 to achieve renewable transformation
Machine learning -- PCA and LDA
Short name of common UI control
[point cloud series] relationship based point cloud completion
[point cloud series] neural opportunity point cloud (NOPC)
[Journal Conference Series] IEEE series template download guide
Tersus notes employee information 516 MySQL query (time period uniqueness judgment of 2 fields)
@Excellent you! CSDN College Club President Recruitment!
How to build a line of code with M4 qprotex
随机推荐
[point cloud series] pointfilter: point cloud filtering via encoder decoder modeling
Example interview | sun Guanghao: College Club grows and starts a business with me
Dolphin scheduler scheduling spark task stepping record
Database transactions
CSDN College Club "famous teacher college trip" -- Hunan Normal University Station
面试官给我挖坑:单台服务器并发TCP连接数到底可以有多少 ?
Dolphin scheduler configuring dataX pit records
[point cloud series] multi view neural human rendering (NHR)
The interviewer dug a hole for me: how many concurrent TCP connections can a single server have?
[point cloud series] summary of papers related to implicit expression of point cloud
QT调用外部程序
软考系统集成项目管理工程师全真模拟题(含答案、解析)
浅谈js正则之test方法bug篇
Lenovo Saver y9000x 2020
Machine learning -- PCA and LDA
"Xiangjian" Technology Salon | programmer & CSDN's advanced road
顶级元宇宙游戏Plato Farm,近期动作不断利好频频
Use of GDB
TCP 复位gongji原理和实战复现
Window analysis function last_ VALUE,FIRST_ VALUE,lag,lead