search

oracle / oracle-database-operator

The Oracle Database Operator for Kubernetes (a.k.a. OraOperator) helps developers, DBAs, DevOps and GitOps teams reduce the time and complexity of deploying and managing Oracle Databases. It eliminates the dependency on a human operator or administrator for the majority of database operations.
Universal Permissive License v1.0
140 stars 45 forks source link

Recovery Area is not enabled. #87

Open filmphotograph opened 7 months ago

filmphotograph commented 7 months ago

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 commented 4 months ago

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 commented 3 months ago

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