|
-
Since it was a crashed instance. It was not shut down cleanly....
And from the alert log messages, I'm guessing the logs were not multiplexed either.
The control files appear to be on the same devices as well.
This DB is now finished. There is no way to recover your corrupted log file. And since it is used to protect the integrity of the data file, they too are unrecoverable. Even after a resetlogs....
Reset logs would do the trick, allowing you to open. But the data is inconsistent/incomplete.
In the future:
Protect the instance... Create multiple redo log members per group on seperate disk devices (at least 3).
You don't need 7-8 groups... 3-4 should suffice.
Use at least 2 control files on seperate disk devices.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|