Re: Re: RAID 5 vs RAID 0

From: Roelof K. Salomons <roelofs_at_ic.uva.nl>
Date: Wed, 3 Jan 2001 13:59:38 +0100
Message-ID: <92v7np$8ro$1@mail.ic.uva.nl>

Kelly-Anne,

It is best to have a small disk for your offline ARCHIVE logs(assuming you're running in log mode). Datafile are on RAID.

Now, if your RAID crashes(don't say this never happens !), you are able to do a complete recovery by:
1. Restoring datafiles from tape or whatever to RAID 2. Applying archive logs from tape and the most recent ones from the NON-RAID disk

If the archive disk crashes, no problem, but do make a backup of the datafiles immediately, because your
recent work is not in the archive logs.

Concerning your ONLINE redo logs, it is also wise to duplicate them on a small disk.

Roelof K. Salomons
Database Administrator UvA
tel : 020 5252383
mobiel: 06 22126701
email: dba_at_ic.uva.nl
"Kelly-Anne Frendo" <kfrendo_at_bvb.gi> schreef in bericht news:A3C801763DAFD411A57900508B9AAF972922_at_HEARTOFGOLD...
> From Sybrand Bakker's mail,
> "Main conclusion : don't put redolog files on RAID 5"
>
> However, I do not understand why not.
> Can anyone explain this to me?
> Thanks
> K.
>
> --
> Posted from stan.gibnet.gi [195.166.192.3]
> via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Wed Jan 03 2001 - 06:59:38 CST