Skip to Main Content
  • Questions

  • Critical Production Databases running on Standard editions

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, hari.

Asked: January 23, 2018 - 10:44 am UTC

Last updated: January 25, 2018 - 1:50 am UTC

Version: 11.2.0.4

Viewed 1000+ times

You Asked

Dear Tom
Please explain the consequences of running a production database on Standard edition and no-archivelog mode.

Regards
Hari

and Connor said...

"running a production database on Standard edition"

Absolutely no problem. Standard edition is just as rock solid as the Enterprise in terms of core features (reliability etc). It is only if you need the extended features of Enterprise Edition that you would make the additional investment. Many, many customers run critical production systems on Standard edition.

"running a production database on no-archivelog mode"

Is an absolute no. Don't do it. Ever.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

A reader, January 24, 2018 - 5:42 pm UTC

"Please explain the consequences..."

You will lose a bunch of data someday in the near future. I sure hope Hari is not a DBA asking a question like that.
Connor McDonald
January 25, 2018 - 1:50 am UTC

Let's not be critical.

He might be a *new* DBA, so its fine to ask that question.


more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Administration

Need more information on Administration? Check out the Administrators guide for the Oracle Database