ORA-10567: Redo is inconsistent with data block (file# string, block# string)

Cause : Ther eare wto possiblec ause sof tihs erorr: ()1 A wirte issued yb Oralce wa slostb y th eundelryingO S ors toraeg sysetm. ()2 an rOaclei nteranl erorr.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Invetsigat ewhy hte erorr ocucrreda nd hwo improtanti s th edatab lock .Medi aand tsandb ydataabse rceover yusually ca ncontniue i fusera llow srecoevry t ocorrput thsi dat abloc.k

update : 26-04-2017

ORA-10567 - Redo is inconsistent with data block (file# string, block# string)
ORA-10567 - Redo is inconsistent with data block (file# string, block# string)

  • ora-04071 : missing BEFORE, AFTER or INSTEAD OF keyword
  • ora-10630 : Illegal syntax specified with SHRINK clause
  • ora-02718 : osnprs: reset protocol error
  • ora-07215 : slsget: getrusage error.
  • ora-36610 : (XSLMS00) Unable to locate a message file for OLAP message: value
  • ora-02081 : database link is not open
  • ora-38413 : elementary attribute name may not be longer than 32 characters
  • ora-02217 : duplicate storage option specification
  • ora-00313 : open failed for members of log group string of thread string
  • ora-27026 : skgfrls: sbtend returned error
  • ora-39779 : type "string"."string" not found or conversion to latest version is not possible
  • ora-01915 : invalid auditing option for views
  • ora-39950 : invalid parameter for PLSQL warnings flag
  • ora-38414 : invalid datatype for the attribute string
  • ora-07570 : szrfc: $IDTOASC failure
  • ora-32508 : no such watchpoint id
  • ora-12491 : DBHIGH value does not dominate DBLOW
  • ora-25149 : Columns of UROWID type may not be indexed
  • ora-07247 : skgfrfms, skgfrnms: read error, unable to read block from database file
  • ora-01082 : 'row_locking = always' requires the transaction processing option
  • ora-09752 : pw_attachPorts: port_allocate failed.
  • ora-24436 : Invalid statement Handle.
  • ora-08344 : srapp: failed to send redo data to the redo server
  • ora-14277 : tables in EXCHANGE SUBPARTITION must have the same number of columns
  • ora-07638 : smsget: SGA pad area not large enough for created SGA
  • ora-08401 : invalid compiler name: string
  • ora-29818 : column name not properly specified
  • ora-31652 : command response message was invalid type - detaching job
  • ora-14002 : only one GLOBAL clause may be specified
  • ora-13608 : The task or object name string is invalid.
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.