Re: RDBMS Feature Matrix (FAQ in the works !!!)

In article <C4Avtq.Gv1@unixhub.SLAC.Stanford.EDU>, ian@tethys.SLAC.Stanford.EDU (Ian A. MacGregor) writes... >In article <1993Mar22.151030.18234@ryn.mro4.dec.com>, abbott@priory.enet.dec.com (Robert Abbott) writes: >|> In response to my questions about the following Oracle features. >|> >|> >10. Shared Log Files Y >|> >37. Multiplexed Log Files Y >|> >46. Multiple Log Files Y >|> > >|> ------------------------ >|> Robert K. Abbott >|> abbott@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 >in the group simultaneously. The idea of course is to place 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@tps.enet.dec.com