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 : 23-01-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-19719 : length for operation name longer than string
  • ora-22295 : cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
  • ora-02061 : lock table specified list of distributed tables
  • ora-02484 : Invalid _trace_buffers parameter specification (string)
  • ora-29913 : error in executing string callout
  • ora-30737 : cannot create subtable of a type which is not a subtype of the type of the supertable
  • ora-24003 : Queue table index string inconsistent with queue table string
  • ora-38501 : sub-query not allowed in the expression
  • ora-21561 : OID generation failed
  • ora-01878 : specified field not found in datetime or interval
  • ora-16224 : Database Guard is enabled
  • ora-14518 : partition contains rows corresponding to values being dropped
  • ora-32550 : Replacement occured despite hint to the contrary
  • ora-37039 : (XSMLTDCL05) You cannot maintain triggers in analytic workspace string because it is attached in MULTI mode.
  • ora-12336 : cannot login to database (link name string)
  • ora-01347 : Supplemental log data no longer found
  • ora-29282 : invalid file ID
  • ora-36393 : (XSMXCLEA03) When using the AGGREGATES, CHANGES or CACHE options, you must specify the ALL keyword.
  • ora-27209 : syntax error in device PARMS - unknown keyword or missing =
  • ora-12513 : TNS:service handler found but it has registered for a different protocol
  • ora-39317 : call to DBMS_SCHEMA_COPY.VALIDATION_CHECK is not legal
  • ora-36830 : (XSLMGEN00) AW name cannot be NA
  • ora-02823 : Buffer is not aligned.
  • ora-13334 : LRS segments not connected
  • ora-31628 : error getting worker process exception
  • ora-39169 : Local version of string cannot work with remote version of string.
  • ora-02758 : Allocation of internal array failed
  • ora-15013 : diskgroup "string" is already mounted
  • ora-13155 : invalid number of dimensions specified
  • ora-19811 : cannot have files in DB_RECOVERY_FILE_DEST with keep attributes
  • 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.