IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get ” ORA-38707: Media recovery is not enabled. ” error.
Details of error are as follows.
ORA-38707: Media recovery is not enabled.Cause: An ALTER DATABASE FLASHBACK ON command failed because media recovery was not enabled.
Action: Turn on media recovery with an ALTER DATABASE ARCHIVELOG command and then retry the command.
SQL> alter database flashback on;
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38707: Media recovery is not enabled.
alter database flashback on
*
ERROR at line 1:
ORA-38706: Cannot turn on FLASHBACK DATABASE logging.
ORA-38707: Media recovery is not enabled.
You can read the following post to learn what is the Archivelog mode and how to enable it.
Oracle Database Enable Archivelog Mode and Archivelog Deletion and Generation Frequency
Turn database in archivelog mode as mentioned in the above post.
SQL> alter database archivelog; Database altered.
Then try again as follows.
SQL> alter database flashback on; Database altered. SQL> SQL> alter database open; Database altered. SQL>
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
