[oracle]ORA-38707: Media recovery is not enabled.

问题: 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

 

[oracle]ORA-38707: Media recovery is not enabled.

上一篇:asp.net 自带ajax 控件的小实例


下一篇:SQL Server 数据库清空ldf日志文件