SQL> ALTER DATABASE FLASHBACK ON; ALTER DATABASE FLASHBACK ON * ERROR at line 1: ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area is not enabled.问题分析 根据报错信息来看,无法启用闪回数据库日志,因为恢复区(Recovery Area)未启用。
SQL> alter database archivelog; Database altered. SQL> alter database flashback on; alter database flashback on * ERROR at line 1: ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area is not enabled. SQL> select log_mode from v$database; LOG_MODE --- ARCHIV...