Re: RDBMS Feature Matrix (FAQ in the works !!!)
Date: 22 MAR 93 13:24:15
Message-ID: <1993Mar22.182652.24159_at_ryn.mro4.dec.com>
In article <C4Avtq.Gv1_at_unixhub.SLAC.Stanford.EDU>,
ian_at_tethys.SLAC.Stanford.EDU (Ian A. MacGregor) writes...
In response to my questions about the following Oracle features.
>|>
>In article <1993Mar22.151030.18234_at_ryn.mro4.dec.com>,
abbott_at_priory.enet.dec.com (Robert Abbott) writes:
>|>
>|> >10. Shared Log Files Y
>|> >37. Multiplexed Log Files Y
>|> >46. Multiple Log Files Y
>|> >
>|> ------------------------
>|> Robert K. Abbott
>|> abbott_at_tps.enet.dec.com
>
>Multiplexed redo log files allow the same redo log information to be written
>simultaneously to two or more online redo logs. This is a new feature
of Oracle7.
>In order to use this feature you create a logfile "group" and
place the indivdual
>log files in the group. When lgwr performs the write, it writes to
all the files
each member of a
>logfile group on a different disk. Of course you will need at
least two separate
>groups of logfiles in order for a log switch to be performed.
>
> Ian MacGregor
> Stanford Linear Accelerator Center
> (415) 926-3528
This sounds like mirroring of the log at the file level rather
than the device level. Correct? There is still only one logical
log per database, although it may have multiple physical copies.
My question was if Oracle can support two or more logfiles
per database where logfiles are not identical i.e., some logging
is directed towards one file the rest to another.
Robert K. Abbott
abbott_at_tps.enet.dec.com
Received on Mon Mar 22 1993 - 13:24:15 CET