Well, In my case I move the redo log file to a new location and when opening the database I got the error. When I tried to rest the logs It gave a error that rest logs is possible only after database recovery. So the only option left for me was to clear the logfile. Another option is to drop the logfile and recreate it.
thanx




Reply With Quote