Re: Getting errors when starting listener [message #660420 is a reply to message #660419] |
Thu, 16 February 2017 03:08 |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
You can try, it might work. But I suspect that more has happened than you think.
For example, the queries against those v$ views show that your control file believes that you have 4 online logfile groups,
each with just one member. Two groups have members in /oracle/AMP/origlogB and the other two have members in /oracle/AMP/origlogA.
This separation is a pointless complication, but not a technical issue.
However, your directory listings suggest that you have 4 online logfile groups (OK so far) each of which has 2 members, one in
each directory. That would be a much better way of organizing things, but is incompatible with the controlfile.
All I can conclude is that someone has been trying to fix things but has actually broken them. I could possibly solve this problem
either by sorting out what happened and recreating the controlfile to reflect reality, or by using some undocumented techniques
to open the database with a corrupt redo log. However, I do not think I can talk someone through this in a forum. It is too complicated.
Perhaps someone else will feel up to attempting to help further, but I think you need to hire a consultant. A good one.
It won't take him long, but he won't be able to guarantee success in advance. I know, because I've had to sort out this kind of thing
for clients a few times.
|
|
|
Re: Getting errors when starting listener [message #660421 is a reply to message #660420] |
Thu, 16 February 2017 03:18 |
|
Michel Cadot
Messages: 68648 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Quote:may you please kindly confirm if we can rename the original online log and move the old ones back to its location
You can, backing up the current ones before; will this solve the problem? I doubt.
Edit: Sorry, John, I didn't see your answer which is in another page.
[Updated on: Thu, 16 February 2017 03:20] Report message to a moderator
|
|
|
|
|
|
|