You may receive this error under below circumstances.
1. when your temp file drive failed
2. when you duplicate your database.
3. When you trying to take backup controlfile to trace….etc
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/u03/oradata/TEST/temp01.dbf'
The temp data file didn’t not pass the checks to insure it is part of the database and reads are not allowed until it is verified.
You will see the status as “ONLINE” when you check the status of the temp file using v$tempfile. But when you query DBA_TEMP_FILES’, you will receive the error.
SQL> SELECT FILE_ID,FILE_NAME, STATUS FROM DBA_TEMP_FILES;
ERROR at line 1:
ORA-01187: cannot read from file 201 because it failed verification tests
ORA-01110: data file 201: '/u03/oradata/AGX/temp01.dbf'
To resolve this issue first run below command and query DBA_TEMP_FILES.
SQL> ALTER SYSTEM CHECK DATAFILES
If you still have the issues then add a tempfile and drop the file which has issues.
SQL> ALTER TABLESPACE TEMP ADD TEMPFILE ‘'/u03/oradata/TEST/temp02.dbf' SIZE 100M;
SQL> ALTER DATABASE TEMPFILE TEMPFILE ‘'/u03/oradata/TEST/temp01.dbf' DROP;
This should resolve your issue.
Regards,
Satishbabu Gunukula
http://www.oracleracexpert.com
Subscribe to:
Post Comments (Atom)
nice one and helpful.
ReplyDeleteThanks&Regards
Muhammad Abdul Halim
http://halimdba.blogspot.com/
Hello Satishbabu,
ReplyDeleteThank you for sharing this information. It will help database administrator to resolve problems.
Regards,
Mark Willium
http://oraclerecovery.blogspot.com/
Thanks , remove one 'TEMPFILE' from last statement.
ReplyDeleteSQL> ALTER DATABASE TEMPFILE TEMPFILE ‘'/u03/oradata/TEST/temp01.dbf' DROP;
Great and Useful Article.
ReplyDeleteJava Online Training
Java Course Online
Java EE course
Java Course in Chennai
Java Training in Chennai
Java Training Institutes in Chennai
Java Interview Questions
Java Interview Questions
شركة نقل عفش بابها
ReplyDeleteشركة نقل عفش بنجران
شركة نقل عفش بحائل
It's great that you are telling us about these things.
ReplyDeleteindependentescortslondon.com
تلك الشركات التي تستخدم سيارات مجهزة ومبطنة من الداخل لكي يتم نقل العفش في امان تام بدون خدوش او تكسير مثل الشركات التالية
ReplyDeleteشركه نقل عفش بجده
شركه نقل عفش بمكه
شركه نقل عفش بالطائف
وفي منطقة المدينة المنورة تجدنا نمتلك افضل شركات نقل الاثاث مع الفك والتركيب وكذلك في ينبع وينبع البحر مثال عن تلك الشركات
شركه نقل عفش بالمدينه المنوره
شركه نقل عفش بينبع
وفي المنطقة الوسطي نقدم خدمات نقل العفش مع الفك والتركيب والتغليف ويتم النقل في سيارات مجهزة ومؤمنة لتحميل العفش وتفادي التلفيات في الرياض والقصيم والخرج مثل
- شركات نقل عفش بالرياض
- شركات نقل عفش بالقصيم
- شركات نقل عفش بالخرج
شركة مكافحة حشرات بالخبر
ReplyDeleteشركة مكافحة حشرات بالجبيل
شركة مكافحة حشرات بالاحساء
The Chhattisgarh Board of Secondary Education CGBSE High School Class 10th Examination Previous Question Paper 2023 will declare very soon on its official website at cgbse.nic.in. Lots of students had appeared CG 10th Question Paper 2023 in Chhattisgarh Board Class X examination held on March /April . Now all students are waiting CGBSE 10th Previous Question Paper 2023, CG Board Class 10th Previous Question Paper 2023, CGBSE High School Exam Previous Question Paper 2023
ReplyDelete