重庆思庄Oracle、Redhat认证学习论坛

标题: ORA-38774: cannot disable media recovery - flashback database is enabled [打印本页]

作者: jiawang 时间: 2020-8-27 16:57
标题: ORA-38774: cannot disable media recovery - flashback database is enabled
数据库启动到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          D:\oradata\arch11
Oldest online log sequence    227
Current log sequence          231

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)