ORA-38774: cannot disable media recovery – when alter database noarchivelog – flashback database is enabled

Problem:

SQL> alter database noarchivelog;

ORA-38774: cannot disable media recovery

Solution:

Turn flashback off.

alter database to noarchivelog again:

SQL> alter database flashback off;

Database altered.

SQL> alter database noarchivelog;

Database altered.