RE: When control files go bad
Date: Mon, 1 Jun 2009 14:19:17 -0500 (CDT)
>>From your log file, it looks like it attempted to write to ctl #1 and 2,
> failed to do so and then simply shut itself down (CKPT: terminating
> So your database was "ok" in that your control files don't seem to have
> been corrupted.
> I'm sure your restart log file showed recovery occurring.
> Oracle is getting smarter and smarter!
That's another point -- I *know* I've tested the result of controlfiles going away on a live instance and while Oracle complained, it kept going. I'll need to revisit that apparently.
I love this! I get to (re)learn more without the pain of having lost anything. Lots of stuff to take away from this li'l experience.