OS:HP UNIX 11.31
DB:ORACLE 11.2.0.3.6 RAC
EXPDP报错:
ORA-31626: job does not exist
ORA-31650: timeout waiting for master process response
修改:aq_tm_processes=1,expdp的时候报错;以为是改小了,调整aq_tm_processes=20,还是报错。
看来不是网上说的,aq_tm_processes的问题。因为这个库在9月5号还能正常expdp,但是今天不行。
回想这期间做过的动作,主要是就是用rda对数据库做过检查。
难道是数据库字典被破坏?查了网络和metalink,都没有相关信息,都是说aq_tm_processes为0造成的。
明显,我的问题不是这样。怀着试试看的想法,重新编译数据字典。
SQL> @?/rdbms/admin/catalog.sql
SQL> @?/rdbms/admin/catproc.sql
然后重启数据库。
再执行expdp;
racdb1:/home/oracle> expdp test/test@racdb1 dumpfile=test_`date +%Y%m%d%H`.dmp directory=dumpdir exclude=statistics tables=test
Export: Release 11.2.0.3.0 - Production on Sun Sep 29 17:31:31 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "test"."SYS_EXPORT_TABLE_01": ss/********@racdb1 dumpfile=ss_2013092917.dmp directory=dumpdir exclude=statistics tables=test
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/COMMENT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
. . exported "test"."test" 6.656 KB 1 rows
Master table "SS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for test.test_01 is:
/var/dumpdir/test_2013092917.dmp
Job "test"."SYS_EXPORT_TABLE_01" successfully completed at 17:31:51
正常导出,看来真是数据字典被破坏。但是,还是不明白数据字典是怎么被破坏的,难道真是rda?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/751371/viewspace-773642/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/751371/viewspace-773642/