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

PLS-00331: illegal reference to string

1 Answers  


ORA-24317: define handle used in a different position

1 Answers  


IMP-00040: FILESIZE does not match the value used for export: string

1 Answers  


ORA-28541: Error in HS init file on line number.

1 Answers   IES,


ORA-09873: TASDEF_OPEN: open error when opening tasdef@.dbf file.

1 Answers  






ORA-02727: osnpop: access error on orapop executable

1 Answers  


ORA-06116: NETTCP: unable to create ORASRV process

1 Answers  


NID-00101: LOGFILE (string) not accessible

1 Answers  


ORA-39051: parameter string specified multiple times

1 Answers  


ORA-24089: AQ Agent string already exists

1 Answers  


ORA-30188: reserved for future use

1 Answers  


ORA-19361: ONLINE option not allowed with this type of index

1 Answers  


Categories