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 |
NNL-00045: No host given for LDAP server
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
DRG-11708: too many thesauri
NNL-00279: Restart occurs in string
AMD-00121: dimension #string: analytic workspace hierarchy not specified
PCC-02011: found identifier greater than 128 characters (truncated)
NNO-00612: enabling request forwarding
ORA-02294: cannot enable (string.string) - constraint changed during validation
ORA-16013: log string sequence# string does not need archiving
ORA-03112: a server linked as single-task cannot use SQL*Net
ORA-19717: for non-OMF search the pattern must be specified
ORA-36696: (XSRELTBL02) QDR dimension workspace object should not be the related dimension of the relation.