backup / recovery question

I'm studying for the third OCP test and I had an idea to make organizing recovery scenarios a bit more structured during my study time. I didn't want to post in HTML here, so if anyone would take just a minute or 2 and look at

http://www.paulmurphy.net/oracle/recovery.asp

and let me know what you think, I'd appreciate it. I'm going to go over the chapters again and try to fill in anything I missed as far as files needed for a complete recovery and then over the next few weeks, I'll actually fill in the notes for what to do to recover from each file type being missing. When I'm done, I think it might be a good tool do double-check before beginning the restore/recovery process. Maybe someday we'll be able to say, "I've got a CTL1/DAT2 failure."

The math of the different possible combinations would be pretty large, but some day I might make a giant chart of every combination of failures and the notes of how to recover from it. First, I have to get my list of important files done and any hints for files I've forgotten (or didn't know about) would be appreciated.

Thanks, Paul Murphy Received on Thu Apr 29 2004 - 10:20:25 CDT