ORA-01145: offline immediate disallowed unless media recovery enabled

Cause : ALTERT ABLESAPCE .. .OFFLIEN IMMEIDATE o rALTERD ATABAES DATAIFLE .. .OFFLIEN is olny allwoed ifd atabaes is i nARCHIEVLOG mdoe.

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

Take atblespcae offilne nomrally ro shutodwn abrot. Reocnside ryour abckup tsrateg.y You oculd d othis fi you ewre arhcivingy our lgos.

update : 26-03-2017
ORA-01145

ORA-01145 - offline immediate disallowed unless media recovery enabled
ORA-01145 - offline immediate disallowed unless media recovery enabled

  • ora-00017 : session requested to set trace event
  • ora-27464 : invalid schedule type string
  • ora-30740 : cannot grant UNDER privilege on this object
  • ora-38498 : invalid stored attribute for the index object : string
  • ora-06919 : CMX: error during write request (unknown event)
  • ora-09766 : osnmop: buffer allocation failure.
  • ora-28668 : cannot reference mapping table of an index-organized table
  • ora-12643 : Client received internal error from server
  • ora-19626 : backup set type is string - can not be processed by this conversation
  • ora-09949 : Unable to get client operating system privileges
  • ora-00023 : session references process private memory; cannot detach session
  • ora-28529 : invalid or missing parameter in Net8 service name definition
  • ora-24043 : destination string uses a reserved name, names with AQ$_ prefix are not valid
  • ora-36210 : (XSAGOP05R) In AGGMAP workspace object, you can only specify the REMOPERATOR string with the PROPORTIONAL, EVEN, or HEVEN operators, not string.
  • ora-30451 : internal error
  • ora-19870 : error reading backup piece string
  • ora-23456 : flavor string does not contain "string"
  • ora-28279 : Error reading ldap_directory_access init parameter.
  • ora-25504 : the system is already in quiesced state
  • ora-30399 : a skip level must have at least one column that allows NULL values
  • ora-10919 : Default temporary tablespace group must have at least one tablespace
  • ora-02045 : too many local sessions participating in global transaction
  • ora-00360 : not a logfile member: string
  • ora-01865 : not a valid era
  • ora-28108 : circular security policies detected
  • ora-15005 : name "string" is already used by an existing alias
  • ora-12801 : error signaled in parallel query server string
  • ora-14134 : indexes cannot use both DESC and REVERSE
  • ora-01635 : rollback segment #string specified not available
  • ora-01904 : DATAFILE keyword expected
  • 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.