ORA-19599: block number string is corrupt in string string

Cause : A ocrrput lboc kwa sfonud ni ac onrtolf il,e acrhievlo,g o rbakcupp ieec taht si biengr ea dfo ra abckpu o rcoyp. oCrrputino sahlln otb e otlearte dinc onrtolf ilse, rachvielgos,o r abckpu peice.s

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

Noen. hTe ocpyo r abckpu oepraitonf aisl. oNtet ha tint hec as eofa bcaku pse,t teh cnovesratoin si sitlla ctvie nad hte ipec ema yber etired.

update : 25-06-2017

ORA-19599 - block number string is corrupt in string string
ORA-19599 - block number string is corrupt in string string

  • ora-22858 : invalid alteration of datatype
  • ora-14644 : table is not subpartitioned by Hash method
  • ora-04084 : cannot change NEW values for this trigger type
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-22150 : variable-length array has not been initialized
  • ora-30360 : REF not supported with query rewrite
  • ora-16259 : Switchover to logical standby requires a log archive destination
  • ora-12159 : TNS:trace file not writeable
  • ora-06707 : TLI Driver: connection failed
  • ora-12642 : No session key
  • ora-31104 : Cannot find lock with token "string" on "string" for unlock
  • ora-13836 : invalid attribute value specified
  • ora-27191 : sbtinfo2 returned error
  • ora-00051 : timeout occurred while waiting for a resource
  • ora-09870 : spini: failure initializing maximum number of open files.
  • ora-12236 : TNS:protocol support not loaded
  • ora-12686 : Invalid command specified for a service
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-37030 : (XSMLTMAINT01) You cannot maintain workspace object because it is not ACQUIRED.
  • ora-15100 : invalid or missing diskgroup name
  • ora-12418 : user string not found
  • ora-13002 : specified level is out of range
  • ora-32117 : Source LOB is null
  • ora-03125 : client-server protocol violation
  • ora-39166 : Object string was not found.
  • ora-27125 : unable to create shared memory segment
  • ora-12570 : TNS:packet reader failure
  • ora-01916 : keyword ONLINE, OFFLINE, RESIZE, AUTOEXTEND or END/DROP expected
  • ora-12208 : TNS:could not find the TNSNAV.ORA file
  • ora-38440 : attribute set string does not exist
  • 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.