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

RMAN-10033: error during compilation of job step number: string

1 Answers  


ORA-30676: socket read or write failed

1 Answers  


NNL-00040: Distinguished Name exceeds buffer length: string

1 Answers  


ORA-23387: replication parallel push dequeue error

1 Answers  


LSX-00211: value "~1S" whose fractional digits exceeds ~2d

1 Answers  






ORA-23393: the user is already the propagator

1 Answers  


SQL*Loader-00651: error skipping lob for column string, row number, table string

1 Answers  


ORA-16713: The resource guard timed out while servicing the request.

1 Answers  


ORA-38470: cannot revoke a privilege that was not granted.

1 Answers  


ORA-08005: specified row does not exist

1 Answers  


NNL-01073: Administrative region description: string

1 Answers  


ORA-38501: sub-query not allowed in the expression

1 Answers  


Categories