Re: Guaranteeing Full Database Recovery on a 2 Disk Server

Mark,

> I've based this on the assumption that if "DISK A" fails we can
> recover the nightly backup to a new disk (I know we don't have one yet
> but here's hoping it arrives before we have a crash!!) and roll
> forward using the archived redo logs and if "DISK B" fails we'll be
> fine until we attempt a log switch in which case the database will
> freeze.
> Both these scenarios are fine as I can accept delay and downtime while
> we look for replacement disks but I need to guanantee that should
> either fail we can fully recover.

Are you using Oracle 8i yet? If so, then you can take advantage of multiple archive log destinations. This way, you can archive to both Disk A and Disk B. Then you can spread out your tablespaces among the two physical disks. Should a disk fail, you can recover your datafiles from your backup. Since your archive log is archived to both disks, you'll always be able to recover from the one that didn't fail.

HTH,
Brian

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================