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 : 01-05-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-13858 : Invalid action name
  • ora-25123 : Too many components specified in the name.
  • ora-24785 : Cannot resume a non-migratable transaction
  • ora-12609 : TNS: Receive timeout occurred
  • ora-22281 : cannot perform operation with an updated locator
  • ora-19114 : error during parsing the XQuery expression: string
  • ora-14642 : Bitmap index mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-32696 : HTI: No free slot
  • ora-29352 : event 'string' is not an internal event
  • ora-06912 : CMX: write error in datarq
  • ora-22895 : referenced table "string" in schema "string" is not an object table
  • ora-03282 : missing ALLOCATE EXTENT option
  • ora-29317 : datafile string does not exist
  • ora-02033 : a cluster index for this cluster already exists
  • ora-33334 : (DSSEXIST04) Analytic workspace string is not attached.
  • ora-40221 : maximum target cardinality exceeded
  • ora-19954 : control file is not current
  • ora-06406 : NETCMN: error sending break message
  • ora-27091 : unable to queue I/O
  • ora-29915 : cannot select FOR UPDATE from collection operand
  • ora-06119 : NETTCP: spurious client request
  • ora-21524 : object type mismatch
  • ora-31000 : Resource 'string' is not an XDB schema document
  • ora-25202 : invalid value NULL, string should be non-NULL
  • ora-13156 : table to be registered string.string is not empty
  • ora-09291 : sksachk: invalid device specified for archive destination
  • ora-27414 : Invalid BY value type
  • ora-25148 : ONLINE option not permitted
  • ora-25444 : invalid ROWID: string for table alias: string
  • ora-25463 : table alias not specified
  • 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.