ORA-10579: Can not modify control file during test recovery

Cause : To porceedw ith ercoveyr, tets recvoery eneds ot modfiy th econtorl fiel. Bu ttestr ecovrey isn ot allowedt o moidfy cnotrolf ile.

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

No atcion si neeedd. Tset reocveryh as edned scucessuflly.I t ca nonlyg o sof ar i nthe erdo srteam.

update : 17-08-2017

ORA-10579 - Can not modify control file during test recovery
ORA-10579 - Can not modify control file during test recovery

  • ora-29261 : bad argument
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-08000 : maximum number of session sequence lists exceeded
  • ora-23354 : deferred RPC execution disabled for "string" with "string"
  • ora-12457 : security label exceeded maximum allowable length
  • ora-24750 : incorrect size of attribute
  • ora-39213 : Metadata processing is not available
  • ora-09921 : Unable to get information label from connection
  • ora-01099 : cannot mount database in SHARED mode if started in single process mode
  • ora-12634 : Memory allocation failed
  • ora-01034 : ORACLE not available
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-27200 : skgfpgo: sbtpcstart returned error
  • ora-01929 : no privileges to GRANT
  • ora-39203 : Partition selection is not supported over a network link.
  • ora-02030 : can only select from fixed tables/views
  • ora-12675 : External user name not available yet
  • ora-37084 : Output valueset string must match string's dimensionality
  • ora-02424 : potential circular view references or unknown referenced tables
  • ora-32840 : property name cannot be NULL
  • ora-22056 : value [string] is divided by zero
  • ora-23341 : user function required
  • ora-00053 : maximum number of enqueues exceeded
  • ora-13461 : the interleaving type is not supported
  • ora-17610 : file 'string' does not exist and no size specified
  • ora-01252 : cannot prevent writes - file string in recovery manager backup
  • ora-19241 : XP0021 - cast to type string failed
  • ora-31033 : Requested number of XML children string exceeds maximum string
  • ora-31223 : DBMS_LDAP: cannot open more than string LDAP server connections
  • ora-06031 : NETDNT: connect failed, unrecognized object name
  • 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.