执行以下语句导出该用户下的所有对象数据
C:\oracle\product\10.2.0\client\BIN\exp.exe username/password@database file=E:\INETPUB\wwwrepa\KHORA.dmp log=KHORA.log OWNER=SD6DBA consistent=y direct=y
导出到一半的时候出现exp进程卡死的现象
*注:看不到命令回显,通过观察,刚执行完以上命令时,dmp文件的大小在不断增加,当增加到一百多M的时候停止增长,试图打开对应的log文件时提示进程正在使用该文件,执行tasklist命令发现有exp.exe进程,如此等待一宿之后,第二天发现情况还是如此,没有任何改变,所以kill掉了exp.exe进程,此时打开log文件内容如下:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SD6DBA
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SD6DBA
About to export SD6DBA's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SD6DBA's tables via Direct Path ...
. . exporting table AREA01 8 rows exported
. . exporting table AREA02 74 rows exported
. . exporting table AREA03 95 rows exported
. . exporting table AREA04 50 rows exported
. . exporting table AREA05 10 rows exported
. . exporting table AREA05K 20 rows exported
. . exporting table I_DAILY 349 rows exported
. . exporting table I_DAILY_BAK 67 rows exported
. . exporting table KHBTO01 34590 rows exported
. . exporting table KHBTO02 133319 rows exported
. . exporting table KHBTO03 123612 rows exported
. . exporting table KHBTO04 5 rows exported
. . exporting table KHBTO05 382 rows exported
. . exporting table KHBTO06 159 rows exported
. . exporting table KHBTO07 644 rows exported
. . exporting table KHBTO08 128 rows exported
. . exporting table KHBTO09 1001 rows exported
. . exporting table KHBTO10 1492 rows exported
. . exporting table KHBTO11 6 rows exported
. . exporting table KHBTO12 5 rows exported
. . exporting table KHBTO13 5 rows exported
. . exporting table KHBTO14 26 rows exported
. . exporting table KHBTO15 2121936 rows exported
. . exporting table KHBTO16 353975 rows exported
. . exporting table KHBTO17 219 rows exported
. . exporting table KHBTO18 7680 rows exported
. . exporting table KHBTO18_TEMP 7410 rows exported
. . exporting table KHBTO19 635819 rows exported
. . exporting table KHBTO20 136 rows exported
. . exporting table KHBTO21 95197 rows exported
. . exporting table KHBTO21_BAK110901 104163 rows exported
. . exporting table KHBTO22 6657792 rows exported
. . exporting table KHBTO23 4675 rows exported
. . exporting table KHBTO24 732 rows exported
. . exporting table KHBTO25 62 rows exported
. . exporting table KHBTO33 74 rows exported
. . exporting table KHBTO34 353 rows exported
. . exporting table KHBTO35 915 rows exported
. . exporting table KHBTO36 6 rows exported
. . exporting table KHBTO37 198 rows exported
. . exporting table KHBTO38 0 rows exported
. . exporting table KHBTO39 152 rows exported
如此执行了三次,结果都是一样,每次都是数据文件停留在差不多相同的大小。小弟对oracle简直是一窍不通啊,刚刚有所接触,不知道为何会导致此问题,如何解决此问题。如果不使用exp备份的话,还有什么更好的热备份方法呢?还请各位大神不吝赐教,百度谷歌了一上午也没找到解决办法。热备份Oracle
C:\oracle\product\10.2.0\client\BIN\exp.exe username/password@database file=E:\INETPUB\wwwrepa\KHORA.dmp log=KHORA.log OWNER=SD6DBA consistent=y direct=y
导出到一半的时候出现exp进程卡死的现象
*注:看不到命令回显,通过观察,刚执行完以上命令时,dmp文件的大小在不断增加,当增加到一百多M的时候停止增长,试图打开对应的log文件时提示进程正在使用该文件,执行tasklist命令发现有exp.exe进程,如此等待一宿之后,第二天发现情况还是如此,没有任何改变,所以kill掉了exp.exe进程,此时打开log文件内容如下:
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user SD6DBA
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user SD6DBA
About to export SD6DBA's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export SD6DBA's tables via Direct Path ...
. . exporting table AREA01 8 rows exported
. . exporting table AREA02 74 rows exported
. . exporting table AREA03 95 rows exported
. . exporting table AREA04 50 rows exported
. . exporting table AREA05 10 rows exported
. . exporting table AREA05K 20 rows exported
. . exporting table I_DAILY 349 rows exported
. . exporting table I_DAILY_BAK 67 rows exported
. . exporting table KHBTO01 34590 rows exported
. . exporting table KHBTO02 133319 rows exported
. . exporting table KHBTO03 123612 rows exported
. . exporting table KHBTO04 5 rows exported
. . exporting table KHBTO05 382 rows exported
. . exporting table KHBTO06 159 rows exported
. . exporting table KHBTO07 644 rows exported
. . exporting table KHBTO08 128 rows exported
. . exporting table KHBTO09 1001 rows exported
. . exporting table KHBTO10 1492 rows exported
. . exporting table KHBTO11 6 rows exported
. . exporting table KHBTO12 5 rows exported
. . exporting table KHBTO13 5 rows exported
. . exporting table KHBTO14 26 rows exported
. . exporting table KHBTO15 2121936 rows exported
. . exporting table KHBTO16 353975 rows exported
. . exporting table KHBTO17 219 rows exported
. . exporting table KHBTO18 7680 rows exported
. . exporting table KHBTO18_TEMP 7410 rows exported
. . exporting table KHBTO19 635819 rows exported
. . exporting table KHBTO20 136 rows exported
. . exporting table KHBTO21 95197 rows exported
. . exporting table KHBTO21_BAK110901 104163 rows exported
. . exporting table KHBTO22 6657792 rows exported
. . exporting table KHBTO23 4675 rows exported
. . exporting table KHBTO24 732 rows exported
. . exporting table KHBTO25 62 rows exported
. . exporting table KHBTO33 74 rows exported
. . exporting table KHBTO34 353 rows exported
. . exporting table KHBTO35 915 rows exported
. . exporting table KHBTO36 6 rows exported
. . exporting table KHBTO37 198 rows exported
. . exporting table KHBTO38 0 rows exported
. . exporting table KHBTO39 152 rows exported
如此执行了三次,结果都是一样,每次都是数据文件停留在差不多相同的大小。小弟对oracle简直是一窍不通啊,刚刚有所接触,不知道为何会导致此问题,如何解决此问题。如果不使用exp备份的话,还有什么更好的热备份方法呢?还请各位大神不吝赐教,百度谷歌了一上午也没找到解决办法。热备份Oracle
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货