Read of datafile ‘E:\ORADATA\ORCL\TEMP01.DBF’ (fno 201) header failed with ORA-01202

Read of datafile ‘E:\ORADATA\ORCL\TEMP01.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:\oracle\cfgtoollogs\sqlpatch\sqlpatch_3960_2019_09_16_01_47_24\sqlpatch_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:\oracle\cfgtoollogs\sqlpatch\sqlpatch_3960_2019_09_16_01_47_24\sqlpatch_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:\ORACLE\ORADATA\ORCL\TEMP01.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:\ORACLE\diag\rdbms\ORCL\ORCL\trace\ORCL_dbw0_1072.trc:
ORA-01186: file 201 failed verifORCLation tests
ORA-01122: database file 201 failed verifORCLation check
ORA-01110: data file 201: 'E:\ORACLE\ORADATA\ORCL\TEMP01.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:\ORACLE\ORADATA\ORCL\TEMP01.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:\ORACLE\diag\rdbms\ORCL\ORCL\trace\ORCL_dbw0_4072.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: 'E:\ORACLE\ORADATA\ORCL\TEMP01.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:\ORACLE\diag\rdbms\ORCL\ORCL\trace\ORCL_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:\ORACLE\ORADATA\ORCL\TEMP01.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:\ORACLE\ORADATA\ORCL\TEMP01.DBF

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.