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-37070: You may not execute OLAP DML programs in a parallel query session.
ORA-08448: syntax error in DECIMAL-POINT environment clause
ORA-01881: timezone region id number is invalid
NNO-00600: warning: forwarder count number exceeds maximum of number, first number will be loaded
ORA-19585: premature end of volume on piece string
RMAN-06179: datafile number not processed because file is read-only
PCC-02438: Arrays of collection objects are not allowed
ORA-00163: internal database name length string is greater than maximum (string)
ORA-29289: directory access denied
ORA-06112: NETTCP: invalid buffer size
ORA-06536: IN bind variable bound to an OUT position
AMD-00140: internal error: [string] [string] [string] [string] [string]