Read of datafile ‘E:ORADATAORCLTEMP01.DBF’ (fno 201) header failed with ORA-01202
During the running the datapatch -verbose command for applying patch on DB, We got the following error:
Queryable inventory could not determine the current opatch status.
Execute 'select dbms_sqlpatch.verify_queryable_inventory from dual'
and/or check the invocation log
E:oraclecfgtoollogssqlpatchsqlpatch_3960_2019_09_16_01_47_24sqlpatch_invoca
tion.log
for the complete error.
Prereq check failed, exiting without installing any patches.
Please refer to MOS Note 1609718.1 and/or the invocation log
E:oraclecfgtoollogssqlpatchsqlpatch_3960_2019_09_16_01_47_24sqlpatch_invoca
tion.log
for information on how to resolve the above errors.
SQL Patching tool complete on Mon Sep 16 01:47:49 2019
On Checking Alert log, I Startup the Database, we are getting the following error in alert log file.
Temp file is not able to read by Oracle Database services.
Error
Verifying file header compatibility for tablespace encryption completed for pdb 0
2019-09-16T01:22:42.596870-04:00
Read of datafile 'E:ORACLEORADATAORCLTEMP01.DBF' (fno 201) header failed with ORA-01202
Rereading datafile 201 header failed with ORA-01202
2019-09-16T01:22:42.596870-04:00
Errors in file E:ORACLEdiagrdbmsORCLORCLtraceORCL_dbw0_1072.trc:
ORA-01186: file 201 failed verifORCLation tests
ORA-01122: database file 201 failed verifORCLation check
ORA-01110: data file 201: 'E:ORACLEORADATAORCLTEMP01.DBF'
ORA-01202: wrong incarnation of this file - wrong creation time
File 201 not verified due to error ORA-01122
2019-09-16T01:22:42.596870-04:00
Cannot re-create tempfile E:ORACLEORADATAORCLTEMP01.DBF, the same name file exists
Solution
1. On Reading the last line of the Alert log message, we understand already have an temp01 file in the Oradata location.
2. We take the full cold backup of Oracle Database.
3. Rename the existing TEMP file mentioned in alert log
4. Start the Database.Then Oracle automatically create the TEMP file during startup.
Below is the Alert log show below while created TEMP file.
Alert Log:
Verifying minimum file header compatibility for tablespace encryption..
Verifying file header compatibility for tablespace encryption completed for pdb 0
2019-09-16T01:59:40.313247-04:00
Errors in file E:ORACLEdiagrdbmsORCLORCLtraceORCL_dbw0_4072.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: 'E:ORACLEORADATAORCLTEMP01.DBF'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
2019-09-16T01:59:40.313247-04:00
Errors in file E:ORACLEdiagrdbmsORCLORCLtraceORCL_dbw0_4072.trc:
ORA-01186: file 201 failed verifORCLation tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: 'E:ORACLEORADATAORCLTEMP01.DBF'
2019-09-16T01:59:40.313247-04:00
File 201 not verified due to error ORA-01157
2019-09-16T01:59:40.328867-04:00
Re-creating tempfile E:ORACLEORADATAORCLTEMP01.DBF
