Skip to Main Content
  • Questions

  • alter database noarchivelog versus flashback

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, lei.

Asked: June 07, 2018 - 2:33 pm UTC

Last updated: June 11, 2018 - 6:58 am UTC

Version: 11.2.0.3

Viewed 1000+ times

You Asked


SQL> alter database noarchivelog;
alter database noarchivelog
*
ERROR at line 1:
ORA-38774: cannot disable media recovery - flashback database is enabled

and Connor said...

Yes that is correct. Flashback needs archivelog to be on. If you want to turn off archivelog, then you need to turn off flashback first.

But I'd leave archivelog on for *every* database. A database is so much more useful when archivelog is on.

Is this answer out of date? If it is, please let us know via a Comment
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

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.