DATAGUARD报错ORA-01187解决

78 阅读 0 评论 52 点赞

我是靠谱客的博主忧心酒窝，这篇文章主要介绍DATAGUARD报错ORA-01187解决，现在分享给大家，希望可以做个参考。

今天其他组同事说DATAGUARD备库查询系统表的时候报错ORA-01187，根据报错信息是临时表空间检测无法通过，以下是报错信息解释

复制代码

1
2
3
4
ORA-01187: cannot read from file string because it failed verification tests
Cause: The data file did not pass the checks to insure it is part of the database. Reads are not allowed until it is verified.
Action: Make the correct file available to the database. Then, either open the database, or execute ALTER SYSTEM CHECK DATAFILES.

由于备库没有创建表空间的权限，所以直接按主库操作肯定不行。以下是处理方式

复制代码

1
2
3
4
alter database tempfile '/app3/oracle/oradata/cms2/AAATEMP1' drop;
rm -rf /app3/oracle/oradata/cms2/AAATEMP1 #这条语句请在shell下执行
alter tablespace temp add tempfile '/app3/oracle/oradata/cms2/AAATEMP1' SIZE 512M AUTOEXTEND ON NEXT 512M MAXSIZE UNLIMITED;

具体出错原因未知