PROBLEM:

While disabling archive log mode, got the error – ORA-38774

 

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

 

SOLUTION:

The error is because flashback mode is enabled in the database. So before disabling archive log mode, we need to disable flashback mode in database and drop restore points if any.

 

1. Drop restore point if any :

2. Disable flashback mode

3. Now try to put the database in noarchivelog mode.

SEE – COLLECTION OF DATABASE MONITORING SCRIPT