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

CLSR-00521: Event string is rejected by EVM daemon

1 Answers  


ORA-30679: JDWP-based debugging not supported in this configuration

1 Answers  


PROC-00026: Error while accessing the physical storage

1 Answers  


ORA-30725: JDWP-based debugging is not yet available

1 Answers  


ORA-01597: cannot alter system rollback segment online or offline

1 Answers  






ORA-13417: null or invalid layerNumber for get functions

1 Answers  


ORA-22308: operation not allowed on evolved type

1 Answers  


QSM-01061: illegal query expression

1 Answers  


ORA-35180: (SNSYN103) The format of the OUTFILE command is: OUTFILE [APPEND] {EOF | TRACEFILE | filename [NOCACHE] [NLS_CHARSET name]}

1 Answers  


PLS-00541: size or length specified is too large.

1 Answers  


ORA-01696: controlfile is not a clone controlfile

1 Answers  


RMAN-04000: memory allocation failure

1 Answers  


Categories