Log file I/O throughput

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 11 Aug 2003 10:21:00 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7040E8DC0@lnewton.leeds.lfs.co.uk>

Hi Matt,

>> Or
>> to drop the mirrored copy altogether since redundancy in built into
>> the I/O subsystem (Hitachi S.A.N).

Picture this, Oracle mirrors your logfiles and an operator, in a moment of weakness, deletes one of the mirrored copies. The remaining mirrors will not be deleted.

Now, run the same thought experiment again, but this time with OS (or SAN) mirroring, this time what happens when one of the mirrored copies gets deleted - the mirrors are also deleted leaving you with nothing.

Same applies to control files - don't let the OS mirror than unless Oracle is also mirroring.

OK, I admit the last time I tried this was on the Oracle 7 backup & recovery course, but it probably still applies.

Cheers,
Norm.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

Received on Mon Aug 11 2003 - 04:21:00 CDT