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-00602: internal programming exception
NNL-00960: Time until cache flush: string
TNS-02506: Authentication: no type string
ORA-32772: BIGFILE is invalid option for this type of tablespace
AMD-00158: The Workspace "string" is currently open in read-only mode.
RMAN-08512: waiting for snapshot controlfile enqueue
ORA-25438: invalid variable name: string
TNS-01038: %s established:string refused:string current:string max:string state:string
ORA-03293: Cluster to be truncated is a HASH CLUSTER
ORA-15042: ASM disk "string" is missing
LFI-00137: Unable to perform string on a file object that is string.
PLS-00162: Pragma string expects 4th argument to be a positive integer literal