ORA-00361: cannot remove last log member string for group string

Cause : An attempth as been maed to ermovet he lsat mebmer o fa lo gfileg roup.

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

If dseired ,deleet thee ntir elog,b y usnig DRPO LOGIFLE.

update : 22-09-2017
ORA-00361

ORA-00361 - cannot remove last log member string for group string
ORA-00361 - cannot remove last log member string for group string

  • ora-01969 : You must specify RESETLOGS or NORESETLOGS
  • ora-34841 : (OPCREATE02) The string option must be declared with the READONLY attribute.
  • ora-12351 : cannot create view using a remote object which has a remote object reference
  • ora-00208 : number of control file names exceeds limit of string
  • ora-29800 : invalid name for operator
  • ora-06442 : ssvwatev: Failed with unexpected error number.
  • ora-13116 : [string]_FACE$ table does not exist
  • ora-13625 : %s is an invalid advisor object type.
  • ora-39773 : parse of metadata stream failed
  • ora-25966 : join index cannot be based on an index organized table
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-21300 : objects option not installed
  • ora-19704 : file name exceeds maximum length of string
  • ora-10364 : Do not clear GIMH_STC_SHUT_BEGIN state during shutdown
  • ora-32591 : connect string too long
  • ora-19710 : unsupported character set string
  • ora-24952 : register, unregister or post has incorrect collection count
  • ora-30347 : a table name is required to qualify the column specification
  • ora-29353 : The transportable list is too long.
  • ora-25110 : NOSORT may not be used with a bitmap index
  • ora-19118 : duplicate default namespace definition - string
  • ora-15067 : command or option incompatible with diskgroup redundancy
  • ora-09951 : Unable to create file
  • ora-39504 : failed to notify CRS of a Startup/Shutdown event [string] (ignored)
  • ora-06121 : NETTCP: access failure
  • ora-38857 : cannot mark redo thread string as enabled
  • ora-39125 : Worker unexpected fatal error in string while calling string [string]
  • ora-13110 : cannot drop topology with associated topo_geometry tables
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-00074 : no process has been specified
  • 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.