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-05-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-15009 : ASM disk "string" does not exist
  • ora-13909 : Invalid combination of threshold value and operator.
  • ora-01947 : TEMPORARY TABLESPACE already specified
  • ora-38470 : cannot revoke a privilege that was not granted.
  • ora-01220 : file based sort illegal before database is open
  • ora-28333 : column is not encrypted
  • ora-15046 : ASM file name 'string' is not in single-file creation form
  • ora-10936 : trace name context forever
  • ora-37071 : You may not execute a parallel OLAP operation against updated but uncommitted AW string.
  • ora-31663 : metadata remap name can not be defaulted
  • ora-30934 : 'string' (string node) cannot be inserted in parent 'string' (string node)
  • ora-31486 : cannot support column string in this configuration
  • ora-26575 : remote database does not support replication parallel propagation
  • ora-30436 : unable to open named pipe 'string'
  • ora-16764 : redo transport service to a standby database is offline
  • ora-27453 : %s is an invalid job or program argument name.
  • ora-02204 : ALTER, INDEX and EXECUTE not allowed for views
  • ora-40216 : feature not supported
  • ora-12986 : columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE
  • ora-24023 : Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]
  • ora-10389 : parallel query server interrupt (cleanup)
  • ora-31085 : schema "string" already registered
  • ora-13249 : %s
  • ora-30154 : The memory address given as buffer for OCIFileRead/Write is invalid
  • ora-02047 : cannot join the distributed transaction in progress
  • ora-19379 : invalid time_limit or repeat_interval
  • ora-16706 : no resource guard is available
  • ora-38461 : XML Tag "string" already exists for the XMLType attribute "string"
  • ora-06602 : LU6.2 Driver: Error allocating context area
  • ora-09209 : sftget: error reading from file
  • 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.