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-03290: Invalid truncate command - missing CLUSTER or TABLE keyword
QSM-02122: compatibility mode must be 8.1 or higher
ORA-19554: error allocating device, device type: string, device name: string
PLS-00725: type 'string' must be a supertype or subtype of the TREAT expression
SQL-02122: Invalid OPEN or PREPARE for this database connection
ORA-14640: add/coalesce index partition operation is valid only for hash partitioned global indexes
DRG-10705: invalid value string for attribute string
ORA-01490: invalid ANALYZE command
ORA-40204: model string already exists
ORA-29287: invalid maximum line size
ORA-32808: message system link string does not exist
RMAN-06485: changed archivelog expired