RE: lots and lots of redo logs

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 14 Sep 2001 11:29:17 -0700
Message-ID: <F001.0038F1B2.20010914112534@fatcity.com>

!! Please do not post Off Topic to this List !!

Christopher - I for one appreciate your efforts to share your knowledge. I suppose that like most of us you have employment in addition to this list. The best most of us can manage is to jot off a quick reply without benefit of extensive research. The tradeoff as I see it is between the occasional not-quite-complete answer versus many unanswered questions. And if a point is incorrect, there is usually someone that will provide a correction. Keep up the good work!

Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, September 14, 2001 12:37 PM To: Multiple recipients of list ORACLE-L

!! Please do not post Off Topic to this List !!

I forgot the word default; I know 8 used to be the default. I tend to be doing many different things when I respond to emails. I guess it would be much easier if I didn't post at all. Not like I ever ask questions on the list.

But thanks for your flame, specially the one you sent privately stating you wish me to get kicked off the list the other day. Keep up the good work.

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax: (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863

-----Original Message-----
Sent: Friday, September 14, 2001 12:21 PM To: Multiple recipients of list ORACLE-L

!! Please do not post Off Topic to this List !!

Christopher R. Spence said:
You can only have a max of 8 log groups if I remember correctly.

Gee, I thought that the DBA controlled the maximum number of redo logs allowed for a database.
There's this thing called a database create statement: (e.g.)

CREATE DATABASE DEV

LOGFILE 'E:\Oracle\oradata\DEV\redo01.log' SIZE 16384K,
    'E:\Oracle\oradata\DEV\redo02.log' SIZE 16384K,
    'E:\Oracle\oradata\DEV\redo03.log' SIZE 16384K,
    'E:\Oracle\oradata\DEV\redo04.log' SIZE 16384K

MAXLOGFILES 16
MAXLOGMEMBERS 2
MAXLOGHISTORY 1
DATAFILE 'F:\Oracle\oradata\EMS\system01.dbf' SIZE 320M REUSE AUTOEXTEND ON NEXT 32768K
MAXDATAFILES 128
MAXINSTANCES 1
CHARACTER SET WE8ISO8859P1
NATIONAL CHARACTER SET WE8ISO8859P1; Funny, how reading the documentation or just looking at your create scripts can answer lots of questions before just simply spewing email. Personally, I try to send fewer, higher quality emails rather than dozens of things that are the first thing that pops into my head.

Paul

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Drake
INET: drake_at_psscorp.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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Christopher Spence
INET: cspence_at_FuelSpot.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------