ORA-00275: media recovery has already been started

Cause : An attempt was made to start a second media recovery operation in the same session.

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

Complete or cancel the first media recovery session or start another session to perform media recovery.

update : 27-05-2017

ORA-00275 - media recovery has already been started
ORA-00275 - media recovery has already been started

  • ora-24789 : start not allowed in recursive call
  • ora-01873 : the leading precision of the interval is too small
  • ora-25001 : cannot create this trigger type on views
  • ora-14189 : this physical attribute may not be specified for an index subpartition
  • ora-27501 : IPC error creating a port
  • ora-04060 : insufficient privileges to execute string
  • ora-19908 : datafile string has invalid checkpoint
  • ora-14168 : only one subpartition may be modified
  • ora-10646 : Too many recursive extensions during SYSTEM tablespace migration
  • ora-12504 : TNS:listener was not given the SID in CONNECT_DATA
  • ora-33094 : (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.
  • ora-19018 : Invalid character in XML tag 'string'
  • ora-02265 : cannot derive the datatype of the referencing column
  • ora-36910 : (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.
  • ora-01769 : duplicate CLUSTER option specifications
  • ora-13127 : failed to generate target partition
  • ora-02490 : missing required file size in RESIZE clause
  • ora-32763 : Turn off N-Pass Temp LOB cleanup
  • ora-34722 : (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string
  • ora-29815 : object being associated is not present
  • ora-12152 : TNS:unable to send break message
  • ora-19023 : The first argument to UPDATEXML operator has to be an XMLTYPE
  • ora-33008 : (XSAGDNGL03) The relation workspace object is not a relation over a base dimension of AGGMAP workspace object.
  • ora-27413 : repeat interval is too long
  • ora-23606 : invalid object string
  • ora-25233 : invalid parameter specified for NAVIGATION
  • ora-03205 : partition name is required when partitioned type is specified
  • ora-32775 : cannot change size attributes of read only tablespace string
  • ora-30732 : table contains no user-visible columns
  • ora-26660 : Invalid action context value for string
  • 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.