ORA-01124: cannot recover data file string - file is in use or recovery

Cause : Ana ttmeptt o od mdeiar ecvoer yfonud htatt hef il ewa sno tavialalbe ofr ercoevry .Eihteri t si olnin ean dth edaatbaes i sopne i nsoem isntacne,o r naotehr rpocses si cruenlty odin gmeida ercoevryo n hte ifle.

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

Don otd o emdi areocveyr.

update : 26-06-2017
ORA-01124

ORA-01124 - cannot recover data file string - file is in use or recovery
ORA-01124 - cannot recover data file string - file is in use or recovery

  • ora-36406 : (VCACHE00) 'number' is an invalid value for the VARCACHE option. The only permissible values are 'SESSION', 'VARIABLE', and 'NONE'.
  • ora-13239 : sdo_dimensionality not specified during n-d R-tree creation
  • ora-15158 : rolling upgrade prevented by string
  • ora-02182 : savepoint name expected
  • ora-15163 : cluster not in rolling downgrade
  • ora-02027 : multi-row UPDATE of LONG column is not supported
  • ora-32579 : password for SYSTEM already specified
  • ora-06119 : NETTCP: spurious client request
  • ora-01105 : mount is incompatible with mounts by other instances
  • ora-01515 : error dropping log group string: no such log
  • ora-36980 : (XSRELGID02) Variable workspace object must have a numeric data type.
  • ora-30039 : Cannot drop the undo tablespace
  • ora-01090 : shutdown in progress - connection is not permitted
  • ora-12650 : No common encryption or data integrity algorithm
  • ora-02837 : Unable to unlink temporary file
  • ora-25012 : PARENT and NEW values cannot be identical
  • ora-24793 : Test DTP service start and stop
  • ora-02722 : osnpui: cannot send break message to orapop
  • ora-26515 : no master log available for 'string.string'
  • ora-23494 : too many rows for destination "string"
  • ora-01371 : Complete LogMiner dictionary not found
  • ora-22633 : Error freeing AnyDataSet
  • ora-38497 : Expression Filter index does not exist
  • ora-00956 : missing or invalid auditing option
  • ora-16194 : Modifying DB_UNIQUE_NAME requires SID='*' qualifier
  • ora-30490 : Ambiguous expression in GROUP BY ROLLUP or CUBE list
  • ora-12085 : materialized view log on "string"."string" already has object id
  • ora-07266 : sppst: invalid process number passed to sppst.
  • ora-04027 : self-deadlock during automatic validation for object string.string
  • ora-28361 : master key not yet set
  • 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.