数据库打开了FLASHBACK后，如要关闭achivelog要先取消FLASHBACK

2011-12-21

SQL> select * from v$version;

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

数据库启动到MOUNT状态：

SQL> alter database noarchivelog;

alter database noarchivelog

*

ERROR at line 1:

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

SQL> select flashback_on from v$database;

FLASHBACK_ON

------------------

YES

SQL> alter database flashback off;

Database altered.

SQL> alter database noarchivelog;

Database altered.

SQL> archive log list

Database log mode              No Archive Mode

Automatic archival             Disabled

Archive destination            L:\oradata\test\arch11

Oldest online log sequence     227

Current log sequence           231