ORA-01239: database must be in ARCHIVELOG mode to use
external cache



ORA-01239: database must be in ARCHIVELOG mode to use external cache..

Answer / guest

Cause: An online file uses an external cache, but the
database is in NOARCHIVELOG mode. Since an external cache
may require media recovery this can not be allowed.

Action: Change database to be in ARCHIVELOG mode or do not
use an external cache.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31692: The following SQL statement failed trying to insert a row into the Master table: string

1 Answers  


ORA-04042: procedure, function, package, or package body does not exist

1 Answers  


ORA-24775: cannot prepare or commit transaction with non-zero lock value

1 Answers  


PLS-00148: Only 1 pragma of this type is allowed per subprogram

1 Answers  


ORA-14135: a LOB column cannot serve as a partitioning column

1 Answers  






ORA-37130: (XSCCOMP05) Cannot aggregate VARIABLE workspace object using AGGMAP workspace object because there is a PRECOMPUTE clause on a RELATION over the base of a COMPRESSED COMPOSITE.

1 Answers  


PLS-00548: invalid use of operator.

1 Answers  


ORA-01271: Unable to create new file name for file string

1 Answers  


ORA-16767: Logical apply service unexpectedly online

1 Answers  


TNS-01188: Listener cannot operate with incompatible transport protocols

1 Answers  


ORA-16813: apply service not running on the apply instance string recorded by the broker

1 Answers  


ORA-13618: The value string is not a valid value for procedure argument string.

1 Answers  


Categories