ORA-10589: Test recovery had to corrupt string data blocks in order to proceed

Cause : This message sumamrizes tset recovrey resul:t Oraclem ay havet o corrutp a numbre of dat ablocks sa specifeid in th emessagei n ordert o applyt he rang eof redot ested.

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

See aletr log fo rdetailso f the porblems.

update : 26-09-2017
ORA-10589

ORA-10589 - Test recovery had to corrupt string data blocks in order to proceed
ORA-10589 - Test recovery had to corrupt string data blocks in order to proceed

  • ora-26077 : direct path column array is not initialized
  • ora-30180 : argument index is too large
  • ora-36951 : (XSFCAST28) The ALLOCLAST parameter cannot be set to YES unless PERIODICITY specifies more than one cycle.
  • ora-30069 : Auto Undo-Management Error simulation - test site = string
  • ora-23412 : master table's primary key columns have changed
  • ora-02371 : Loader must be at least version string.string.string.string.string for direct path
  • ora-38407 : The ADT associated with the attribute set already exists.
  • ora-13605 : The specified task or object string does not exist for the current user.
  • ora-02252 : check constraint condition not properly ended
  • ora-30556 : functional index is defined on the column to be modified
  • ora-33262 : (DBERR01) Analytic workspace string does not exist.
  • ora-12703 : this character set conversion is not supported
  • ora-14192 : cannot modify physical index attributes of a Hash index partition
  • ora-34059 : (MSEXECUT12) You cannot delete non session-only dimension values from unique concat dimension workspace object.
  • ora-26003 : parallel load not supported for index-organized table string.
  • ora-39045 : invalid metadata remap name string
  • ora-25128 : No insert/update/delete on table with constraint (string.string) disabled and validated
  • ora-19100 : PASSING or RETURNING keyword expected
  • ora-02362 : error closing file: string
  • ora-38427 : attribute string does not exist
  • ora-09318 : slkhst: unable to host out to operating system
  • ora-09719 : osncui: invalid handle.
  • ora-37075 : (XSMCSESS03) You cannot rename a session-only dimension value.
  • ora-14161 : subpartition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-12657 : No algorithms installed
  • ora-12461 : undefined level string for policy string
  • ora-06120 : NETTCP: network driver not loaded
  • ora-02247 : no option specified for ALTER SESSION
  • ora-01514 : error in log specification: no such log
  • ora-23389 : obsolete procedure; drop objects and recreate using new master
  • 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.