DB instance on zLinux does not open on reboot of LPAR due to random ORA-01208 errors
(Doc ID 1467494.1)
Last updated on AUGUST 02, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 to 11.2.0.3 [Release 11.2]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |