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-01692: unable to extend lob segment string.string partition string by string in tablespace string

1 Answers  


ORA-07672: $PARSE_CLASS failed translating the string into a binary label

1 Answers  


ORA-19635: input and output filenames are identical: string

1 Answers  


SQL*Loader-00945: record size number too large for direct path

1 Answers  


PLS-00232: nested packages not permitted

2 Answers  






ORA-12690: Server Authentication failed, login cancelled

1 Answers  


LSX-00014: empty instance document

1 Answers  


CLSS-00099: logfile open failed for string, err string

1 Answers  


ORA-01185: logfile group number string is invalid

1 Answers  


SQL*Loader-00467: attribute string does not exist in type string for table string.

1 Answers  


ORA-06123: NETTCP: cannot set KEEPALIVE

1 Answers  


PROT-00012: Oracle Cluster Registry to be upgraded has an unsupported version

1 Answers  


Categories