Recovery Area is not enabled.

[filmphotograph]

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.

setting DB_RECOVERY_FILE_DEST to directory - leading to broken parameters and database did not start:

SQL> alter database mount; alter database mount * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksfd_odmchkpathattr], [ORA-00001: unique constraint (.) violated], [], [], [], [], [], [], [], [], [], [] ORA-17503: ksfdopn:13 Failed to open file /opt/oracle/oradata/fast_recovery_area ORA-17500: ODM err:Operation not permitted

kubectl -n oracle patch singleinstancedatabase sidb-sample --type merge -p '{"spec":{"flashBack": true}}' singleinstancedatabase.database.oracle.com/sidb-sample patched (no change)

kubectl -n oracle get singleinstancedatabase sidb-sample -o "jsonpath=[{.status.archiveLog}, {.status.flashBack}, {.status.forceLog}]" [true, false, true]root@master:~/deployments/oracle#

[IshaanDesai45]

Hi @filmphotograph so you are trying to switch on the flasback is not working via the kubectl patch command. I would recommend you give a try with the new Oraoperator release 1.1.0

[IshaanDesai45]

@filmphotograph does the problem still persists in v1.1.0 ?