0

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_DEST and 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.

2

How many redo log members for each group can I define?

Database Limits

MAXLOGMEMBERS

  • Default: 2
  • Maximum Value : 5

How many control files can I use by using the standard edition (one)? I couldn't find this information except, that there can be 8 control files at all.

That is correct. CONTROL_FILES

  • Range of values:1 to 8 filenames

I've read, that I can have only two archive log destinations defined by LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST in the standard edition (one).

LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST are deprecated long ago. LOG_ARCHIVE_DEST_N is available since 8.1 in EE, and 10.1 in SE. You can define up to 31 destinations, but only the first 10 can be local. Remote destinations are not supported in SE.

  • I am confused about you saying log LOG_ARCHIVE_DEST and LOG_ARCHIVE_DUPLEX_DEST are deprecated at all. Here link you can read, that those two parameters are deprecated for enterprise edition users only. I also have read, that standard edition (one) user have to use those two. – SethM Nov 29 '16 at 17:58
  • About the amount of redo log member per group and the amount of control files: Do I understand it in the right way, that standard edition (one) users can use the maximum values you have mentioned (redo: max 5 per group; cf: 8 files) without any limitation? Or is there any limitation in number compared to the enterprise edition? – SethM Nov 29 '16 at 18:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.