1.问题描述:在mount状态下,关闭归档模式出现如下错误
SQL> alter database noarchivelog;
alter database noarchivelog
*
ERROR at line 1:
ORA-38774: cannot disable media recovery - flashback database is enabled
2.根据提示信息,当前数据库开启了快速闪回数据库,在闪回数据库开启的情况下,数据库必须处于归档模式,然后我查了一下我的数据库的闪回功能是否已经开启
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
YES
3.关闭数据库闪回功能
SQL> alter database flashback off;
Database altered.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
NO
4.此时可以关闭归档模式
SQL> alter database noarchivelog;
Database altered.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 6
Current log sequence 7