oracle / oracle/oracle-database-operator

Recovery Area is not enabled.

Open
#87 3 comments 0 reactions 1 assignee View on GitHub

Nobody has claimed this yet.

question sidb
Dominant language
Go
Stars
192
Forks
69
Avg merge
16h 13m
Merged PRs (30d)
1

Description

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#

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.