Re: backup / recovery question

Hi Paul,

You may also want to include notes regarding missing password files or the oratab file. These come into play sometimes, especially when cloning or recovering a database to a different server. Also, you'll want to branch on whether or not ARCHIVELOG mode is enabled, and whether the backups are RMAN backups or "regular" backups (not to mention third-party formats such as obacktrack). Recovery procedures will also vary according to whether the lost file contains active rollback segments, or if you've lost an *unarchived* redo log. There are also some more unusual cases, such as the loss of a file containing a *partition* of data, or a crash that happens when one or more tablespaces are in backup mode. I could go on ... in short, you've got an ambitious project on your hands!

By the way, I am also an amateur astronomer. I own two JMI NGT telescopes (the 6 and the 12.5) and the Orion XT-6. It's a fun hobby for our whole family (when the skies are clear, at least...).

-- 
Cheers,
Chris

___________________________________

Chris Leonard, The Database Guy
http://www.databaseguy.com

Brainbench MVP for Oracle Admin
http://www.brainbench.com

MCSE, MCDBA, OCP, CIW
___________________________________

"Paul Murphy" <pmurphy_at_scsinet.com> wrote in message
news:b6ab6d71.0404290720.6460124_at_posting.google.com...


> 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