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 : 25-09-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-36962 : (XSRELTBL08) string is not a valid workspace object.
  • ora-31675 : worker process interrupt for unexpected death of master process
  • ora-01197 : thread string only contains one log
  • ora-03240 : User's temporary tablespace same as tablespace being migrated
  • ora-26564 : %s argument is not of specified type
  • ora-19039 : Keyword string reserved for future use
  • ora-02202 : no more tables permitted in this cluster
  • ora-30163 : The thread safety initialization failed
  • ora-07478 : scgcmn: cannot get lock status.
  • ora-12197 : TNS:keyword-value resolution error
  • ora-12463 : undefined group string for policy string
  • ora-27004 : invalid blocksize specified
  • ora-00484 : LMS* process terminated with error
  • ora-31006 : Path name segment length string exceeds maximum length string
  • ora-31524 : could not find change set string for CDC change table string.string
  • ora-28022 : cannot grant external roles to global user or role
  • ora-14601 : Illegal to specify SUBPARTITIONS or STORE-IN while specifying a subpartition template
  • ora-31662 : metadata transform name can not be defaulted
  • ora-14264 : table is not partitioned by Composite Range method
  • ora-16534 : no more requests accepted
  • ora-09344 : spsig: error signalling thread
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-02254 : DEFAULT not allowed here
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-36272 : (XSCGMDLAGG04) 'workspace object' is not a valid operator for the AGGREGATION function.
  • ora-38792 : encountered unknown flashback record from release string
  • ora-14645 : STORE IN clause cannot be specified for Range List objects
  • ora-32803 : value for string cannot be altered
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-13408 : invalid blockSize storage parameter
  • 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.