DATAGUARD报错ORA-01187解决

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

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.

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

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;

具体出错原因未知

最后

以上就是忧心酒窝为你收集整理的DATAGUARD报错ORA-01187解决的全部内容，希望文章能够帮你解决DATAGUARD报错ORA-01187解决所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。