Sunday, 5 July 2020

ORA-38774: cannot disable media recovery - flashback database is enabled

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

SQL> Select name from v$restore_point;

no rows selected

SQL> select NAME,FLASHBACK_ON from v$database;

NAME             FLASHBACK_ON
---------         ------------------
ProdDB01              YES

SQL> alter database flashback off;

Database altered.

SQL>  alter database noarchivelog;

Database altered.

No comments:

Post a Comment