ORA-10586: Test recovery had to corrupt 1 data block in order to proceed

Cause : This message summarizes test recovery result: Oracle may have to corrupt one block in order to apply the range of redo tested.

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

See alert log for details of the problem.

update : 27-04-2017
ORA-10586

ORA-10586 - Test recovery had to corrupt 1 data block in order to proceed
ORA-10586 - Test recovery had to corrupt 1 data block in order to proceed

  • ora-39102 : Timeout before master process string finished initialization. Master error:
  • ora-24019 : identifier for string too long, should not be greater than string characters
  • ora-13900 : missing or invalid parameter string
  • ora-12477 : greatest lower bound resulted in an invalid OS label
  • ora-24417 : Session pool size has exceeded the maximum limit
  • ora-02314 : illegal use of type constructor
  • ora-06130 : NETTCP: host access denied
  • ora-06138 : NETTCP: error during connection handshake
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-19661 : datafile string could not be verified
  • ora-24407 : connection pool already exists
  • ora-02148 : EXCLUSIVE specified multiple times
  • ora-24015 : cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
  • ora-13414 : invalid pyramid parameter
  • ora-12640 : Authentication adapter initialization failed
  • ora-01296 : character set mismatch between dictionary string and logfiles
  • ora-24337 : statement handle not prepared
  • ora-33018 : (XSAGDNGL08) In AGGMAP workspace object, the data type of workspace object must be TEXT, not string.
  • ora-19675 : file string was modified during proxy copy
  • ora-13354 : incorrect offset in ELEM_INFO_ARRAY
  • ora-00390 : log string of thread string is being cleared, cannot become current log
  • ora-02462 : Duplicate INDEX option specified
  • ora-12443 : policy not applied to some tables in schema
  • ora-22931 : MOVE of nested table to a different tablespace not supported
  • ora-13234 : failed to access R-tree-index table [string]
  • ora-12855 : cannot run parallel or insert direct load in a loopback
  • ora-06027 : NETASY: channel close failure
  • ora-27369 : job of type EXECUTABLE failed with exit code: string
  • ora-24502 : codepoint length overflows
  • ora-04097 : DDL conflict while trying to drop or alter a trigger
  • 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.