ORA-38774 while disable archive

ORA-38774 while disable archive
Symptom:
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
——— ——————
cdb01 YES

Solution:
SQL> alter database flashback off;
SQL> select name,flashback_on from v$database;
NAME FLASHBACK_ON
——— ——————
cdb01 NO
SQL> Alter database noarchivelog;
SQL> SQL> SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +ARCH
Oldest online log sequence 458
Current log sequence 461

Leave a Reply

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