ORA-38707: Media recovery is not enabled.

Answers were Sorted based on User's Feedback



ORA-38707: Media recovery is not enabled...

Answer / guest

Cause: An ALTER DATABASE FLASHBACK ON command failed because
media recovery was not enabled.

Action: Turn on media recovery with an ALTER DATABASE
ARCHIVELOG command and then retry the command.

Please add more information about this Error

Is This Answer Correct ?    2 Yes 0 No

ORA-38707: Media recovery is not enabled...

Answer / nimai karmakar

on mount mode

SQL>alter database archivelog;

it will solve the problem

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-07278: splon: ops$username exceeds buffer length.

1 Answers  


ORA-13757: "SQL Tuning Set" "string" is active.

1 Answers  


TNS-01409: Instance "string"

1 Answers  


ORA-32311: materialized view definition query selects an unsupported user-defined type

1 Answers  


ORA-31431: all source tables must belong to the synchronous change set

1 Answers  






NZE-28789: name type not found

1 Answers  


SQL*Loader-00516: Control file (string) has no contents

1 Answers  


ORA-14029: GLOBAL partitioned index must be prefixed

1 Answers  


LFI-00145: User buffer too short.

1 Answers  


ORA-06255: NETNTT: cannot read pid of remote process

1 Answers  


ORA-01516: nonexistent log file, datafile, or tempfile "string"

1 Answers  


ORA-23374: object group "string"."string" already exists

1 Answers  


Categories