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-31626: job does not exist

ORA-31638: 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-39077: 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-25448: 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-31638: 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-39077: 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-25448: 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