- 论坛徽章:
- 0
|
有谁遇到过这样的情况?
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set
About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions
. exporting system procedural objects and actions.
上面是执行exp之后的信息,完整的exp语句为:
exp system/123456@TEST FILE="TEST.dmp" FULL=y LOG="TEST.log";
之前也一直使用该语句,可以正常备份,昨天晚上执行定时备份没成功,发现停在. exporting system procedural objects and actions.这一句,而且8个CPU核心中的1个使用率为100%,没办法,只有kill掉该exp进程,之后CPU恢复,数据库仍然可用。
另外,执行以下exp语句可以正常结束:
exp system/123456@TEST FILE="TEST.dmp" OWNER=test LOG="TEST.log";
由于exp没有报错,只是卡在那一句,时间有8小时左右,远超正常时间,所以,实在想不出办法,请论坛上的高手帮忙。 |
|