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 : 30-04-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-12432 : LBAC error: string
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-07561 : szprv: $IDTOASC failure
  • ora-00344 : unable to re-create online log 'string'
  • ora-12207 : TNS:unable to perform navigation
  • ora-30200 : Wrong NLS item was passed into OCINlsGetInfo()
  • ora-29380 : resource plan string is currently active and cannot be deleted
  • ora-22828 : input pattern or replacement parameters exceed 32K size limit
  • ora-06959 : Buffer I/O quota is too small
  • ora-19706 : invalid SCN
  • ora-27153 : wait operation failed
  • ora-15056 : additional error message
  • ora-10916 : TABLESPACE GROUP already specified
  • ora-13528 : name (string) is already used by an existing baseline
  • ora-39961 : message specified was not found
  • ora-06741 : TLI Driver: unable to open protocol device
  • ora-32017 : failure in updating SPFILE
  • ora-09263 : spini: error initializing process
  • ora-02185 : a token other than WORK follows COMMIT
  • ora-27142 : could not create new process
  • ora-13702 : Snapshot IDs specified by the range [string, string] are equal.
  • ora-04067 : not executed, string does not exist
  • ora-14505 : LOCAL option valid only for partitioned indexes
  • ora-23420 : interval must evaluate to a time in the future
  • ora-14251 : Specified subpartition does not exist
  • ora-29831 : operator binding not found
  • ora-09763 : osnmpx: send/receive error exchanging Mach ports.
  • ora-28541 : Error in HS init file on line number.
  • ora-30765 : cannot modify scope for an unscoped REF column
  • ora-22285 : non-existent directory or file for string operation
  • 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.