ORA-38775: cannot disable flash recovery area - flashback
database is enabled
Answers were Sorted based on User's Feedback
Answer / lance
shutdown database first;
startup mount exclusive;
then issue ALTER DATABASE FLASHBACK OFF
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / guest
Cause: An attempt was made to set DB_RECOVERY_FILE_DEST to
null while flashback database was enabled. Flashback
database requires DB_RECOVERY_FILE_DEST to be set.
Action: Use the ALTER DATABASE FLASHBACK OFF statement to
disable flashback database, then disable the flash recovery
area.
Please add more information about this Error
| Is This Answer Correct ? | 2 Yes | 0 No |
ORA-00280: change string for thread string is in sequence #string
ORA-01542: tablespace 'string' is offline, cannot allocate space in it
ORA-38461: XML Tag "string" already exists for the XMLType attribute "string"
ORA-32052: failed to start mapping service
ORA-29304: tablespace 'string' does not exist
DGM-16904: Unable to set attribute
QSM-01082: Joining materialized view, string, with table, string, not possible
PROC-00029: Error in logging layer
ORA-00313: open failed for members of log group string of thread string
ORA-30686: no dispatcher accepted TCP/IP connection request
ORA-02077: selects of long columns must be from co-located tables
ORA-13609: The specified task string must be executing to be cancelled or interrupted.