Shulou(Shulou.com)06/01 Report--

System environment: Oracle Linux 7.4

Database environment: 12.2.0.1.20200114

Database alarm logs frequently prompt in recent days:

ORA-17500: ODM err:ODM ERROR Vmur41-3-2-20-7-5 Mirror number too large for given offset

Bug 30025955 ORA-17500 ODM Error v Mirror Number too large for given Offset 41-3-2-20-7-5 Mirror Number too large for given Offset

This note gives a brief overview of bug 30025955.

The content was last updated on: 15-APR-2020

Click here for details of each of the sections below.

Affects:Product (Component) Oracle Server (Rdbms) Range of versions believed to be affectedVersions BELOW 12.2Versions confirmed as being affected (None Specified) Platforms affectedGeneric (all / most platforms affected) Fixed:The fix for 30025955 is first included in18.1.0

Interim patches may be available for earlier versions-click here to check.Symptoms:Related To:Error May OccurStorage Space Usage Affected (None Specified) DescriptionThis bug is only relevant when using Oracle Disk ManagerThis fixes 2 problems with diagnostic messages (it does not fix the root cause of any existing block corruption). The first problem is this msg in the alert log which shouldn't happen: ORA-17500: ODM err... Mirror number too large for given offset The second problem is tracefiles msgs not showing the correct mirror name where a good version of the block was read Eg the message shows: Read datafile mirror 'Not able to find mirror name'... found valid data Read datafile mirror' 'found valid data Rediscovery NotesThe alert log has this error messsage which shouldn't happen:-Errors in file ORA-17500: ODM err:ODM ERROR Vmur41-3-2-207-5 Mirror number too large for given offset-And/or the tracefile has these kind of messages:- on ODM storage: Read datafile mirror' Not able to find mirror name' (file Block) found valid data- on ASM storage: Read datafile mirror'(file, block) found valid data WorkaroundNone.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.