ORA-19681: block media recovery on control file not possible

Cause : filenumber 0 specified in block media recovery

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

check filenumber

update : 28-04-2017
ORA-19681

ORA-19681 - block media recovery on control file not possible
ORA-19681 - block media recovery on control file not possible

  • ora-16766 : Redo Apply unexpectedly offline
  • ora-40253 : no target counter examples were found
  • ora-31161 : element or attribute "string" cannot be stored out of line
  • ora-02765 : Invalid maximum number of servers
  • ora-32104 : cannot retrieve OCI error message
  • ora-39754 : FULL PARTITIONED OUTER JOIN is not supported
  • ora-28505 : cannot get non-Oracle system capabilities from string
  • ora-30401 : JOIN KEY columns must be non-null
  • ora-36260 : (XSAGHIERPART00) Aggregating from partition %J to partition %J over hierarchy workspace object creates an increase in sparsity.
  • ora-01177 : data file does not match dictionary - probably old incarnation
  • ora-27152 : attempt to post process failed
  • ora-06568 : obsolete ICD procedure called
  • ora-02702 : osnoraenv: error translating orapop image name
  • ora-29879 : cannot create multiple domain indexes on a column list using same indextype
  • ora-12809 : cannot set string_INSTANCES when mounted in exclusive mode
  • ora-38490 : invalid name: quotes do not match
  • ora-10635 : Invalid segment or tablespace type
  • ora-26084 : direct path context already finished
  • ora-23606 : invalid object string
  • ora-12853 : insufficient memory for PX buffers: current stringK, max needed stringK
  • ora-13218 : max number of supported index tables reached for [string] index
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-24128 : partition name specified for a non-partitioned object
  • ora-01302 : dictionary build options missing or incorrect
  • ora-32801 : invalid value string for string
  • ora-31518 : change column string already exists in CDC change table string.string
  • ora-01019 : unable to allocate memory in the user side
  • ora-14255 : table is not partitioned by Range, Composite Range or List method
  • ora-01567 : dropping log string would leave less than 2 log files for instance string (thread string)
  • ora-23490 : extension request "string" with status "string" not allowed in this operation
  • 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.