I am planing to dive into the oracle database world. Since the oracle database is such a complex machine, I want to inform myself as good as possible, before I start. I have some questions.
How many redo log members for each group can I define and how many control files can I use by using the standard edition (one)?
I've read, that I can have only two archive log destinations defined by
LOG_ARCHIVE_DUPLEX_DEST in the standard edition (one). Now I am wondering, if there is any limitation by multiplexing redo log members and control files by using the standard edition (one) ?
I couldn't find this information except, that there can be 8 control files at all.