oracle9i在进行全库备份时出现EXP-00008: ORACLE error 1187 encountered的解决办法

最新推荐文章于 2024-07-04 10:26:47 发布

zhengcairong520yao

最新推荐文章于 2024-07-04 10:26:47 发布

阅读量1.5k

点赞数

分类专栏： oracle数据库

本文链接：https://blog.csdn.net/zhengcairong520yao/article/details/9109813

版权

oracle数据库专栏收录该内容

8 篇文章 0 订阅

订阅专栏

oracle9i在进行数据库全库备份时出现如下错误：

Connected to: Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
Export done in ZHS16GBK character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
EXP-00008: ORACLE error 1187 encountered
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/opt/ora9/product/oradata/NTDB/temp1.dbf'
EXP-00000: Export terminated unsuccessfully
从上面的错误信息可以看出是temp临时表空间的数据文件有问题，解决办法：
1、删除临时表空间： alter database tempfile '/opt/ora9/product/oradata/NTDB/temp1.dbf' drop;
2、重建数据文件：
alter tablespace temp add tempfile '/opt/ora9/product/oradata/NTDB/temp01.dbf' size 512M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED;
通过上述两个步骤就可以解决在进行数据库备份时出现的ORACLE error 1187 encountered错误。