问题: ORA-38707: Media recovery is not enabled.
SQL> alter database flashback on ; alter database flashback on * ERROR at line 1: ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38707: Media recovery is not enabled.
原因:开启FLASHBACK DATABASE数据库必为归档模式
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 1593832664 bytes Fixed Size 9135320 bytes Variable Size 1023410176 bytes Database Buffers 553648128 bytes Redo Buffers 7639040 bytes Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> select flashback_on from v$database; FLASHBACK_ON ------------------ NO SQL> alter database flashback on ; Database altered. SQL> select NAME,value from v$parameter where name = ‘db_flashback_retention_target‘ or name = ‘db_recovery_file_dest‘ or name = ‘db_recovery_file_dest_size‘; NAME -------------------------------------------------------------------------------- VALUE -------------------------------------------------------------------------------- db_recovery_file_dest /oracle/D4C/recovery_area db_recovery_file_dest_size 13350469632 db_flashback_retention_target 1440