How to fix the Oracle error ORA-38781: cannot disable media recovery – have guaranteed restore points?

In this post, you’ll learn more about the Oracle ErrorORA-38781: cannot disable media recovery – have guaranteed restore points with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-38781: cannot disable media recovery – have guaranteed restore points

Reason for the Error ORA-38781: cannot disable media recovery – have guaranteed restore points

An attempt was made to disable media recovery while there is at least one guaranteed restore point.

How to fix the Error ORA-38781: cannot disable media recovery – have guaranteed restore points ?

You can fix this error in Oracle by following the below steps

Drop all guaranteed restore points and then disable media recovery.