ORA-38706: Cannot turn on FLASHBACK DATABASE logging. 해결

OS환경 : Oracle Linux6.8(64bit)

DB 환경 : Oracle Database 12.2.0.1

에러 : flashback database on 시 발생하는 에러

#적용

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.

 

해결 방법 : db_recovery_file_dest, db_recovery_file_dest_size 파라미터를 설정해준다.

SQL> alter system set db_recovery_file_dest_size=2g scope=spfile;

 

System altered.

 

SQL> alter system set db_recovery_file_dest='/u01/arch' scope=spfile;

 

system altered.

#db 재기동 

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.

Total System Global Area 1241513984 bytes

Fixed Size     8620176 bytes

Variable Size   452986736 bytes

Database Buffers   771751936 bytes

Redo Buffers     8155136 bytes

Database mounted.

Database opened.

#다시 적용

SQL> alter database flashback on;

 

Database altered.

#확인 

SQL>  select flashback_on from v$database;

 

FLASHBACK_ON

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

YES

 

원인 : 플래시백을 위한 파라미터가 미적용되어있어서 발생하는 오류

참조 : http://dbaclass.com/article/ora-38706-cannot-turn-on-flashback-database-logging/