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

|> In article <1993Mar22.151030.18234_at_ryn.mro4.dec.com>,
|> abbott_at_priory.enet.dec.com (Robert Abbott) writes:
|>
|> 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

Your analysis is correct. There is only one redo log group ONLINE at any time, and yes using groups is akin to mirroring at the file level. As I stated in my last post, you must have at least two groups (if you choose to use log file groups) so that a log file switch can be performed. There is no requirement to use groups in Oracle7. You can use the same log file setup used in Version 6.

It sounds like you want two or more groups of log files to be active at any one time. No, this is not currently possible. I cannot see how you would inform the log writer process what information to write to one group and what information to write to another.

                                Ian A MacGregor
                                Stanford Linear Accelerator Center
                                (415) 926-3528