ORA-01143: cannot disable media recovery - file string needs media recovery

Cause : A nattepmtt od iasbel emdai ercvoeyr ofudn afliet hta enesd emdai ercvoeyr,t hsu emdai ercvoeyr acnontb ed iasbeld.

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

Rceoevrt h eoffednign ifl eo rdorpt h etbalsepcaei tb eolnsg ot nadr ertyt hsi ocmamn.d

update : 24-06-2017
ORA-01143

ORA-01143 - cannot disable media recovery - file string needs media recovery
ORA-01143 - cannot disable media recovery - file string needs media recovery

  • ora-00054 : resource busy and acquire with NOWAIT specified
  • ora-38422 : invalid datatype for the attribute: string
  • ora-01593 : rollback segment optimal size (string blks) is smaller than the computed initial size (string blks)
  • ora-16517 : the object handle is invalid
  • ora-02774 : Invalid request list latch time out value
  • ora-13353 : ELEM_INFO_ARRAY not grouped in threes
  • ora-09985 : SGA definition file could not be read
  • ora-32411 : materialized view definition query exceeds the maximum length
  • ora-27230 : OS system call failure
  • ora-37032 : (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
  • ora-27199 : skgfpst: sbtpcstatus returned error
  • ora-06929 : CMX: error when sending ORACLE_SID
  • ora-13035 : Invalid data (arcs in geodetic data) in the SDO_GEOMETRY object
  • ora-01122 : database file string failed verification check
  • ora-12612 : TNS:connection is busy
  • ora-31230 : DBMS_LDAP: unable to dynamically allocate additional memory
  • ora-32638 : Non unique addressing in MODEL dimensions
  • ora-25100 : TABLESPACE option can only be used with ALTER INDEX REBUILD
  • ora-19258 : XQ0038 - unsupported or duplicate default collation specified
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-25281 : complete reciever information not provided to non-repudiate reciever
  • ora-01945 : DEFAULT ROLE[S] already specified
  • ora-39120 : Table string can't be truncated, data will be skipped. Failing error is: string
  • ora-00400 : invalid release value string for parameter string
  • ora-24191 : the property name string has existed
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • ora-37013 : (XSACQUIRE_DEADLOCK) Cannot wait to acquire object workspace object since doing so would cause a deadlock.
  • ora-02850 : File is closed
  • ora-01609 : log string is the current log for thread string - cannot drop members
  • 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.