Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2939
  • Last Modified:

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

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
cdion
Asked:
cdion
1 Solution
 
Richard OlutolaConsultantCommented:
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
 
MikeOM_DBACommented:

Try:

ALTER SYSTEM ARCHIVE LOG CURRENT;

Open in new window

0
 
cdionAuthor Commented:
When I tried that it says "no such log"
ORA-01514: error in log specification: no such log
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
0
 
cdionAuthor Commented:
That worked! thanks!!
0
 
Michael WorshamInfrastructure / Solutions ArchitectCommented:
It's funny what Google can accomplish.

Glad I could help!

-- Michael
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now