問題描述：exp導(dǎo)數(shù)據(jù)時報錯ORA-01578 ORA-01110，如下所示：

數(shù)據(jù)庫：oracle 19.12 多租戶

1、異常重現(xiàn)

[oracle@dbserver ~]$ exp ora1/ora1@orclpdbfile=emp.dmp tables=emp log=exp.log

Export: Release 19.0.0.0.0 - Production onSat Jan 14 20:30:57 2023

Version 19.12.0.0.0

Copyright (c) 1982, 2019, Oracle and/or itsaffiliates. All rights reserved.

Connected to: Oracle Database 19c EnterpriseEdition Release 19.0.0.0.0 - Production

Version 19.12.0.0.0

Export done in US7ASCII character set andAL16UTF16 NCHAR character set

server uses AL32UTF8 character set (possiblecharset conversion)

About to export specified tables viaConventional Path ...

. . exporting table EMP

EXP-00056: ORACLE error 1578 encountered

ORA-01578: ORACLE data block corrupted (file# 12, block # 659)

ORA-01110: data file 12:'+DATA/ORCLCDB/CBB47E352F7AAEA7E0537885A8C03007/DATAFILE/users.279.1082994667'

Export terminated successfully with warnings.

2、解決過程

SQL> conn sys/oracle_4U@orclpdb as sysdba

Connected.

SQL> alter system set events='10231 tracename context forever,level 10';

Session altered.

SQL> select count(*) from ora1.emp;

COUNT(*)

----------

140

[oracle@dbserver ~]$ exportNLS_LANG=AMERICAN_AMERICA.AL32UTF8

[oracle@dbserver ~]$ echo $NLS_LANG

AMERICAN_AMERICA.AL32UTF8

[oracle@dbserver ~]$ exp ora1/ora1@orclpdbfile=emp.dmp tables=emp log=exp.log

Export: Release 19.0.0.0.0 - Production onSat Jan 14 20:41:11 2023

Version 19.12.0.0.0

Copyright (c) 1982, 2019, Oracle and/or itsaffiliates. All rights reserved.

Connected to: Oracle Database 19c EnterpriseEdition Release 19.0.0.0.0 - Production

Version 19.12.0.0.0

Export done in AL32UTF8 character set andAL16UTF16 NCHAR character set

About to export specified tables viaConventional Path ...

. . exporting table EMP 140 rows exported

Export terminated successfully withoutwarnings.

說明：如上成功導(dǎo)出emp表.

補(bǔ)充知識：

--關(guān)閉10231內(nèi)部事件.

altersystem set events='10231 trace name context off';