Re: Redo logs on mirrored disks

--0__=fqMtHcyuyEer0v9px21aW8Mg1391gP7zkAE8ASzSNLTUDEyDCOagIvtC Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Hi Chris ...

Any info you can provide on past problems would be appreciated. Getting ready to add some disks, and move some things around, and I need to decide whether to continue mirroring and duplexing, or choose one or the other.

Fortunately, my SA is excellent: monitors everything, and never touches Oracle without talking to me, but I can't take any unnecessary chances with this database either.

Robyn

Chris Royce <Chris_at_Royce.net> on 06/12/2000 05:00:58 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Robyn Sands/US1/Lend Lease)

Subject: Re: Redo logs on mirrored disks

I run my Production databases on RAID 0+1 with the redo logs NOT duplexed. No problems in a number of years. I have had a couple of problems, however, with duplexed redo logs. Explanations on request.

Chris Royce
Jamestown NC

rsands_at_lendleaserei.com wrote:

> listers,
>
> Reading through Steve Adams web site, I came across
> the tip that says redo logs should be mirrored or
> multiplexed, but there is no need to do both. The
> explanation makes sense, but I have never run a
> production database without multiplexing redo logs,
> and the thought of doing so is a little scary!! I
> wanted to find out how many other DBA's have taken
> this approach, and if you've tried it, how much of
> performance difference have you seen? Is there any
> increased risk of data loss?
>
> TIA ... Robyn Sands
>
> --
> Author:
> INET: rsands_at_lendleaserei.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

--0__=fqMtHcyuyEer0v9px21aW8Mg1391gP7zkAE8ASzSNLTUDEyDCOagIvtC Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFkb2N0eXBlIGh0bWwgcHVibGljICItLy93M2MvL2R0ZCBodG1sIDQuMCB0cmFuc2l0aW9uYWwv L2VuIj4NCjxodG1sPg0KSSBydW4gbXkgUHJvZHVjdGlvbiBkYXRhYmFzZXMgb24gUkFJRCAwKzEg d2l0aCB0aGUgcmVkbyBsb2dzIDx1Pk5PVDwvdT4NCmR1cGxleGVkLiBObyBwcm9ibGVtcyBpbiBh IG51bWJlciBvZiB5ZWFycy4gSSBoYXZlIGhhZCBhIGNvdXBsZSBvZiBwcm9ibGVtcywNCmhvd2V2 ZXIsIHdpdGggZHVwbGV4ZWQgcmVkbyBsb2dzLiBFeHBsYW5hdGlvbnMgb24gcmVxdWVzdC4NCjxw PkNocmlzIFJveWNlDQo8YnI+SmFtZXN0b3duIE5DDQo8cD5yc2FuZHNAbGVuZGxlYXNlcmVpLmNv bSB3cm90ZToNCjxibG9ja3F1b3RlIFRZUEU9Q0lURT5saXN0ZXJzLA0KPHA+UmVhZGluZyB0aHJv dWdoIFN0ZXZlIEFkYW1zIHdlYiBzaXRlLCBJIGNhbWUgYWNyb3NzDQo8YnI+dGhlIHRpcCB0aGF0 IHNheXMgcmVkbyBsb2dzIHNob3VsZCBiZSBtaXJyb3JlZCBvcg0KPGJyPm11bHRpcGxleGVkLCBi dXQgdGhlcmUgaXMgbm8gbmVlZCB0byBkbyBib3RoLiZuYnNwOyBUaGUNCjxicj5leHBsYW5hdGlv biBtYWtlcyBzZW5zZSwgYnV0IEkgaGF2ZSBuZXZlciBydW4gYQ0KPGJyPnByb2R1Y3Rpb24gZGF0 YWJhc2Ugd2l0aG91dCBtdWx0aXBsZXhpbmcgcmVkbyBsb2dzLA0KPGJyPmFuZCB0aGUgdGhvdWdo dCBvZiBkb2luZyBzbyBpcyBhIGxpdHRsZSBzY2FyeSEhJm5ic3A7IEkNCjxicj53YW50ZWQgdG8g ZmluZCBvdXQgaG93IG1hbnkgb3RoZXIgREJBJ3MgaGF2ZSB0YWtlbg0KPGJyPnRoaXMgYXBwcm9h Y2gsIGFuZCBpZiB5b3UndmUgdHJpZWQgaXQsIGhvdyBtdWNoIG9mDQo8YnI+cGVyZm9ybWFuY2Ug ZGlmZmVyZW5jZSBoYXZlIHlvdSBzZWVuPyZuYnNwOyBJcyB0aGVyZSBhbnkNCjxicj5pbmNyZWFz ZWQgcmlzayBvZiBkYXRhIGxvc3M/DQo8cD5USUEmbmJzcDsgLi4uJm5ic3A7IFJvYnluIFNhbmRz DQo8cD4tLQ0KPGJyPkF1dGhvcjoNCjxicj4mbmJzcDsgSU5FVDogcnNhbmRzQGxlbmRsZWFzZXJl aS5jb20NCjxwPkZhdCBDaXR5IE5ldHdvcmsgU2VydmljZXMmbmJzcDsmbmJzcDsmbmJzcDsgLS0g KDg1OCkgNTM4LTUwNTEmbmJzcDsNCkZBWDogKDg1OCkgNTM4LTUwNTENCjxicj5TYW4gRGllZ28s IENhbGlmb3JuaWEmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgLS0N ClB1YmxpYyBJbnRlcm5ldCBhY2Nlc3MgLyBNYWlsaW5nIExpc3RzDQo8YnI+LS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0N Cjxicj5UbyBSRU1PVkUgeW91cnNlbGYgZnJvbSB0aGlzIG1haWxpbmcgbGlzdCwgc2VuZCBhbiBF LU1haWwgbWVzc2FnZQ0KPGJyPnRvOiBMaXN0R3VydUBmYXRjaXR5LmNvbSAobm90ZSBFWEFDVCBz cGVsbGluZyBvZiAnTGlzdEd1cnUnKSBhbmQgaW4NCjxicj50aGUgbWVzc2FnZSBCT0RZLCBpbmNs dWRlIGEgbGluZSBjb250YWluaW5nOiBVTlNVQiBPUkFDTEUtTA0KPGJyPihvciB0aGUgbmFtZSBv ZiBtYWlsaW5nIGxpc3QgeW91IHdhbnQgdG8gYmUgcmVtb3ZlZCBmcm9tKS4mbmJzcDsgWW91DQpt YXkNCjxicj5hbHNvIHNlbmQgdGhlIEhFTFAgY29tbWFuZCBmb3Igb3RoZXIgaW5mb3JtYXRpb24g KGxpa2Ugc3Vic2NyaWJpbmcpLjwvYmxvY2txdW90ZT4NCjwvaHRtbD4NCg0K Received on Tue Jun 13 2000 - 09:07:11 CDT