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 : 25-06-2017

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-13243 : specified operator is not supported for 3- or higher-dimensional R-tree
  • ora-29288 : invalid file name
  • ora-09798 : Label comparison failed.
  • ora-03298 : cannot shrink datafile - file string is under hot backup
  • ora-01635 : rollback segment #string specified not available
  • ora-26061 : Concurrent direct unloads is not allowed.
  • ora-04061 : existing state of string has been invalidated
  • ora-37079 : (XSMCSESS07) Aggmap workspace object cannot be used for AGGREGATE.
  • ora-27123 : unable to attach to shared memory segment
  • ora-39140 : dump file "string" belongs to job string
  • ora-14012 : resulting partition name conflicts with that of an existing partition
  • ora-02268 : referenced table does not have a primary key
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • ora-09918 : Unable to get user privileges from SQL*Net
  • ora-22888 : duplicate SCOPE clauses for a REF column
  • ora-02171 : invalid value for MAXLOGHISTORY
  • ora-12403 : invalid internal label
  • ora-31005 : Path name length string exceeds maximum length string
  • ora-27418 : syntax error in repeat interval or calendar
  • ora-00087 : command cannot be executed on remote instance
  • ora-23375 : feature is incompatible with database version at string
  • ora-15003 : diskgroup "string" already mounted in another lock name space
  • ora-09709 : soacon: failed to accept a connection.
  • ora-02338 : missing or invalid column constraint specification
  • ora-15052 : ASM file name 'string' is not in diskgroup "string"
  • ora-13140 : invalid target type
  • ora-32408 : materialized view log on "string"."string" already has new values
  • ora-16718 : failed to locate database object
  • ora-13354 : incorrect offset in ELEM_INFO_ARRAY
  • ora-01490 : invalid ANALYZE command
  • 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.