:

ORA-38785: Media recovery must be enabled for guaranteed restore point

The Problem

You want to use the Flashback Database feature and are trying to create a guaranteed restore point before you carry out any work. As you attempt to create the guarantee restore point you get the ORA-38785: Media recovery must be enabled for guaranteed restore point error message.

The Cause

The database is not in archivelog mode.

The Solution

Put your database in archivelog mode. You can read the other article to see how to do this, or put simply, do the following:

SHUTDOWN IMMEDIATE
STARTUP MOUNT
ALTER DATABASE ARCHIVELOG;

You may also be receiving similar errors such as ORA-16433: The database must be opened in read/write mode or ORA-38757: Database must be mounted and not open to FLASHBACK

Like it, share it...

Category: Flashback


Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *