ORA-38775: cannot disable flash recovery area - flashback
database is enabled

Answers were Sorted based on User's Feedback



ORA-38775: cannot disable flash recovery area - flashback database is enabled..

Answer / lance

shutdown database first;
startup mount exclusive;
then issue ALTER DATABASE FLASHBACK OFF

Is This Answer Correct ?    4 Yes 1 No

ORA-38775: cannot disable flash recovery area - flashback database is enabled..

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

Post New Answer

More Oracle Errors Interview Questions

ORA-01073: fatal connection error: unrecognized call type

1 Answers  


LSX-00229: item type is not a valid type for a list simple type

1 Answers  


ORA-14519: Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]

1 Answers  


PCC-02132: CMD-LINE: Could not allocate memory

1 Answers  


ORA-27546: Oracle compiled against IPC interface version string.string found version string.string

1 Answers  






ORA-07493: scgrcl: lock manager error.

1 Answers  


NID-00312: Connected to server version string

1 Answers  


TNS-00215: Total Successful Connections : number

1 Answers  


ORA-09909: Malloc of scratch buffer failed.

1 Answers  


ORA-30375: materialized view cannot be considered fresh

1 Answers  


ORA-01625: rollback segment 'string' does not belong to this instance

1 Answers  


ORA-31468: cannot process DDL change record

1 Answers  


Categories