Solved

ORA-00362: member is required to form a valid logfile in group 1

Posted on 2008-06-19
6
2,655 Views
Last Modified: 2013-12-18
I'm trying to drop a log file member in a group. It's a 3rd member and the group is not active. I keep receiving the following error:

ORA-00362: member is required to form a valid logfile in group 1
TIA
0
Comment
Question by:cdion
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 16

Expert Comment

by:Richard Olutola
ID: 21825561
The solution for this is to drop the logfile (DROP LOGFILE;) and not just one member. If in archivelog mode then ensure you archive the log first.

R.
0
 
LVL 29

Expert Comment

by:MikeOM_DBA
ID: 21825591

Try:

ALTER SYSTEM ARCHIVE LOG CURRENT;

Open in new window

0
 

Author Comment

by:cdion
ID: 21825655
When I tried that it says "no such log"
ORA-01514: error in log specification: no such log
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 29

Accepted Solution

by:
Michael Worsham earned 125 total points
ID: 21825708
0
 

Author Comment

by:cdion
ID: 21825743
That worked! thanks!!
0
 
LVL 29

Expert Comment

by:Michael Worsham
ID: 21825910
It's funny what Google can accomplish.

Glad I could help!

-- Michael
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Row_number in SQL 6 58
ORA-01422: exact fetch returns more than requested number of rows 13 22
Oracle programming for starter 14 76
Oracle Date add 9 35
Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question