DB instance on zLinux does not open on reboot of LPAR due to random ORA-01208 errors (Doc ID 1467494.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]
IBM: Linux on System z

Symptoms

Database instances can not be opened due to the following error:

"ORA-01208: data file is an old version - not accessing current version"

The problem is intermittent.
Subsequent reboots will not reproduce the issue, yet at other times, it does occur.
If the affected datbase is a RAC system, one or both nodes may encounter this problem.

This is a 2 node Oracle 11.2 RAC.  
 
The disk storage in use is an Hitachi USP1100.  
This is enterprise class storage and the disks are ECKD attached via 4G Ficon channels (8).

The errors observed are as follows:

Mon Apr 30 14:41:48 2012
Read of datafile '+mypath/dbfiles/users01_01.dbf' (fno 10) header failed with ORA-01208
Rereading datafile 10 header failed with ORA-01208
Errors in file /usr/oracle/diag/rdbms/d807/d807i2/trace/d807i2_dbw0_20413.trc:
ORA-01186: file 10 failed verification tests
ORA-01122: database file 10 failed verification check
ORA-01110: data file 10: '+mypath/dbfiles/users01_01.dbf'
ORA-01208: data file is an old version - not accessing current version
File 10 not verified due to error ORA-01122

Note, the above error(s) occurs for many datafiles when an attempt to open the database is attempted,
and may occur for different files each time an attempt to open the database is made.

Message ORA-01122 indicates information in the datafile is inconsistent with information
from the control file and the reason is described in message "ORA-01208: data file is an old version -
not accessing current version".

When the issue occurs, the v$datafile_header view shows the following:  (RECOVERY=YES for several files)

select file#,status,error,recover,fuzzy,name from v$datafile_header;

FILE#  STATUS  REC  FUZ NAME
---------- -------  --- --- -------------------------------------------
1 ONLINE   NO  YES +mypath/system01.dbf
2 ONLINE   NO  YES +mypath/sysaux01.dbf
3 ONLINE   NO  YES +mypath/undotbs01.dbf
4 ONLINE   NO  YES +mypath/users01.dbf
5 ONLINE   NO  YES +mypath/example01.dbf
6 ONLINE   NO  YES +mypath/undotbs02.dbf
7 ONLINE   YES YES +mypath/dbfiles/vpamaudtlob01_01.dbf
8 ONLINE   NO  YES +mypath/dbfiles/vpamaudti01_01.dbf
9 ONLINE   YES YES +mypath/dbfiles/vpamaudtd01_01.dbf
10 ONLINE   NO  YES +mypath/dbfiles/users01_01.dbf
11 ONLINE   YES YES +mypath/dbfiles/rsptmlob01_01.dbf
12 ONLINE   NO  YES +mypath/dbfiles/rsptmi02_01.dbf
13 ONLINE   YES YES +mypath/dbfiles/rsptmi01_01.dbf
14 ONLINE   NO  YES +mypath/dbfiles/rsptmd02_01.dbf
15 ONLINE   NO  YES +mypath/dbfiles/rsptmd01_01.dbf
16 ONLINE   YES YES +mypath/dbfiles/prfmonlob02_01.dbf
17 ONLINE   YES YES +mypath/dbfiles/prfmonlob01_01.dbf
18 ONLINE   YES YES +mypath/dbfiles/prfmoni02_01.dbf
19 ONLINE   NO  YES +mypath/dbfiles/prfmoni01_01.dbf
20 ONLINE   YES YES +mypath/dbfiles/prfmond02_01.dbf
21 ONLINE   NO  YES +mypath/dbfiles/prfmond01_01.dbf
22 ONLINE   YES YES +mypath/dbfiles/metrici01_01.dbf
23 ONLINE   NO  YES +mypath/dbfiles/metricd01_01.dbf
24 ONLINE   NO  YES +mypath/dbfiles/glbl_refi01_01.dbf
25 ONLINE   YES YES +mypath/dbfiles/glbl_refd01_01.dbf
26 ONLINE   NO  YES +mypath/dbfiles/epass_vsi01_01.dbf
27 ONLINE   NO  YES +mypath/dbfiles/epass_vsd01_01.dbf

Reference:

Bug 14028368 - ORA-01208 ERRORS ON LPAR ON REBOOT; DATABASE INSTANCE DOES NOT OPEN

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms