VinodNagpure wrote:how is it that you find yourself confronted by this error message?
Hi, I am getting error "ORA-00338: log 2 of thread 1 is more recent than control file"
My os is RHEL 5.5, 64-bit
Database version is 184.108.40.206
VinodNagpure wrote:the cloning operation was incorrect or incomplete.
We were doint cloning of another instance on the same server. I don't know what exactly has happened. I found following error stack in the alert log just when the issue started:
VinodNagpure wrote:I suspect that the "working" DB has a file that over-wrote a file of the DB reporting the errors.
But we were not cloning this instance, and the instance which was being cloned is ok. The database as well as the application is open. The issue is with another database running on the same server.
We don't have any backup as this is a test instance. Flashback too is not enabled ! Is clearing the logfiles and open resetlogs an option here ?
I am not clear if the controlfile or redo logfile got over written.
00338, 00000, "log %s of thread %s is more recent than control file" // *Cause: The control file change sequence number in the log file is // greater than the number in the control file. This implies that // the wrong control file is being used. Note that repeatedly causing // this error can make it stop happening without correcting the real // problem. Every attempt to open the database will advance the // control file change sequence number until it is great enough. // *Action: Use the current control file or do backup control file recovery to // make the control file current. Be sure to follow all restrictions // on doing a backup control file recovery.