Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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

TNS-12523: TNS:listener could not find instance appropriate for the client connection

1 Answers  


ORA-24808: streaming of lob data is not allowed when using lob buffering

1 Answers  


ORA-00079: variable string not found

1 Answers  


ORA-28028: could not authenticate remote server

1 Answers  


ORA-30348: ADD and DROP cannot both be specified

1 Answers  






ORA-13159: Oracle table string already exists

1 Answers  


KUP-04069: error fetching data for external table

1 Answers  


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

0 Answers  


ORA-16806: Supplemental logging is not turned on.

1 Answers  


RMAN-01008: the bad identifier was: string

1 Answers  


LPX-00003: duplicate entry in hash table

1 Answers  


PCB-00903: Pro*COBOL is unable to initialize its parser function

1 Answers  






Categories