Re: lots and lots of redo logs

From: Paul Drake <drake_at_psscorp.com>
Date: Fri, 14 Sep 2001 08:46:16 -0700
Message-ID: <F001.0038EAB5.20010914082039@fatcity.com>

!! 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).

Received on Fri Sep 14 2001 - 10:46:16 CDT