expdp 導出 ORA-31638 ORA-25448 錯誤處理

expdp 導出報以下毛病：

[oracle@dg1 ~]$ expdp  directory=backup dumpfile=user.dmplogfile=user.log schemas=dave

Export: Release 11.2.0.3.0 - Production onThu Aug 28 00:28:34 2014

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

Username: / as sysdba

Connected to: Oracle Database 11gEnterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Miningand Real Application Testing options

ORA⑶1626: job does not exist

ORA⑶1638: cannot attach to jobSYS_EXPORT_SCHEMA_01 for user SYS

ORA-06512: at"SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT_INT",line 428

ORA⑶9077: unable to subscribe agentKUPC$A_1_002838232151000 to queue "KUPC$C_1_20140828002837"

ORA-06512: at"SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE_INT",line 250

ORA⑵5448: ruleSYS.KUPC$C_1_20140828002837$5 has errors

ORA-00376: file 2 cannot be read at thistime

ORA-01110: data file 2: '/u01/app/oracle/oradata/dave/sysaux01.dbf'

--查看數據文件狀態：

SQL> col file_name for a50

SQL> select file_name,status fromdba_data_files;

FILE_NAME                   STATUS

-----------------------------------------------------------

/u01/app/oracle/oradata/dave/users01.dbf     AVAILABLE

/u01/app/oracle/oradata/dave/undotbs01.dbf      AVAILABLE

/u01/app/oracle/oradata/dave/sysaux01.dbf   AVAILABLE

/u01/app/oracle/oradata/dave/system01.dbf   AVAILABLE

/u01/dave01.dbf                AVAILABLE

/u01/dropspace02.dbf               AVAILABLE

/u01/dropspace03.dbf               AVAILABLE

/u01/dropspace04.dbf               AVAILABLE

/u01/fsf01.dbf                     AVAILABLE

/u01/dropspace01.dbf               AVAILABLE

10 rows selected.

toad 中也沒法查看表空間，用sys用戶連接的，權限不可能不夠：

查看數據庫狀態：

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ WRITE

alert log 也沒有毛病。

開始重點放在以下部份：

ORA⑶1638: cannot attach to jobSYS_EXPORT_SCHEMA_01 for user SYS

ORA-06512: at"SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPV$FT_INT",line 428

ORA⑶9077: unable to subscribe agentKUPC$A_1_002838232151000 to queue "KUPC$C_1_20140828002837"

ORA-06512: at"SYS.DBMS_SYS_ERROR", line 95

ORA-06512: at "SYS.KUPC$QUE_INT",line 250

ORA⑵5448: ruleSYS.KUPC$C_1_20140828002837$5 has errors

結果還是數據文件的問題， sysaux01.dbf 是offline的。 這個環境之前做過很多測試，也不清楚哪次給弄成offline了。

SQL> select file_name,online_status fromdba_data_files;

FILE_NAME                   ONLINE_

---------------------------------------------------------

/u01/app/oracle/oradata/dave/users01.dbf    ONLINE

/u01/app/oracle/oradata/dave/undotbs01.dbf      ONLINE

/u01/app/oracle/oradata/dave/sysaux01.dbf   OFFLINE

/u01/app/oracle/oradata/dave/system01.dbf    SYSTEM

/u01/dave01.dbf                ONLINE

/u01/dropspace02.dbf               RECOVER

/u01/dropspace03.dbf               RECOVER

/u01/dropspace04.dbf               RECOVER

/u01/fsf01.dbf                     ONLINE

/u01/dropspace01.dbf               OFFLINE

10 rows selected.

online 以后，恢復正常：

SQL> alter database datafile'/u01/app/oracle/oradata/dave/sysaux01.dbf' online;

Database altered.

SQL> select file_name,online_status fromdba_data_files;

FILE_NAME                   ONLINE_

---------------------------------------------------------

/u01/app/oracle/oradata/dave/users01.dbf    ONLINE

/u01/app/oracle/oradata/dave/undotbs01.dbf      ONLINE

/u01/app/oracle/oradata/dave/sysaux01.dbf    ONLINE

/u01/app/oracle/oradata/dave/system01.dbf    SYSTEM

/u01/dave01.dbf                ONLINE

/u01/dropspace02.dbf               RECOVER

/u01/dropspace03.dbf               RECOVER

/u01/dropspace04.dbf               RECOVER

/u01/fsf01.dbf                     ONLINE

/u01/dropspace01.dbf               OFFLINE

10 rows selected.

Toad 也正常：

--------------------------------------------------------------------------------------------

版權所有，文章制止轉載，否則追究法律責任!

AboutDave:

--------------------------------------------------------------------------------------------

QQ:     251097186

Email:    tianlesoftware@gmail.com

Blog:    http://blog.csdn.net/tianlesoftware

Weibo:    http://weibo.com/tianlesoftware

Twitter:  http://twitter.com/tianlesoftware

Facebook: http://www.facebook.com/tianlesoftware

Linkedin: http://cn.linkedin.com/in/tianlesoftware

Dave 的QQ群：

--------------------------------------------------------------------------------------------

注意:加群必須注明表空間和數據文件關系 | 不要重復加群

CNDBA_1: 62697850 (空)    CNDBA_2: 62697716 (滿)  CNDBA_3: 283816689

CNDBA_4: 391125754   CNDBA_5:104207940    CNDBA_6: 62697977   CNDBA_7: 142216823（滿）

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈