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-04-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-01324 : cannot add file string due to DB_ID mismatch
  • ora-30467 : internal data for filter number string is inconsistent
  • ora-10842 : Event for OCI Tracing and Statistics Info
  • ora-12655 : Password check failed
  • ora-00031 : session marked for kill
  • ora-23392 : could not find materialized view to be associated with "string"."string"
  • ora-01233 : file string is read only - cannot recover using backup control file
  • ora-23542 : dependent object "string"."string" already registered
  • ora-12699 : Native service internal error
  • ora-06616 : LU6.2 Driver: Attach to LU failed
  • ora-02839 : Sync of blocks to disk failed.
  • ora-19556 : required destination LOG_ARCHIVE_DUPLEX_DEST currently is deferred
  • ora-00078 : cannot dump variables by name
  • ora-06010 : NETASY: dialogue file too long
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-33309 : (DBVALID05) SEVERE ERROR: Record number used but not allocated (PS number)
  • ora-03297 : file contains used data beyond requested RESIZE value
  • ora-25406 : could not generate a connect address
  • ora-24395 : cannot reinitialize non-existent pool
  • ora-02362 : error closing file: string
  • ora-19504 : failed to create file "string"
  • ora-13863 : Statistics aggregation for service(module/action) string is not enabled
  • ora-40261 : input data for model build contains negative values
  • ora-31437 : duplicate change set string
  • ora-26028 : index string.string initially in unusable state
  • ora-33072 : (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.
  • ora-07628 : smsfre: sga not mapped
  • ora-23310 : object group "string"."string" is not quiesced
  • ora-01453 : SET TRANSACTION must be first statement of transaction
  • ora-06707 : TLI Driver: connection failed
  • 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.